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

On the source host, locate the detail file name and the summary file name of the data and log backups to be restored.
On the destination host, create an instance for the database that you want to restore. For more information, see Creating an Instance.
On the destination host, verify the $sapdata_home directory structure exists. Create the directory structure if it does not exist.
Copy, or restore the init<SID>.ora and init<SID>.sap files from the host to the destination host.
On the destination host, update the init<SID>.utl SAP utility file that is in use by SAP BR*Tools.
```
 
CvInstanceName 
Instance_Name
CvClientName 
destination_client_name
numstreams 
number_of_streams
srcCrossClient 
source_client_name
srcCrossDbname 
source_database_name
```
For information about the supported parameters, see Supported SAP for Oracle Util File Parameters.
If you need the CommCell Console to authenticate the job, configure the parameters for CommCell Console third-party job authentication.

Procedure

UTIL_FILE

Manually copy the init<SOURCE_SID>.sap file from the source host to the destination host, substituting the <SOURCE_SID> variable.

You can use the BRRESTORE command instead of manually copying the file. On the destination host command line, type the following substituting the <SOURCE_SID> variable.

 
brrestore -d util_file -b2 backup_ID -m $[D:oracleproduct10.2.0db_1databaseinit].sap==D$[:oracleproduct10.2.0db_1database]

BRRESTORE Sample Output

 
backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkylvd.lst -t file -p d:\param.txt ]
 CommServeHostName=satishp
 CommHostHostName=sde-sap1.idcprodcert.loc
 Galaxy CommCellID=2
 Galaxy HostID=219
 Src Cross Host=<sde-sap2>
 getInstanceId for InstanceName=[CER] host=[sde-sap1.prodcert.loc] hostId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossHostID=218
 Galaxy CrossHostInstanceID=559
 Galaxy CrossHostAppType=61
 Galaxy CrossHostAppID=2283
 Number of streams desired=<1> Number of files to restore=<1> CMDLINE Job
 Restore has been requested
 SID=[CER] BkpSet=[default] AppType=[61]
 Success in getting Job id=14424 Token=<14424:2:1>
 Success in init with JM
 Cannot obtain the Index MediaAgent from the Archive Manager..
 Attaching CommServer Session
 AfileNumber=19929, AcommCellId=2 AgroupNumber=23 archfilename=D:\oracle\product\10.2.0\db_1\database\initCER.sap copy=36 BID=13310 reqBID=13310 afileFlags=4d
 BR0280I BRRESTORE time stamp: 2011-12-14 08.42.27
 #FILE..... D:\oracle\product\10.2.0\db_1\database\initCER.sap D:\oracle\product\10.2.0\db_1\database\initCER.sap
 #RESTORED. 1021752_13310
 Successful restore; 1 File(s); total transferred bytes=12616
 Success in sending JMSUCCESS to server
 Success in sending JMSUCCESS to server
 BR0280I BRRESTORE time stamp: 2011-12-14 08.42.27
 BR0374I 1 of 1 file restored by backup utility
 BR0230I Backup utility called successfully
 BR0406I End of file restore: rehkylvd.rsf 2011-12-14 08.42.27
 BR0280I BRRESTORE time stamp: 2011-12-14 08.42.27
 BR0402I BRRESTORE completed successfully

On the destination host, move or rename the init<SOURCE_SID>.sap file to init<DESTINATION_SID>.sap.

On the destination host, edit the init<SID>.sap file and change the <SOURCE_SID> parameter to the <DESTINATION_SID>.

Source Host Example

backup_root_dir = D:\oracle\SOURCE_SID\sapbackup stage_root_dir = D:\oracle\SOURCE_SID\sapbackup compress_cmd = "D:\usr\sap\SOURCE_SID\sys\exe\run\mkszip -c $ > $" uncompress_cmd = "D:\usr\sap\SOURCE_SID\sys\exe\run\uncompress -c $ > $" compress_dir = D:\oracle\SOURCE_SID\sapreorg archive_copy_dir = D:\oracle\SOURCE_SID\sapbackup archive_stage_dir = D:\oracle\SOURCE_SID\sapbackup

Destination Host Example

 
backup_root_dir = D:\oracle\DESTINATION_SID\sapbackup
 stage_root_dir = D:\oracle\DESTINATION_SID\sapbackup
 compress_cmd = "D:\usr\sap\DESTINATION_SID\sys\exe\run\mkszip -c $ > ]"
 uncompress_cmd = "D:\usr\sap\DESTINATION_SID\sys\exe\run\uncompress -c $ > ]"
 compress_dir = D:\oracle\DESTINATION_SID\sapreorg
 archive_copy_dir = D:\oracle\DESTINATION_SID\sapbackup
 archive_stage_dir = D:\oracle\DESTINATION_SID\sapbackup

Manually copy the init<SOURCE_SID>.ora file from the source host to the destination host, substituting the <SOURCE_SID> variable.

You can use the BRRESTORE command instead of manually copying the file. On the destination host command line, type the following, substituting the <SOURCE_SID> variable.
```
 
brrestore -d util_file -b2 backup_ID -m D:\oracle\product\10.2.0\db_1\database\initSOURCE_SID.ora==D:\oracle\product\10.2.0\db_1\database
```
On the destination host, move or rename the init<SOURCE_SID>.ora file to init<DESTINATION_SID>.ora.

On the destination host, edit the init<DESTINATION_SID>.ora file and update the following parameters with the new directory structure, substituting the <SOURCE_SID> and <DESTINATION_SID> variables.

