Loading...

RMAN Example: Recovering an Oracle Database after an Application-Free Restore

Recover the Oracle database after you perform an application-free restore.

Before You Begin

  1. If you have not installed an Oracle Agent on your target server, install an Oracle Agent with the restore-only option on the server where you will recover the database.
  2. Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

Procedure

  • Create an RMAN script similar to the one below, with the following parameters:
    • CV_media

      Direct RMAN to use backup pieces on the disk for the device type sbt_tape

    • BACKUP_DIR

      Specify the directory from which backup pieces can be read

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

    run {
    allocate channel ch1 type 'sbt_tape'
    PARMS="ENV=(CV_media=FILE,BACKUP_DIR=C:\RestoreToDisk\783406\Data)";
    allocate channel ch2 type 'sbt_tape'
    PARMS="ENV=(CV_media=FILE,BACKUP_DIR=C:\RestoreToDisk\783406\Data)";
    restore database;
    recover database ;
    alter database open resetlogs;
    }