Complete Recovery when SYSTEM tablespace is missing.

Problem Generation

Delete system tablespace datafile from operating system when database is up and running.

[oracle@odb]$ rm -i /u01/app/oracle/oradata/disk3/ocmdb/system01.dbf


Solution



i. [oracle@odb]$ sqlplus / as sysdba
ii. SQL> SHUTDOWN abort;
iii. SQL> STARTUP mount;
iv. SQL> SELECT file#, name FROM v$datafile;

v. Using rman connect to target database and catalog database or directly to target database.



[oracle@odb]$ rman target /




vi.  RMAN> run
{
 restore datafile 1;
 recover datafile 1;
 sql ‘ alter database open ‘;
}