> CommCell Console > Backup and Restore Agents > Databases > SAP > SAP for Oracle > SAP on Oracle Restores > SAP on Oracle Restore Examples Using the BR*Tools Command Line Interface

BR*Tools Example: Restoring from a SAP on Oracle Full Database Backup

Restore the entire database when the database is corrupted or lost.

Before You Begin

  1. Perform a full backup.

  2. If you use the util_file (BACKINT) interface, modify the init<SID>.utl file. For information on the parameters, see Supported SAP for Oracle Util File Parameters.

  3. If you use the rman_util interface, modify the init<SID>.sap file. For information on required and optional SBT parameters, see SBT Parameters.

  4. If the init<DESTINATION_SID>.sap file does not exist, create the file. On the command line, type the following: 

     
    brrestore -d util_file -b2 \#NULL -m $ORACLE_HOME/dbs/initDESTINATION_SID.sap

  5. Set the database to the correct mode defined in the table.

    Control File in the Restore

    Required Database Mode

    Control file is included in the restore

    NOMOUNT

    Control file not included in the restore

    MOUNT

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

Procedure

UTIL_FILE Interface

  • On the command line, type one of the following commands.

    Restore with the last complete data backup

    brrestore -d util_file -b last -m all

    Restore with a specified data detail file

    Substitute the data_detail_file variable. You must include the full path and the file name of the data detail file.

     
    brrestore -d util_file -m all -b data_detail_file -u /
RMAN_UTIL Interface

  • On the command line, type one of the following commands.

    Restore with the last completed data backup

    brrestore -d rman_util -b last -m all

    Restore with a specified data detail file

    Substitute the data_detail_file variable. You must include the full path and the file name of the data detail file.

     
    brrestore -d rman_util -b data_detail_file -u /

What to Do Next

  1. Recover the database.

  2. Restore the archive logs if needed.

  3. If you performed a point-in-time restore, open the database with the RESETLOGS option.

×

Loading...