Loading...

BR*Tools Example: Performing a Cross-Machine Restore to a Different SAP on Oracle SID Using the BRRESTORE Command

Perform a cross machine restore when the original database host has been damaged or destroyed, and you need to restore the data to a different host from the backup.

You can find the backup ID in the BRBACKUP and BRARCHIVE files.

Online_cons backups and offline backups are only for database resets. You cannot use these backup types for a point-in-time recovery operation.

Note: The examples in this procedure use the backup ID with the -b2 option. You can use the #NULL option instead, but you must enable that option on the CommCell Console. For more information, see Enabling Restores of Earlier Backups without Specifying the Job ID.

Example

The value after the #SAVED line is the backup id.

In the following examples, the backup IDs are '10117894_7567' and '10117894_7568'

BR0280I BRBACKUP time stamp: 2016-03-07 13:17:10
#PFLOG.... /oraprdhome/app/ora11g/product/home1/PRD/sapbackup/besrellt.anf
#SAVED.... 10117894_7567

BR0280I BRARCHIVE time stamp: 2016-03-07 13:41:00
#PFLOG.... /oraprdhome/app/ora11g/product/home1/PRD/saparch/aesrenmf.cds
#SAVED.... 10117894_7568

Before You Begin

  1. On the source host, locate the detail file name and the summary file name of the data and log backups to be restored.
  2. On the destination host, create an instance for the database that you want to restore. For more information, see Creating an Instance.
  3. On the destination host, verify the $sapdata_home directory structure exists. Create the directory structure if it does not exist.
  4. Copy, or restore the init<SID>.ora and init<SID>.sap files from the host to the destination host.
  5. On the destination host, edit the $ORACLE_HOME/dbs/init<SID>.utl file.

    Substitute the CvInstanceName, srcCrossClient and srccrossdbname parameters.

    For information on the supported parameters, see Supported SAP for Oracle Util File Parameters

    numstreams
    number_streams
    CvInstanceName
    Instance001
    CvClientName
    destination_client_name
    srcCrossClient
    source_client_name
    srccrossdbname
    source_database_name
    destdbname
    destination_database_name

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

Procedure

UTIL_FILE

RMAN_UTIL

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