Example: Restoring and Recovering the Control File

This example demonstrates how to recover a protected database after the loss of all control file copies. It is strongly recommended that you create multiple copies of your control files in separate disk locations.

To restore and recover the control file in a protected database:

  1. Ensure that the prerequisites described in "Prerequisites for Restoring and Recovering Data from Recovery Appliance" are met.
  2. Use RMAN to connect to the protected database as TARGET and the Recovery Appliance catalog as CATALOG.
  3. Restore the control file and then mount the database using the following command: 
    STARTUP NOMOUNT;
RUN 
{
  RESTORE CONTROLFILE;
  ALTER DATABASE MOUNT;
}