Google+ Followers

Pages

Saturday, May 19, 2012

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 ‘;
}

No comments:

Post a Comment