Recovery of a database using RMAN from controlfile loss (controlfile autobackup setting not enabled)


This is the case when you have not enabled the controlfile autobackup setting in the RMAN setting,follow the steps to recover your database from such a situation


Step 1)_shutdown the database with immediate option

Step 2)_connect to RMAN and nomount the DB

Step 3)_restore controlfile from backup piece,restore the controlfile by giving the path location of the backup piece where the controlfile gets backed up,you can get this location by reading the log file for the RMAN backup

Step 4)_mount the  DB using alter database mount command

Step 5)_restore DB to bring datafiles to current state

Step 6)_recover the database

Step 7)_alter database open resetlogs to open the db

You have now successfully recovered from controlfile loss (controlfile autobackup setting not enabled) situation using RMAN

NOTE-Take full backup after opening the DB