control_files = (D:\oracle\DESTINATION__SID\sapdata1\cntrl\ctrl D:\oracle\DESTINATION__SID\sapdata2\cntrl\ctrl D:\oracle\DESTINATION__SID\saparch\cntrl\ctrl background_dump_dest = D:\oracle\DESTINATION_SID\saptrace\background user_dump_dest = D:\oracle\DESTINATION_SID\saptrace\usertrace log_archive_dest = D:\oracle\DESTINATION_SID\saparch db_name = DESTINATION__SID

On the destination host, create an SPFILE from the PFILE. On the command line, type the following:

sqlplus / as sysdba
 SQL> startup nomount;
 SQL> create spfile from pfile;

Full Output

D:\oracle\product\10.2.0\db_1\database>sqlplus / as sysdba
 SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 14 09:21:51 2011
 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
 Connected to an idle instance.
 SQL> startup nomount;
 ORACLE instance started.
 Total System Global Area 138412032 bytes 
 Fixed Size 2063992 bytes 
 Variable Size 125829512 bytes 
 Database Buffers 8388608 bytes 
 Redo Buffers 2129920 bytes 
 SQL> create spfile from pfile;
 File created.
 SQL>

On the destination host, restore the <SOURCE_SID>.log file by using the BRRESTORE command. On the command line, type the following command to restore the file:

brrestore -d util_file -b2 backup_ID -m D:\oracle\SOURCE_SID\sapbackup\backSOURCE_SID.log==D:\oracle\DESTINATION_SID\sapbackup

Example BRRESTORE Output

 
BR0401I BRRESTORE 7.20 (1)
 BR0405I Start of file restore: rehkyqtz.rsf 2011-12-14 09.37.35
 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkyqtz.rsf
 BR0280I BRRESTORE time stamp: 2011-12-14 09.37.35
 BR0407I Restore of database: TRD
 BR0408I BRRESTORE action ID: rehkyqtz
 BR0409I BRRESTORE function ID: rsf
 BR0415I File for restore using backup utility ID backup_ID: D:\oracle\CER\sapbackup\backCER.log=D:\oracle\TRD\sapbackup
 BR0416I 1 file found to restore, size 0.000 MB
 BR0421I Restore device type: util_file
 BR0280I BRRESTORE time stamp: 2011-12-14 09.37.35
 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
 c
 BR0280I BRRESTORE time stamp: 2011-12-14 09.37.37
 BR0257I Your reply: 'c'
 BR0259I Program execution will be continued...
 BR0280I BRRESTORE time stamp: 2011-12-14 09.37.37
 BR0229I Calling backup utility with function 'restore'...
 BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyqtz.lst -t file -p d:\param.txt':
 Setting the Number of streams desired=<1> for 1 File restore.
 -------------------------- Output of restore -------------------------
 BI_BACKUP=<PARTIAL>
 BI_CALLER=<BRRESTORE>
 BI_REQUEST=<NEW>
 -------------------------- Parameter Specified -------------------------
 CvInstanceName=<Instance001>
 CvHostName=<sde-sap1>
 numstreams=<1>
 srccrosshost=<sde-sap2>
 srccrossdbname=<CER>
 destdbname=<TRD>
 -------------------------- backint Command Line -----------backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyqtz.lst -t file -p d:\param.txt ]
 CommServeHostName=satishp
 CommHostHostName=sde-sap1.idcprodcert.loc
 Galaxy CommCellID=2
 Galaxy HostID=219
 Src Cross Host=<sde-sap2>
 getInstanceId for InstanceName=[CER] host=[sde-sap1.idcprodcert.loc] hostId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossHostID=218
 Galaxy CrossHostInstanceID=559
 Galaxy CrossHostAppType=61
 Galaxy CrossHostAppID=2283
 Number of streams desired=<1> Number of files to restore=<1> CMDLINE Job
 Restore has been requested
 SID=[CER] BkpSet=[default] AppType=[61]
 Success in getting Job id=14429 Token=<14429:2:1>
 Success in init with JM
 Cannot obtain the Index MediaAgent from the Archive Manager..
 Attaching CommServer Session
 AfileNumber=19914, AcommCellId=2 AgroupNumber=22 archfilename=D:\oracle\CER\sapbackup\backCER.log copy=35 BID=13310 reqBID=13310 afileFlags=0d
 BR0280I BRRESTORE time stamp: 2011-12-14 09.38.00
 #FILE..... D:\oracle\CER\sapbackup\backCER.log D:\oracle\TRD\sapbackup\backCER.log
 #RESTORED. 1021752_13310
 Successful restore; 1 File(s); total transferred bytes=2912
 Success in sending JMSUCCESS to server
 Success in sending JMSUCCESS to server
 BR0280I BRRESTORE time stamp: 2011-12-14 09.38.01
 BR0374I 1 of 1 file restored by backup utility
 BR0230I Backup utility called successfully              BR0406I End of file restore: rehkyqtz.rsf 2011-12-14 09.38.01
 BR0280I BRRESTORE time stamp: 2011-12-14 09.38.01
 BR0402I BRRESTORE completed successfully

On the destination client, copy the arch<SOURCE_SID>.log log summary file from the source client to the destination client.

You can use the BRRESTORE command instead of manually copying the file. On the destination client command line, type the following.
```
brrestore -d util_file -b2 backup_id -m D:\oracle\SOURCE_SID\saparch\archSOURCE_SID.log==D:\oracle\DESTINATION_SID\saparch
```
On the destination client, copy the detail files from the sapbackup and the saparch source client directory onto the destination client.
On the destination client, copy the arch<SOURCE_SID>.log log summary file from the source client to the destination client.

You can use the BRRESTORE command instead of manually copying the file. On the destination client command line, type the following.
```
brrestore -d util_file -b2 backup_id -m D:\oracle\SOURCE_SID\sapbackup\brbackup_detail_file==D:\oracle\DESTINATION_SID\sapbackup
```
Identify the corresponding detail file in $SAPDATA_HOME/saparch directory from the source client and then restore it. On the destination client command line, type the following.
```
brrestore -d util_file -b2 backup_id -m D:\oracle\SOURCE_SID\saparch\brarchive_detail_file==D:\oracle\DESTINATION_SID\saparch
```

On the destination client, restore the control file by using the BRRESTORE command. On the command line, type the following:

brrestore -d util_file -b2 detail_file_namelast -m 0

Example BRRESTORE Output

