Loading...

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/init<DESTINATION_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

RMAN_UTIL Interface

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.

Last modified: 3/21/2019 8:48:43 PM