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

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

Anup - Friday, May 20, 2011
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

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me