BR0401I BRRESTORE 7.20 (1)
 BR0405I Start of file restore: rehlcdsc.rsb 2011-12-15 02.42.02
 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehlcdsc.rsb
 BR0454W Values of oracle_sid are different: current 'TRD', backup behkctrv.anf 'CER'
 BR0455W Value 'TRD' of oracle_sid will be used for restore
 BR0454W Values of sapdata_home are different: current 'D:\oracle\TRD', backup behkctrv.anf 'D:\oracle\CER'
 BR0455W Value 'D:\oracle\TRD' of sapdata_home will be used for restore
 BR0460W Termination message not found in D:\oracle\TRD\sapbackup\behkctrv.anf - log file incomplete (this is OK if the log fi
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.02
 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
 c
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.04
 BR0257I Your reply: 'c'
 BR0259I Program execution will be continued...
 BR0427I Files from the old sapdata_home D:\oracle\CER will be restored into the new sapdata_home D:\oracle\TRD
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.04
 BR0407I Restore of database: TRD
 BR0408I BRRESTORE action ID: rehlcdsc
 BR0409I BRRESTORE function ID: rsb
 BR0449I Restore mode: partial
 BR0411I Database files for restore:
 D:\oracle\CER\sapbackup\CNTRLCER.DBF=D:\oracle\TRD\sapbackup
 D:\oracle\CER\sapdata1\cntrl\ctrlCER.ctl
 D:\oracle\CER\sapdata2\cntrl\ctrlCER.ctl
 D:\oracle\CER\saparch\cntrl\ctrlCER.ctl
 BR0419I Files will be restored from backup: behkctrv.anf 2011-12-09 22.45.55
 BR0416I 1 file found to restore, size 10.766 MB
 BR0421I Restore device type: util_file
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.05
 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
 c
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.10
 BR0257I Your reply: 'c'
 BR0259I Program execution will be continued...
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.10
 BR0229I Calling backup utility with function 'restore'...
 BR0278I Command output of 'backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehlcdsc.lst -t file -p D:\param.txt':
 Setting the Number of streams desired=<1> for 1 File restore.
 -------------------------- Output of restore -------------------------
 BI_BACKUP=<PARTIAL>
 BI_CALLER=BRRESTORE
 BI_REQUEST=NEW
 -------------------------- Parameter Specified -------------------------
 CvInstanceName=Instance001
 CvClientName=sde-sap1
 numstreams=<1>
 srccrossclient=sde-sap2
 srccrossdbname=CER
 destdbname=CER
 -------------------------- backint Command Line -------------------------
 backintCmd=[backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehlcdsc.lst -t file -p D:\param.txt ]
 CommServeHostName=satishp
 CommClientHostName=sde-sap1.idcprodcert.loc
 Galaxy CommCellID=2
 Galaxy ClientID=219
 Src Cross Client=sde-sap2
 getInstanceId for InstanceName=[CER] client=[sde-sap1.idcprodcert.loc] clientId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossClientID=218
 Galaxy CrossClientInstanceID=559
 Galaxy CrossClientAppType=61
 Galaxy CrossClientAppID=2283
 Number of streams desired=<1> Number of files to restore=<1> CMDLINE Job
 Restore has been requested
 SID=[CER] BkpSet=[default] AppType=[61]
 Success in getting Job id=14526 Token=<14526:2:1>
 Success in init with JM
 Attaching CommServer Session
 AfileNumber=19908, AcommCellId=2 AgroupNumber=22 archfilename=D:\oracle\CER\sapbackup\CNTRLCER.DBF copy=35 BID=13310 reqBID=1
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.31
 #FILE..... D:\oracle\CER\sapbackup\CNTRLCER.DBF D:\oracle\TRD\sapbackup\CNTRLCER.DBF
 #RESTORED. 1021752_13310
 Successful restore; 1 File(s); total transferred bytes=11288746
 Success in sending JMSUCCESS to server
 Success in sending JMSUCCESS to server
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.32
 BR0374I 1 of 1 file restored by backup utility
 BR0230I Backup utility called successfully
 BR0351I Restoring D:\ORACLE\TRD\SAPDATA1\CNTRL\ctrlCER.ctl
 BR0355I from D:\oracle\TRD\sapbackup\CNTRLCER.DBF ...
 BR0351I Restoring D:\ORACLE\TRD\SAPDATA2\CNTRL\ctrlCER.ctl
 BR0355I from D:\oracle\TRD\sapbackup\CNTRLCER.DBF ...
 BR0351I Restoring D:\ORACLE\TRD\SAPARCH\CNTRL\ctrlCER.ctl
 BR0355I from D:\oracle\TRD\sapbackup\CNTRLCER.DBF ...
 BR0406I End of file restore: rehlcdsc.rsb 2011-12-15 02.42.32
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.32
 BR0403I BRRESTORE completed successfully with warnings

On the destination client, create an SPFILE from the PFILE. On the command line, type the following:

sqlplus / as sysdba
 SQL> startup nomount;
 SQL> create spfile from pfile;

Full Output

D:\oracle\product\10.2.0\db_1\database>sqlplus / as sysdba
 SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 14 09:21:51 2011
 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
 Connected to an idle instance.
 SQL> startup nomount;
 ORACLE instance started.
 Total System Global Area 138412032 bytes 
 Fixed Size 2063992 bytes 
 Variable Size 125829512 bytes 
 Database Buffers 8388608 bytes 
 Redo Buffers 2129920 bytes 
 SQL> create spfile from pfile;
 File created.
 SQL>

On the destination client, restore the database files by using the BRRESTORE command. On the command line, type the following command, substituting the data_detail_file variable:
```
 
brrestore -d util_file -m all -b data_detail_file
```

On the destination client, identify the log range from the log detail file and restore it. On the command line, type the following command, substituting the <DESTINATION_SID> and log_range_start variables.

brrestore -d util_file -a log_range_start-log_range_end==D:\oracle\DESTINATION_SID\saparch

Example BRRESTORE Output

BR0401I BRRESTORE 7.20 (1)
 BR0405I Start of file restore: rehlchik.rsa 2011-12-15 03.22.54
 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehlchik.rsa
 BR0414I Offline redolog files for restore of database instance TRD:
 D:\oracle\TRD\saparch:
 65,66,67,68,69,70,71,72,73,74,
 75
 BR0280I BRRESTORE time stamp: 2011-12-15 03.22.54
 BR0407I Restore of database: TRD
 BR0408I BRRESTORE action ID: rehlchik
 BR0409I BRRESTORE function ID: rsa
 BR0419I Files will be restored from backup: aehkctzc.sve 2011-12-09 22.49.04
 BR0416I 11 files found to restore, total size 79.894 MB
 BR0421I Restore device type: util_file
 BR0280I BRRESTORE time stamp: 2011-12-15 03.22.54
 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
 c
 BR0280I BRRESTORE time stamp: 2011-12-15 03.22.55
 BR0257I Your reply: 'c'
 BR0259I Program execution will be continued...
 BR0280I BRRESTORE time stamp: 2011-12-15 03.22.55
 BR0229I Calling backup utility with function 'restore'...
 BR0278I Command output of 'backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehlchik.lst -t file -p D:\param.txt':
 -------------------------- Output of restore -------------------------
 BI_BACKUP=ARCHIVE
 BI_CALLER=BRRESTORE
 BI_REQUEST=NEW
 -------------------------- Parameter Specified -------------------------
 CvInstanceName=Instance001
 CvClientName=sde-sap1
 numstreams=<4>
 srccrossclient=sde-sap2
 srccrossdbname=CER
 destdbname=CER
 -------------------------- backint Command Line -------------------------
 backintCmd=[backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehlchik.lst -t file -p D:\param.txt ]
 CommServeHostName=satishp
 CommClientHostName=sde-sap1.idcprodcert.loc
 Galaxy CommCellID=2
 Galaxy ClientID=219
 Src Cross Client=sde-sap2
 getInstanceId for InstanceName=[CER] client=[sde-sap1.idcprodcert.loc] clientId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossClientID=218
 Galaxy CrossClientInstanceID=559
 Galaxy CrossClientAppType=61
 Galaxy CrossClientAppID=2284
 Total number of Collect Files Generated=<4>
 Number of streams desired=<4> Number of files to restore=<4> CMDLINE Job
 Restore has been requested
 SID=[CER] BkpSet=[default] AppType=[61]
 Success in getting Job id=14529 Token=<14529:2:1>
 Success in init with JM
 CommServeHostName=satishp
 CommClientHostName=sde-sap1.idcprodcert.loc
 CommServeHostName=satishp
 CommClientHostName=sde-sap1.idcprodcert.loc
 CommServeHostName=satishp
 CommClientHostName=sde-sap1.idcprodcert.loc
 CommServeHostName=satishp
 CommClientHostName=sde-sap1.idcprodcert.loc
 Galaxy CommCellID=2
 Galaxy ClientID=219
 Src Cross Client=sde-sap2
 getInstanceId for InstanceName=[CER] client=[sde-sap1.idcprodcert.loc] clientId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossClientID=218
 Galaxy CrossClientInstanceID=559
 Galaxy CrossClientAppType=61
 Galaxy CrossClientAppID=2284
 Restore has been requested
 Success in init with JM
 Attaching CommServer Session
 Galaxy CommCellID=2
 Galaxy ClientID=219
 Src Cross Client=sde-sap2
 getInstanceId for InstanceName=[CER] client=[sde-sap1.idcprodcert.loc] clientId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossClientID=218
 Galaxy CrossClientInstanceID=559
 Galaxy CrossClientAppType=61
 Galaxy CrossClientAppID=2284
 Restore has been requested
 Success in init with JM
 Attaching CommServer Session
 Restoring from MediaId=<23_MagVolId_9089>
 Galaxy CommCellID=2
 Galaxy ClientID=219
 Src Cross Client=sde-sap2
 getInstanceId for InstanceName=[CER] client=[sde-sap1.idcprodcert.loc] clientId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossClientID=218
 Galaxy CommCellID=2
 Galaxy ClientID=219
 Src Cross Client=sde-sap2
 getInstanceId for InstanceName=[CER] client=[sde-sap1.idcprodcert.loc] clientId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossClientID=218
 Galaxy CrossClientInstanceID=559
 Galaxy CrossClientAppType=61
 Galaxy CrossClientAppID=2284
 Restore has been requested
 Success in init with JM
 Attaching CommServer Session
 Restoring from MediaId=<23_MagVolId_9092>
 Restoring from MediaId=<23_MagVolId_9091>
 Galaxy CrossClientInstanceID=559
 Galaxy CrossClientAppType=61
 Galaxy CrossClientAppID=2284
 Restore has been requested
 Success in init with JM
 Attaching CommServer Session
 Restoring from MediaId=<23_MagVolId_9090>
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00066_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.18
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00066_0769082544.001 D:\oracle\TRD\saparch\ARC00066_0769082544.001
 #RESTORED. 1021752_13310
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00065_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.18
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00065_0769082544.001 D:\oracle\TRD\saparch\ARC00065_0769082544.001
 #RESTORED. 1021752_13310
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00067_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.19
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00067_0769082544.001 D:\oracle\TRD\saparch\ARC00067_0769082544.001
 #RESTORED. 1021752_13310
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00070_0769082544.001>
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00069_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.23
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00070_0769082544.001 D:\oracle\TRD\saparch\ARC00070_0769082544.001
 #RESTORED. 1021752_13310
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.23
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00069_0769082544.001 D:\oracle\TRD\saparch\ARC00069_0769082544.001
 #RESTORED. 1021752_13310
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00071_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.24
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00071_0769082544.001 D:\oracle\TRD\saparch\ARC00071_0769082544.001
 #RESTORED. 1021752_13310
 Sending file=<#EOF> to the Child=<4820>
 Successful restore; 2 File(s); total transferred bytes=18104678
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00074_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.26
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00074_0769082544.001 D:\oracle\TRD\saparch\ARC00074_0769082544.001
 #RESTORED. 1021752_13310
 Sending file=<#EOF> to the Child=<4040>
 Successful restore; 3 File(s); total transferred bytes=20402201
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00073_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.27
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00073_0769082544.001 D:\oracle\TRD\saparch\ARC00073_0769082544.001
 #RESTORED. 1021752_13310
 Sending file=<#EOF> to the Child=<4504>
 Successful restore; 3 File(s); total transferred bytes=27157017
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00068_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.28
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00068_0769082544.001 D:\oracle\TRD\saparch\ARC00068_0769082544.001
 #RESTORED. 1021752_13310
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00072_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.33
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00072_0769082544.001 D:\oracle\TRD\saparch\ARC00072_0769082544.001
 #RESTORED. 1021752_13310
 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00075_0769082544.001>
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.37
 #ARCHIVE.. D:\oracle\cer\saparch\ARC00075_0769082544.001 D:\oracle\TRD\saparch\ARC00075_0769082544.001
 #RESTORED. 1021752_13310
 Sending file=<#EOF> to the Child=<4972>
 Successful restore; 3 File(s); total transferred bytes=18113049
 Success in sending JMSUCCESS to server
 Success in sending JMSUCCESS to server
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.47
 BR0374I 11 of 11 files restored by backup utility
 BR0230I Backup utility called successfully
 BR0406I End of file restore: rehlchik.rsa 2011-12-15 03.23.47
 BR0280I BRRESTORE time stamp: 2011-12-15 03.23.47
 BR0402I BRRESTORE completed successfully

On the destination client, set the database to MOUNT mode, and copy the backup control file to trace, substituting the <DESTINATION_SID> variable.

SQL> startup mount; ORACLE instance started. SQL> alter database backup controlfile to 'D:\oracle\DESTINATION_SID\sapbackup\controlDESTINATION_SID.NEW'; SQL> alter database backup controlfile to trace as 'D:\oracle\DESTINATION_SID\sapbackup\control.ora';

Full Output

SQL> startup mount; ORACLE instance started. Total System Global Area 138412032 bytes Fixed Size 2063992 bytes Variable Size 125829512 bytes Database Buffers 8388608 bytes Redo Buffers 2129920 bytes Database mounted. SQL> alter database backup controlfile to 'D:\oracle\DESTINATION_SID\sapbackup\DESTINATION_SID.NEW'; Database altered. SQL> alter database backup controlfile to trace as 'D:\oracle\DESTINATION_SID\sapbackup\control.ora'; Database altered.

If you use an online backup, on the destination client, create a control file by using an SQL query similar to the one below.

Shut down the destination client database.
On the destination host, edit the SP file and change the db_name from <SOURCE_SID> to <DESTINATION_SID>.
Set the destination client database to NOMOUNT mode.
In the trace file, change the following parameters in the SQL query from.
- REUSE to SET
- <SOURCE_SID> to <DESTINATION_SID>
- NORESETLOGS to RESETLOGS
- OLD DIR to NEW DIR in the path structure

Full Query

STARTUP NOMOUNT CREATE CONTROLFILE SET DATABASE "DESTINATION_SID" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 16 MAXLOGHISTORY 1752 LOGFILE GROUP 1 ( 'D:\ORACLE\DESTINATION_SIDORIGLOGA\LOG1_M1.DBF', 'D:\ORACLE\DESTINATION_SID\MIRRLOGA\LOG1_M2.DBF' ) SIZE 10M, GROUP 2 ( 'D:\ORACLE\DESTINATION_SID\ORIGLOGB\LOG2_M1.DBF', 'D:\ORACLE\DESTINATION_SID\MIRRLOGB\LOG2_M2.DBF' ) SIZE 10M, GROUP 3 ( 'D:\ORACLE\DESTINATION_SID\ORIGLOGA\LOG3_M1.DBF', 'D:\ORACLE\DESTINATION_SID\MIRRLOGA\LOG3_M2.DBF' ) SIZE 10M, GROUP 4 ( 'D:\ORACLE\DESTINATION_SID\ORIGLOGB\LOG4_M1.DBF', 'D:\ORACLE\DESTINATION_SID\MIRRLOGB\LOG4_M2.DBF' ) SIZE 10M -- STANDBY LOGFILE DATAFILE 'D:\ORACLE\DESTINATION_SID\SAPDATA1\SYSTEM_1\SYSTEM.DATA1', 'D:\ORACLE\DESTINATION_SID\SAPDATA1\UNDO_1\UNDO.DATA1', 'D:\ORACLE\DESTINATION_SID\SAPDATA1\SYSTEM_1\SYSAUX.DBF', 'D:\ORACLE\DESTINATION_SID\SAPDATA2\CER_1\CER.DATA1', 'D:\ORACLE\DESTINATION_SID\SAPDATA3\CERUSR_1\CERUSR.DATA1' CHARACTER SET US7ASCII ;

To create control files on the destination host, rename the restored control files.

On the destination host, run a SQL query similar to the one below, substituting the <DESTINATION_SID> variable.

Example

SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 138412032 bytes Fixed Size 2063992 bytes Variable Size 125829512 bytes Database Buffers 8388608 bytes Redo Buffers 2129920 bytes SQL> CREATE CONTROLFILE SET DATABASE "DESTINATION_SID" RESETLOGS ARCHIVELOG 2 MAXLOGFILES 32 3 MAXLOGMEMBERS 2 4 MAXDATAFILES 254 5 MAXINSTANCES 16 6 MAXLOGHISTORY 1752 7 LOGFILE 8 GROUP 1 ( 9 'D:\ORACLE\DESTINATION_SID\ORIGLOGA\LOG1_M1.DBF', 10 'D:\ORACLE\DESTINATION_SID\MIRRLOGA\LOG1_M2.DBF' 11 ) SIZE 10M, 12 GROUP 2 ( 13 'D:\ORACLE\DESTINATION_SID\ORIGLOGB\LOG2_M1.DBF', 14 'D:\ORACLE\DESTINATION_SID\MIRRLOGB\LOG2_M2.DBF' 15 ) SIZE 10M, 16 GROUP 3 ( 17 'D:\ORACLE\DESTINATION_SID\ORIGLOGA\LOG3_M1.DBF', 18 'D:\ORACLE\DESTINATION_SID\MIRRLOGA\LOG3_M2.DBF' 19 ) SIZE 10M, 20 GROUP 4 ( 21 'D:\ORACLE\DESTINATION_SID\ORIGLOGB\LOG4_M1.DBF', 22 'D:\ORACLE\DESTINATION_SID\MIRRLOGB\LOG4_M2.DBF' 23 ) SIZE 10M 24 -- STANDBY LOGFILE 25 DATAFILE 26 'D:\ORACLE\DESTINATION_SID\SAPDATA1\SYSTEM_1\SYSTEM.DATA1', 27 'D:\ORACLE\DESTINATION_SID\SAPDATA1\UNDO_1\UNDO.DATA1', 28 'D:\ORACLE\DESTINATION_SID\SAPDATA1\SYSTEM_1\SYSAUX.DBF', 29 'D:\ORACLE\DESTINATION_SID\SAPDATA2\CER_1\CER.DATA1', 30 'D:\ORACLE\DESTINATION_SID\SAPDATA3\CERUSR_1\CERUSR.DATA1' 31 CHARACTER SET US7ASCII 32 ; Control file created.

On the destination client, run the following SQL query to recover the database, open the database, and add a temporary tablespace, substituting the <DESTINATION_SID> variable.

Example

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; ORA-00279: change 397349 generated at 12/09/2011 22:45:58 needed for thread 1 ORA-00289: suggestion : D:\ORACLE\DESTINATION_SID\SAPARCH\ARC00074_0769082544.001 ORA-00280: change 397349 for thread 1 is in sequence #74 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} AUTO ORA-00279: change 397401 generated at 12/09/2011 22:47:55 needed for thread 1 ORA-00289: suggestion : D:\ORACLE\DESTINATION_SID\SAPARCH\ARC00075_0769082544.001 ORA-00280: change 397401 for thread 1 is in sequence #75 ORA-00278: log file 'D:\ORACLE\DESTINATION_SID\SAPARCH\ARC00074_0769082544.001' no longer needed for this recovery ORA-00279: change 397431 generated at 12/09/2011 22:49:04 needed for thread 1 ORA-00289: suggestion : D:\ORACLE\DESTINATION_SID\SAPARCH\ARC00076_0769082544.001 ORA-00280: change 397431 for thread 1 is in sequence #76 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} AUTO ORA-00308: cannot open archived log 'D:\ORACLE\DESTINATION_SID\SAPARCH\ARC00076_0769082544.001' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified. ORA-00308: cannot open archived log 'D:\ORACLE\DESTINATION_SID\SAPARCH\ARC00076_0769082544.001' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified. SQL> alter database open resetlogs; Database altered. SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'D:\ORACLE\NEW_SID\SAPDATA1\TEMP_1\TEMP.DATA1' REUSE; Tablespace altered.

RMAN_UTIL

Manually copy the init<SOURCE_SID>.sap file from the source host to the destination host, substituting the <SOURCE_SID> variable.

You can use the BRRESTORE command instead of manually copying the file. On the destination host command line, type the following substituting the <SOURCE_SID> variable.

brrestore -d util_file -b2 backup_ID -m D:\oracle\product\10.2.0\db_1\database\initSOURCE_SID.sap==D:\oracle\product\10.2.0\db_1\database

BRRESTORE Sample Output

 
backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkylvd.lst -t file -p d:\param.txt ]
 CommServeHostName=satishp
 CommHostHostName=sde-sap1.idcprodcert.loc
 Galaxy CommCellID=2
 Galaxy HostID=219
 Src Cross Host=<sde-sap2>
 getInstanceId for InstanceName=[CER] host=[sde-sap1.prodcert.loc] hostId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossHostID=218
 Galaxy CrossHostInstanceID=559
 Galaxy CrossHostAppType=61
 Galaxy CrossHostAppID=2283
 Number of streams desired=<1> Number of files to restore=<1> CMDLINE Job
 Restore has been requested
 SID=[CER] BkpSet=[default] AppType=[61]
 Success in getting Job id=14424 Token=<14424:2:1>
 Success in init with JM
 Cannot obtain the Index MediaAgent from the Archive Manager..
 Attaching CommServer Session
 AfileNumber=19929, AcommCellId=2 AgroupNumber=23 archfilename=D:\oracle\product\10.2.0\db_1\database\initCER.sap copy=36 BID=13310 reqBID=13310 afileFlags=4d
 BR0280I BRRESTORE time stamp: 2011-12-14 08.42.27
 #FILE..... D:\oracle\product\10.2.0\db_1\database\initCER.sap D:\oracle\product\10.2.0\db_1\database\initCER.sap
 #RESTORED. 1021752_13310
 Successful restore; 1 File(s); total transferred bytes=12616
 Success in sending JMSUCCESS to server
 Success in sending JMSUCCESS to server
 BR0280I BRRESTORE time stamp: 2011-12-14 08.42.27
 BR0374I 1 of 1 file restored by backup utility
 BR0230I Backup utility called successfully
 BR0406I End of file restore: rehkylvd.rsf 2011-12-14 08.42.27
 BR0280I BRRESTORE time stamp: 2011-12-14 08.42.27
 BR0402I BRRESTORE completed successfully

On the destination host, move or rename the init<SOURCE_SID>.sap file to init<DESTINATION_SID>.sap.

On the destination host, edit the init<SID>.sap file and change the <SOURCE_SID> parameter to the <DESTINATION_SID>.

Source Host Example

Destination Host Example

 
backup_root_dir = D:\oracle\DESTINATION_SID\sapbackup
 stage_root_dir = D:\oracle\DESTINATION_SID\sapbackup
 compress_cmd = "D:\usr\sap\DESTINATION_SID\sys\exe\run\mkszip -c $ > ]"
 uncompress_cmd = "D:\usr\sap\DESTINATION_SID\sys\exe\run\uncompress -c $ > ]"
 compress_dir = D:\oracle\DESTINATION_SID\sapreorg
 archive_copy_dir = D:\oracle\DESTINATION_SID\sapbackup
 archive_stage_dir = D:\oracle\DESTINATION_SID\sapbackup

Manually copy the init<SOURCE_SID>.ora file from the source host to the destination host, substituting the <SOURCE_SID> variable.

You can use the BRRESTORE command instead of manually copying the file. On the destination host command line, type the following, substituting the <SOURCE_SID> variable.
```
 
brrestore -d util_file -b2 backup_ID -m D:\oracle\product\10.2.0\db_1\database\initSOURCE_SID.ora==D:\oracle\product\10.2.0\db_1\database
```
On the destination host, move or rename the init<SOURCE_SID>.ora file to init<DESTINATION_SID>.ora.

On the destination host, edit the init<DESTINATION_SID>.ora file and update the following parameters with the new directory structure, substituting the <SOURCE_SID> and <DESTINATION_SID> variables.

On the destination host, create an SPFILE from the PFILE. On the command line, type the following:

sqlplus / as sysdba
 SQL> startup nomount;
 SQL> create spfile from pfile;

Full Output

D:\oracle\product\10.2.0\db_1\database>sqlplus / as sysdba
 SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 14 09:21:51 2011
 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
 Connected to an idle instance.
 SQL> startup nomount;
 ORACLE instance started.
 Total System Global Area 138412032 bytes 
 Fixed Size 2063992 bytes 
 Variable Size 125829512 bytes 
 Database Buffers 8388608 bytes 
 Redo Buffers 2129920 bytes 
 SQL> create spfile from pfile;
 File created.
 SQL>

On the destination host, restore the <SOURCE_SID>.log file by using the BRRESTORE command. On the command line, type the following command to restore the file:

 
brrestore -d util_file -b2 backup_id -m $[D:oracleSOURCE_SIDsapbackupback.log]==$[D:oracleDESTINATION_SIDsapbackup]

Example BRRESTORE Output

 
BR0401I BRRESTORE 7.20 (1)
 BR0405I Start of file restore: rehkyqtz.rsf 2011-12-14 09.37.35
 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkyqtz.rsf
 BR0280I BRRESTORE time stamp: 2011-12-14 09.37.35
 BR0407I Restore of database: TRD
 BR0408I BRRESTORE action ID: rehkyqtz
 BR0409I BRRESTORE function ID: rsf
 BR0415I File for restore using backup utility ID backup_ID: D:\oracle\CER\sapbackup\backCER.log=D:\oracle\TRD\sapbackup
 BR0416I 1 file found to restore, size 0.000 MB
 BR0421I Restore device type: util_file
 BR0280I BRRESTORE time stamp: 2011-12-14 09.37.35
 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
 c
 BR0280I BRRESTORE time stamp: 2011-12-14 09.37.37
 BR0257I Your reply: 'c'
 BR0259I Program execution will be continued...
 BR0280I BRRESTORE time stamp: 2011-12-14 09.37.37
 BR0229I Calling backup utility with function 'restore'...
 BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyqtz.lst -t file -p d:\param.txt':
 Setting the Number of streams desired=<1> for 1 File restore.
 -------------------------- Output of restore -------------------------
 BI_BACKUP=<PARTIAL>
 BI_CALLER=<BRRESTORE>
 BI_REQUEST=<NEW>
 -------------------------- Parameter Specified -------------------------
 CvInstanceName=<Instance001>
 CvHostName=<sde-sap1>
 numstreams=<1>
 srccrosshost=<sde-sap2>
 srccrossdbname=<CER>
 destdbname=<TRD>
 -------------------------- backint Command Line -----------backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyqtz.lst -t file -p d:\param.txt ]
 CommServeHostName=satishp
 CommHostHostName=sde-sap1.idcprodcert.loc
 Galaxy CommCellID=2
 Galaxy HostID=219
 Src Cross Host=<sde-sap2>
 getInstanceId for InstanceName=[CER] host=[sde-sap1.idcprodcert.loc] hostId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossHostID=218
 Galaxy CrossHostInstanceID=559
 Galaxy CrossHostAppType=61
 Galaxy CrossHostAppID=2283
 Number of streams desired=<1> Number of files to restore=<1> CMDLINE Job
 Restore has been requested
 SID=[CER] BkpSet=[default] AppType=[61]
 Success in getting Job id=14429 Token=<14429:2:1>
 Success in init with JM
 Cannot obtain the Index MediaAgent from the Archive Manager..
 Attaching CommServer Session
 AfileNumber=19914, AcommCellId=2 AgroupNumber=22 archfilename=D:\oracle\CER\sapbackup\backCER.log copy=35 BID=13310 reqBID=13310 afileFlags=0d
 BR0280I BRRESTORE time stamp: 2011-12-14 09.38.00
 #FILE..... D:\oracle\CER\sapbackup\backCER.log D:\oracle\TRD\sapbackup\backCER.log
 #RESTORED. 1021752_13310
 Successful restore; 1 File(s); total transferred bytes=2912
 Success in sending JMSUCCESS to server
 Success in sending JMSUCCESS to server
 BR0280I BRRESTORE time stamp: 2011-12-14 09.38.01
 BR0374I 1 of 1 file restored by backup utility
 BR0230I Backup utility called successfully              BR0406I End of file restore: rehkyqtz.rsf 2011-12-14 09.38.01
 BR0280I BRRESTORE time stamp: 2011-12-14 09.38.01
 BR0402I BRRESTORE completed successfully

