Restore Control File/SP file from Autobackup

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore.
• If you have not yet configured autobackup of control files, refer to Configuring Autobackup of Control Files for more information.
• Make sure that the DBID value for the particular database is displayed in the Instance properties dialog box. If you have not yet created an instance for the database, refer to Create/Modify an Instance for more information.

Required Capability: See Capabilities and Permitted Actions

To restore control file/SP file from autobackup using the CommCell Console:

1. From the CommCell Browser, right-click the instance, select All Tasks then click Restore.
2. From the Oracle Restore Options (General) tab, click Advanced.
3. Click the Control and SP Files tab of the Oracle Advanced Restore Options dialog box, then select the options for Restore Control File and From Autobackup. To restore SP file, select Restore SP File and From Autobackup.
4. Click the Options tab in the Oracle Advanced Restore Options dialog box, and select Set DBID. This option will distinguish the target database from the rest of the databases that have the same name in the recovery catalog.
5. Enter or select any other desired options on this tab, then click OK to save the settings.
6. Begin or schedule the restore.

Required Capability: See Capabilities and Permitted Actions

To restore control files from autobackup using RMAN:

1. Start up the target instance in NOMOUNT mode.
2. Start RMAN, but do not issue any connect statements.
3. At the RMAN prompt, set the dbid (if you do not know the dbid, you can get it from the RMAN log of the control file autobackup):

   RMAN> set dbid=<your_DBID>;

4. After setting the dbid, connect to the target instance that has been started in NOMOUNT mode:

   RMAN> connect target;

5. Enter the following commands/parameters from the RMAN prompt:

   RMAN> run {
   2> allocate channel ch1 type 'sbt_tape';
   3> restore controlfile from autobackup;
   4> }

6. Mount the database from the restored control file:

   RMAN> alter database mount;

7. Restore and recover the database:

   RMAN> run {
   2> allocate channel ch1 type 'sbt_tape';
   3> restore database;
   4> recover database;
   5> alter database open resetlogs;
   6> }

   RMAN> exit