Google News
logo
Oracle - Interview Questions
How will you recover a lost control file?
Steps to recover a lost control file are :
 
* Start the database in the NOMOUNT mode
* Create the control file from the control file backup with CREATE CONTROLFILE statement, and place it in the correct location.
* Mount the database
* Recover the database
* Open the database
Advertisement