If All Control file loss or corrupted and you have control file backup by using alter database backup control file to trace command. Then startup database with nomount option and create controlfile from trace file scripts and recover database and open the database.


Step 1 Shutdown database with abort options

SQL> shutdown abort

Step 2 Startup the database with nomount option

SQL> startup nomount

Step3 Create controlfie from trace file backup scripts

Step 3 Recover database

SQL> recover database using backup controlfile;
SQL> recover database using backup controlfile until cancel;

Step 4 Open the database