Loading...

BR*Tools Example: Performing a Cross-Machine Restore to the Same SAP on Oracle SID

You can use the util_file interface or the rman_util interface to perform a cross-machine restore.

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.

Use a combination of the data details and summary files and the log detail and summary files to perform the restore.

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: You must include the full path and the file name of the data detail file. You can find the backup ID in the BRBACKUP and BRARCHIVE files.

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

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 client, create an instance for the database that you want to restore. For more information, see Creating an Instance.
  3. On the destination client, 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.

    D:\oracle\product\10.2.0\db_1\database>more init<DESTINATION_SID>.utl.txt
    numstreams
    number_streams
    CvInstanceName
    Instance001
    CvClientName
    srcCrossClient
    client_name

  4. 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