On the destination client, copy the arch<SOURCE_SID>.log log summary file from the source client to the destination client.

You can use the BRRESTORE command instead of manually copying the file. On the destination client command line, type the following.
```
brrestore -d util_file -b2 backup_id -m D:\oracle\SOURCE_SID\saparch\archSOURCE_SID.log==D:\oracle\DESTINATION_SID\saparch
```
On the destination client, copy the detail files from the sapbackup and the saparch source client directory onto the destination client.
On the destination client, copy the arch<SOURCE_SID>.log log summary file from the source client to the destination client.

You can use the BRRESTORE command instead of manually copying the file. On the destination client command line, type the following.
```
brrestore -d util_file -b2 backup_id -m D:\oracle\SOURCE_SID\sapbackup\brbackup_detail_file==D:\oracle\DESTINATION_SID\sapbackup
```
Identify the corresponding detail file in $SAPDATA_HOME/saparch directory from the source client and then restore it. On the destination client command line, type the following.
```
brrestore -d util_file -b2 backup_id -m D:\oracle\SOURCE_SID\saparchbrarchive_detail_file==D:\oracle\DESTINATION_SID\saparch
```

On the destination client, restore the control file by using the BRRESTORE command. On the command line, type the following:

brrestore -d util_file -b2 backup_id\last -m 0

