Question

How will you recover a lost control file?

Answer 1

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.

1. Mount the database
2. Recover the database
3. Open the database