Friday, June 24, 2011

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

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget