How to Recover Using Backup Control File

If your Oracle database fails, you can recover it using the backup control file. All Oracle databases have a built-in control file, which contains a record of the database's data and structure. Among information contained in the control file are the name of the database, timestamps and the locations of data files in the database. Use the "Restore Controlfile" command to recover the database.

Instructions

1. Click "Start" and select "All Programs," "Accessories" and "Command Prompt." The Command Prompt window opens.

2. Type "SQL*Plus user name/password " at the command prompt, where user name and password are the login information to connect to the Oracle database.

3. Type "STARTUP NOMOUNT" at the command prompt. This command starts the database instance without mounting the database.

4. Type "RESTORE CONTROLFILE" at the command prompt to run the Restore Controlfile command. The command will restore and recover the database from the backup control file.

References

• Oracle: Managing Control Files
• Stanford University: Advanced RMAN Recovery Techniques
• Oracle: Starting Up and Shutting Down