Recovery if all controlfiles are missing


Problem Generation
i. Shutdown Database.
SQL> SHUTDOWN immediate;
ii. Delete all Control files from operating system
[oracle@anar]$ rm -i /u01/app/oracle/oradata/disk1/anardb/control01.ctl
[oracle@anar]$ rm -i /u01/app/oracle/admin/anardb/control/control02.ctl
iii. Connect as sysdba and startup Database.
[oracle@anar]$ sqlplus / as sysdba
SQL> STARTUP;
ORACLE instance started.
Total System Global Area 536870912 bytes
Fixed Size 1220460 bytes
Variable Size 222298260 bytes
Database Buffers 310378496 bytes
Redo Buffers 2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info
Solution
i. Using RMAN restore contolfile from Autobackup and Recover Database
RMAN> run
{
restore controlfile from autobackup;
sql ‘ alter database mount’;
recover database;
sql ‘ alter database open resetlogs’;
}
ii. List Database Incarnation
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
——— ——— ———— ———————— — ————— —————
1 2 anardb 4083722939 PARENT 1 01-JAN-14
1 1415 anardb 4083722939 PARENT 503961 14-JAN-11
1 1867 anardb 4083722939 CURRENT 519078 14-JAN-11
iii. After database is open switch logfile few times
SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> ALTER SYSTEM SWITCH LOGFILE;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: