RMAN Example: Restoring Oracle Control Files

Restore an Oracle control file from an autobackup.

Restore control and files in the following scenarios:

• If the control file is lost and you need to restore the backup repository contained in the control file

• If the recovery catalog is lost

• If the recovery catalog was never used

• If the catalog connect string is not specified for the instance during the backup

Before You Begin

1. If you run the RMAN script on a UNIX environment, relink the SBT library or use PARMS in the Allocate Channel Command.

2. Perform a full backup.

3. Put the database in NOMOUNT mode.

4. Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

5. Optional: When the backup pieces are unknown to the RMAN repository, catalog the backup pieces. For more information, see Cataloging RMAN Backup Pieces.

Procedure

• On the RMAN command line, run the following sample script, substituting any required or optional Oracle SBT parameters.

  For information on required and optional SBT parameters, see SBT Parameters.

  run { 
  set DBID <dbid>;
  allocate channel ch1 type 'sbt_tape'; 
  restore controlfile from autobackup ; 
  }