User Managed Recovery - controlfile


Scenario 1

Steps for control file incomplete recovery :

Simulate failure (we assume that hot backup is already taken). Without shutting down the database, delete database control file at OS level


Step 1 : Check the controlfile path



Step 2 : Take the backup of the controlfile



Step 3 : Remove the controlfile when the database is running



Step 4 : Shut down the database



Step 5 : Copy the controlfiles from the backup



Step 6 : Start the database to mount



Step 7 : Recover the database. Give the current logfile path when prompt



Step 8 : Open the database




Scenario 2

Steps for control file complete recovery :

Step 1 : Take the controlfile backup in sql format to the desired location



Step 2 : Remove the controlfile when the database is running



Step 3 : Shut down the database



Step 4 : Copy the below content from sql to new file



Step 5 : Start the database to mount



Step 6 : Run the newly created sql file



Step 7 : Open the database




Note:
After creating control files using above procedure, there will be no SCN in that. So server process will write the latest SCN to control files in this situation by taking info from datafile header.

(User Managed Recovery - System datafile)