Case 2: If All Control files loss or corrupted and you have no backup

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