Recovery of a database using RMAN from controlfile loss


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

Step 1)_shutdown the database immediate

Step 2)_start the db in nomount state

Step 3)_connect to the rman and restore controlfile from autobackup

Step 4)_mount the db

Step 5)_restore the database to apply all the latest changes

Step 6)_recover the database

Step 7)_alter database open resetlogs to open the db

NOTE-perform full database backup immediatly after opening the db