Google+ Followers


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


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