Disaster Recovery - LOSS OF SYSTEM AND CONTROLFILE

SQL> startup

ORACLE instance started.

Total System Global Area  612368384 bytes

Fixed Size                  1292036 bytes

Variable Size             415238396 bytes

Database Buffers          188743680 bytes

Redo Buffers                7094272 bytes

ORA-00205: error in identifying control file, check alert log for more info

 

Step 1: Using RMAN

C:\Users\RMAN TARGET \

RMAN> STARTUP;

connected to target database (not started)

RMAN> SET DBID=1276854982

executing command: SET DBID

RMAN>RESTORE CONTROLFILE FROM AUTOBACKUP;

(WE SHOULD CONFIGURE CONTROLFILE AUTOBACKUP ON)

Finished restore

RMAN>ALTER DATABASE MOUNT;

database mounted

released channel: ORA_DISK_1

RMAN>RESTORE DATABASE;

RMAN>RECOVER DATABASE;

RMAN>ALTER DATBASE OPEN RESETLOGS;

Apps Dba Free Lance

Sukhwinder Singh