If All Control files loss or corrupted and you have no backup (Also you have not taken control backup by using alter database backup controlfile to tarce command). In this case, we will have to restore cold backup and recover.
Step 1 Shutdown database with abort options
SQL> shutdown abort
Step 2 Startup the database with nomount option
SQL> startup nomount
Step 3 Recover database
SQL> recover database using backup controlfile;
SQL> recover database using backup controlfile until cancel;
Step 4 Open the database
Step 1 Shutdown database with abort options
SQL> shutdown abort
Step 2 Startup the database with nomount option
SQL> startup nomount
Step 3 Recover database
SQL> recover database using backup controlfile;
SQL> recover database using backup controlfile until cancel;
Step 4 Open the database
Post a Comment