To restore from a specific backup job, type the following command:

brrestore -d util_file -b2 backup_id -m 0

Example:

brrestore -d util_file -b2 66526239_2516258 -m 0

To restore from the latest backup job, type the following command:

brrestore -d util_file -b last -m 0

Example BRRESTORE Output

BR0401I BRRESTORE 7.20 (1)
 BR0405I Start of file restore: rehlcdsc.rsb 2011-12-15 02.42.02
 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehlcdsc.rsb
 BR0454W Values of oracle_sid are different: current 'TRD', backup behkctrv.anf 'CER'
 BR0455W Value 'TRD' of oracle_sid will be used for restore
 BR0454W Values of sapdata_home are different: current 'D:\oracle\TRD', backup behkctrv.anf 'D:\oracle\CER'
 BR0455W Value 'D:\oracle\TRD' of sapdata_home will be used for restore
 BR0460W Termination message not found in D:\oracle\TRD\sapbackup\behkctrv.anf - log file incomplete (this is OK if the log fi
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.02
 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
 c
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.04
 BR0257I Your reply: 'c'
 BR0259I Program execution will be continued...
 BR0427I Files from the old sapdata_home D:\oracle\CER will be restored into the new sapdata_home D:\oracle\TRD
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.04
 BR0407I Restore of database: TRD
 BR0408I BRRESTORE action ID: rehlcdsc
 BR0409I BRRESTORE function ID: rsb
 BR0449I Restore mode: partial
 BR0411I Database files for restore:
 D:\oracle\CER\sapbackup\CNTRLCER.DBF=D:\oracle\TRD\sapbackup
 D:\oracle\CER\sapdata1\cntrl\ctrlCER.ctl
 D:\oracle\CER\sapdata2\cntrl\ctrlCER.ctl
 D:\oracle\CER\saparch\cntrl\ctrlCER.ctl
 BR0419I Files will be restored from backup: behkctrv.anf 2011-12-09 22.45.55
 BR0416I 1 file found to restore, size 10.766 MB
 BR0421I Restore device type: util_file
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.05
 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
 c
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.10
 BR0257I Your reply: 'c'
 BR0259I Program execution will be continued...
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.10
 BR0229I Calling backup utility with function 'restore'...
 BR0278I Command output of 'backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehlcdsc.lst -t file -p D:\param.txt':
 Setting the Number of streams desired=<1> for 1 File restore.
 -------------------------- Output of restore -------------------------
 BI_BACKUP=<PARTIAL>
 BI_CALLER=BRRESTORE
 BI_REQUEST=NEW
 -------------------------- Parameter Specified -------------------------
 CvInstanceName=Instance001
 CvClientName=sde-sap1
 numstreams=<1>
 srccrossclient=sde-sap2
 srccrossdbname=CER
 destdbname=CER
 -------------------------- backint Command Line -------------------------
 backintCmd=[backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehlcdsc.lst -t file -p D:\param.txt ]
 CommServeHostName=satishp
 CommClientHostName=sde-sap1.idcprodcert.loc
 Galaxy CommCellID=2
 Galaxy ClientID=219
 Src Cross Client=sde-sap2
 getInstanceId for InstanceName=[CER] client=[sde-sap1.idcprodcert.loc] clientId=219 AppType=61 Failed
 Instance=[CER] - May not have been configured.
 Galaxy SrcCrossClientID=218
 Galaxy CrossClientInstanceID=559
 Galaxy CrossClientAppType=61
 Galaxy CrossClientAppID=2283
 Number of streams desired=<1> Number of files to restore=<1> CMDLINE Job
 Restore has been requested
 SID=[CER] BkpSet=[default] AppType=[61]
 Success in getting Job id=14526 Token=<14526:2:1>
 Success in init with JM
 Attaching CommServer Session
 AfileNumber=19908, AcommCellId=2 AgroupNumber=22 archfilename=D:\oracle\CER\sapbackup\CNTRLCER.DBF copy=35 BID=13310 reqBID=1
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.31
 #FILE..... D:\oracle\CER\sapbackup\CNTRLCER.DBF D:\oracle\TRD\sapbackup\CNTRLCER.DBF
 #RESTORED. 1021752_13310
 Successful restore; 1 File(s); total transferred bytes=11288746
 Success in sending JMSUCCESS to server
 Success in sending JMSUCCESS to server
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.32
 BR0374I 1 of 1 file restored by backup utility
 BR0230I Backup utility called successfully
 BR0351I Restoring D:\ORACLE\TRD\SAPDATA1\CNTRL\ctrlCER.ctl
 BR0355I from D:\oracle\TRD\sapbackup\CNTRLCER.DBF ...
 BR0351I Restoring D:\ORACLE\TRD\SAPDATA2\CNTRL\ctrlCER.ctl
 BR0355I from D:\oracle\TRD\sapbackup\CNTRLCER.DBF ...
 BR0351I Restoring D:\ORACLE\TRD\SAPARCH\CNTRL\ctrlCER.ctl
 BR0355I from D:\oracle\TRD\sapbackup\CNTRLCER.DBF ...
 BR0406I End of file restore: rehlcdsc.rsb 2011-12-15 02.42.32
 BR0280I BRRESTORE time stamp: 2011-12-15 02.42.32
 BR0403I BRRESTORE completed successfully with warnings

On the destination client, create an SPFILE from the PFILE. On the command line, type the following:

sqlplus / as sysdba
 SQL> startup nomount;
 SQL> create spfile from pfile;

Full Output

D:\oracle\product\10.2.0\db_1\database>sqlplus / as sysdba
 SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 14 09:21:51 2011
 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
 Connected to an idle instance.
 SQL> startup nomount;
 ORACLE instance started.
 Total System Global Area 138412032 bytes 
 Fixed Size 2063992 bytes 
 Variable Size 125829512 bytes 
 Database Buffers 8388608 bytes 
 Redo Buffers 2129920 bytes 
 SQL> create spfile from pfile;
 File created.
 SQL>

On the destination client, restore the database files by using the BRRESTORE command. On the command line, type the following command, substituting the data_detail_file variable:
```
 
brrestore -d rman_util -m all -b data_detail_file
```
On the destination client, identify the log range from the log detail file and restore it. On the command line, type the following command, substituting the <DESTINATION_SID> and log_range_start variables.
```
 
brrestore -d rman_util -a log_range_start-log_range_end==D:oracleDESTINATION_SIDsaparch
```

Use SQLPLUS to recover the database by using the backup control file.

Recover from 'Destination client archivelog destination path’ database until cancel using backup control file;

UNIX Example

recover from '/database/oracle114/app/oracle/product/11.2.0/dbhome_2/CER/saparch/CERarch' database until cancel using backup controlfile

To create control files on the destination host, rename the restored control files.

On the destination host, run a SQL query similar to the one below, substituting the <DESTINATION_SID> variable.

Example

Start the database by using the control file.

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

Before You Begin

Procedure

Page contents