> 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: 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

  1. On the destination host, restore the data and log summary, and the data and log detail files associated with the full backup. On the command line, type the following command, substituting the log_detail_file and data_detail_file variables.

    Note: You must include the full path and the file name of the data detail file.

     
    brrestore -d $[util_file] -b2 $[backup_id] -m $[data_detail_file]
brrestore -d $[util_file] -b2 $[backup_id] -m $[data_summary_file]
brrestore -d $[util_file] -b2 $[backup_id] -m $[log_detail_file]
brrestore -d $[util_file] -b2 $[backup_id] -m $[log_summary_file]

    Example

    brrestore -d $[util_file] -b2 $[10117894_7567] -m $[/oraprdhome/app/ora11g/product/home1/PRD/sapbackup/data_detail_file]==$[/oraprdhome/app/ora11g/product/home1/PRD/sapbackup]
 brrestore -d $[util_file] -b2 $[10117894_7567] -m $[/oraprdhome/app/ora11g/product/home1/PRD/sapbackup/data_summary_file]==$[/oraprdhome/app/ora11g/product/home1/PRD/sapbackup brrestore] -d $[util_file] -b2 $[10117894_7567] -m $[/oraprdhome/app/ora11g/product/home1/PRD/saparch/log_detail_file]==$[/oraprdhome/app/ora11g/product/home1/PRD/saparch brrestore] -d $[util_file] -b2 $[10117894_7567] -m $[/oraprdhome/app/ora11g/product/home1/PRD/saparch/log_summary_file]==$[/oraprdhome/app/ora11g/product/home1/PRD/saparch]

  2. On the destination host, restore the control file. On the command line, type the following command. 

    brrestore -d $[util_file] -b $[data_detail_file] -m 0

  3. On the destination host, restore the data files. On the command line, type the following command. 

    brrestore -d $[util_file] -b $[data_detail_file] -m $[all] -u $[/]

  4. On the destination host, restore the archive logs. On the command line, type the following command, substituting the start_seq and end_seq variables: 

     
    brrestore -a $[start_seq-end_seq]

  5. On the destination host, recover the database to the recover time. On the command line, type the following command, substituting the time to recover the database to. 

     
    Sql> recover database until time $[YYYY-MM-DD hh.mm.ss] using backup controlfile until cancel;

  6. On the destination host, open the database with the RESETLOGS option. On the command line, type the following command. 

    sql>alter database open resetlogs
RMAN_UTIL

  1. On the destination host, restore the data and log summary, and the data and log detail files associated with the full backup. On the command line, type the following command, substituting the log_detail_file and data_detail_file variables.

    Note: You must include the full path and the file name of the data detail file.

     
    brrestore -d $[util_file] -b2 $[backup_id] -m $[data_detail_file]
brrestore -d $[util_file] -b2 $[backup_id] -m $[data_summary_file]
brrestore -d $[util_file] -b2 $[backup_id] -m $[log_detail_file]
brrestore -d $[util_file] -b2 $[backup_id] -m $[log_summary_file]

    Example

    brrestore -d $[util_file] -b2 $[10117894_7567] -m $[/oraprdhome/app/ora11g/product/home1/PRD/sapbackup/data_detail_file]==$[/oraprdhome/app/ora11g/product/home1/PRD/sapbackup]
 brrestore -d $[util_file] -b2 $[10117894_7567] -m $[/oraprdhome/app/ora11g/product/home1/PRD/sapbackup/data_summary_file]==$[/oraprdhome/app/ora11g/product/home1/PRD/sapbackup] brrestore -d $[util_file] -b2 $[10117894_7567] -m $[/oraprdhome/app/ora11g/product/home1/PRD/saparch/log_detail_file]==$[/oraprdhome/app/ora11g/product/home1/PRD/saparch] brrestore -d $[util_file] -b2 $[10117894_7567] -m $[/oraprdhome/app/ora11g/product/home1/PRD/saparch/log_summary_file]==$[/oraprdhome/app/ora11g/product/home1/PRD/saparch]

  2. On the destination host, restore the control file from the data or log backup. On the command line, type the following command, substituting the data_backup, backup_id and control_file variables.

    Restore the control file from the data detail file

     
    brrestore -d $[util_file] -b $[data_detail_file] -m $[0] -c $[force] -u $[/]

    Restore the control file from the log backup

     
    brrestore -d $[util_file] -b2 $[backup_id] -m  $[control_file_path] -u $[/]

  3. On the destination host, place the database in MOUNT mode.

  4. On the destination host, restore the data files. On the command line, type the following command, substituting the data_detail_file variable. 

     
    brrestore -d $[rman_util] -b $[data_detail_file] -m $[all] -c $[force] -u $[/]

  5. On the destination host, restore the archive logs. On the command line, type the following command, substituting the log_number variable. 

     
    brrestore -d $[rman_util] -a $[log_number] -c force -u $[/]

  6. On the destination host, recover the database to the recover time. On the command line, type the following command.

    Substitute the time to recover the database to.

     
    Sql> recover database until time $[YYYY-MM-DD hh.mm.ss] using backup controlfile until cancel;

  7. On the destination host, open the database with the RESET LOGS option. On the command line, type the following command. 

    open resetlogs

Page contents

×

Loading...