Advanced - SAP for Oracle Restore

Choosing Restore Types

When restoring SAP for Oracle data, it is important to consider the backup type that was originally performed.

The following table illustrates the types of restores available for each backup type:

Backup Type	Restore Level	Notes
Offline Backup	Restore Entire Database Recover Database	Since the database is offline and is consistent, there is no need for logs.
Online Backup	Restore Entire Database Restore Individual Data files/Table spaces Restore Archive Logs Restore Control File Point-In-Time Restores	Control file restore can happen only when the database is in NOMOUNT mode.
Selective Online Full Backup	Restore Entire Database Restore Individual Data files/Table spaces Restore Archive Logs Restore Control File Point-In-Time Restores	Control file restore can happen only when the database is in NOMOUNT mode.
Archive Log backup	Restore Archive Logs

The restore operations automatically identifies and uses the same SAP Backup Interface that was used for the backup.

Choosing the Restore Destination

By default, the SAP for Oracle iDataAgent restores data to the client computer from which it originated; this is referred to as an in-place restore. You can also restore the data to another client computer in the CommCell. Keep in mind the following considerations when performing such restores:

The destination client must reside in the same CommCell as the client whose data was backed up.
Note that when you perform restores other than in-place restores, the restored data assumes the rights (i.e., permissions) of the parent directory.

The following section enumerates the types of restore destinations that are supported by the SAP iDataAgent.

In-Place Restore

When restoring data, the SAP for Oracle iDataAgent provides the facility to restore the data to the same path/destination on the client computer from which the data originated; this is referred to as an in-place restore.

From the CommCell Console, perform a Browse and Restore operation.
When browsing the data, select data that was initially backed up and click Recover All Selected.
Click OK.
Select the Destination Client that was the original computer from which the data originated.
Depending on the data selected to restore, choose one of more of the options (e.g., Restore Archive Log).
Click OK.

Out-of-Place Restore

All restore levels provide the facility to restore data to a different directory on the client computer from which the data originated; this is referred to as an out-of-place restore to a different path/destination. You can also restore data to a different client computer in the CommCell using the same path/destination. This can include restoring either individual data files or tablespaces, or the entire database to another computer.

Keep in mind the following considerations when performing out-of-place restores:

The destination client must reside in the same CommCell as the client whose data was backed up.
Note that when you perform an out-of-place restore, the restored data assumes the rights (i.e., permissions) of the parent directory.

From the CommCell Console, perform a Browse and Restore operation.
When browsing the data, select data that was initially backed up and click Recover All Selected.
Click OK.
Select the Destination Client that is a different computer from which the data originated.
Depending on the data selected to restore, choose one of more of the options (e.g., Restore Archive Log).
Click OK.

Restoring to a Different Client (cross machine restore)

In cases when the original client computer is damaged, you need to restore the SAP for Oracle database to a different host. This is called a cross-machine restore. Whenever you perform such a restore, ensure that the destination machine has sufficient disk space to accommodate the restored database.

Prior to performing a cross-machine restore, do the following:

Ensure that the SAP application is installed in the destination client and an empty instance is created in the same directory structure as that in the source client.
Include the source client name in the initCER.utl file. For example,
srcCrossClient

<source client display name in CommCell Console>
Copy the initCER.sap and initCER.ora files from the source client to the destination client. You can either manually copy these files from the source client, or run the following commands to restore these files to the destination client.
brrestore -d util_file -b2 becmmcsy.anf -m /oracle_setup/dbs/init<SID>.ora

brrestore -d util_file -b2 becmmcsy.anf -m /oracle_setup/dbs/init<SID>.sap
Ensure that the following information is the same on both the source and destination clients:
- ORACLE_SID name
- /oracle/GRP/sapbackup/cntrlGRP.dbf path
- SAPDATA_HOME environment variable

Cross machine restore from commCell Console

From the CommCell Browser, right-click the SAP instance on the source client, select All Tasks then click Restore.
From the General tab, select the name of the client computer with the database you want to restore in the Destination Client from the list.
Choose the Number of streams to use for restore.
Select the following options to restore and recover the database.
- Restore Data
- Restore Archive Logs
- Control File
- Recover
Verify that the Status of the database is displayed as STARTED; if necessary click on the Refresh button to refresh the status.
Click Advanced.
From the Advanced Restore Options (Options) tab, select the following:
- Set the Reset Logs to Yes.
- Select Open DB.

Cross machine restore Using UTIL_FILE Interface from command Line

Use the following procedure to recover the latest backup which used the util_file interface to a different client computer from the SAP command line.

Locate the detail file name and the summary file name of the data and log backups to be restored on the source computer.
Restore the summary and detail files associated with the full backup.
brrestore -d util_file -b2 \#NULL -m /home/oracle/product/10g/SAPDB/CER/sapbackup/backCER.log, /home/oracle/product/10g/SAPDB/CER/sapbackup/bebwkurt.anf
Restore the control file.
brrestore -d util_file -b last -m 0
Restore the data files
brrestore -d util_file -b last -m all -u /
Restore the summary and detail files of the logs.
brrestore -d util_file -b2 \#NULL -m /home/oracle/product/10g/SAPDB/CER/saparch/archCER.log,/home/oracle/product/10g/SAPDB/CER/saparch/aebwlqlg.sve
Restore the archive Logs

brrestore -a <From ARCHIVE LOG# - To ARCHIVE LOG#>

Recover the database until recover time using control file.

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

Open DB with RESET LOGS option

sql>alter database open resetlogs

Cross machine restore Using Rman_Util Interface from command Line

Use the following procedure to recover the latest backup which used the rman_file interface to a different client computer from the SAP command line.

Locate the detail file name and the summary file name of the data and log backups to be restored on the source computer.
Restore the summary and detail files associated with the full backup.
brrestore -d util_file -b2 \#NULL -m /home/oracle/product/10g/SAPDB/CER/sapbackup/backCER.log, /home/oracle/product/10g/SAPDB/CER/sapbackup/bebwkurt.anf
Restore the summary and detail files of the logs.
brrestore -d util_file -b2 \#NULL -m /home/oracle/product/10g/SAPDB/CER/saparch/archCER.log,/home/oracle/product/10g/SAPDB/CER/saparch/aebwlqlg.sve
Restore the control file.
brrestore -d rman_util -b bebynain.anr -m 0 -c force -u / for data restores.

brrestore -d util_file -b2 SAP_1095_406 -m /home/oracle/product/10g/SAPDB/CER/sapreorg/cntrlCER.dbf -u / for log restores.
Set the database in MOUNT mode.
Restore the data files.
brrestore -d rman_util -b bebynain.anr -m all -c force -u /
Restore the archive logs.
brrestore -d rman_util -a 5 -c force -u /
Recover the database until recover time using control file.

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

Open DB with RESET LOGS option

sql>alter database open resetlogs

Cross Client Restore to a different SID name using BRRESTORE from Command Line

Use the following steps to restore to a different SID name using BRRESTORE from Command Line:

Configure initTRD.utl file for cross client restore to a different SID name. Configure the srcCrossClient in the initCER.utl and define the destination client, source client name and the source SID.	Example: D:\oracle\product\10.2.0\db_1\database>more initTRD.utl.txt numstreams 4 CvInstanceName Instance001 CvClientName sde-sap1 srcCrossClient sde-sap2 srccrossdbname CER
Copy or restore the initCER.sap on to the destination client. It is recommended to copy the file initCER.sap from the source client. However, it can also be restored.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\product\10.2.0\db_1\database\initCER.sap= =D:\oracle\product\10.2.0\db_1\database -r d:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkylvd.rsf 2011-12-14 08.41.45 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkylvd.rsf BR0280I BRRESTORE time stamp: 2011-12-14 08.41.45 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkylvd BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\product\10.2.0\db_1\database\initCER.sap= D:\oracle\product\10.2.0\db_1\database BR0416I 1 file found to restore, size 0.000 MB BR0421I Restore device type: util_file BR0280I BRRESTORE time stamp: 2011-12-14 08.41.45 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2011-12-14 08.41.49 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-14 08.41.49 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkylvd.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=<TRD> -------------------------- backint Command Line ------------------------- backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkylvd.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.prodcert.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=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
Rename the file init<OLD_SID>.sap to init<NEW_SID>.sap.	Example: D:\oracle\product\10.2.0\db_1\database>move initCER.sap initTRD.sap 1 file(s) moved
Edit the parameters in init<SID>.sap to customize it for cross client restore:	Example: backup_root_dir = D:\oracle\CER\sapbackup stage_root_dir = D:\oracle\CER\sapbackup compress_cmd = "D:\usr\sap\CER\sys\exe\run\mkszip -c $ > $" uncompress_cmd = "D:\usr\sap\CER\sys\exe\run\uncompress -c $ > $" compress_dir = D:\oracle\CER\sapreorg archive_copy_dir = D:\oracle\CER\sapbackup archive_stage_dir = D:\oracle\CER\sapbackup Change the above parameters with NEW_SID name appropriately as below. backup_root_dir = D:\oracle\trd\sapbackup stage_root_dir = D:\oracle\trd\sapbackup compress_cmd = "D:\usr\sap\TRD\sys\exe\run\mkszip -c $ > $" uncompress_cmd = "D:\usr\sap\TRD\sys\exe\run\uncompress -c $ > $" compress_dir = D:\oracle\trd\sapreorg archive_copy_dir = D:\oracle\trd\sapbackup archive_stage_dir = D:\oracle\trd\sapbackup
Copy or restore the init<OLD_SID>.ora on to the destination client. It is recommended to copy the initCER.ora from the source onto the destination computer. However, it can also be restored.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\product\10.2.0\db_1\database\initCER.ora= =D:\oracle\product\10.2.0\db_1\database -r d:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkyntp.rsf 2011-12-14 09.03.37 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkyntp.rsf BR0280I BRRESTORE time stamp: 2011-12-14 09.03.37 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkyntp BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\product\10.2.0\db_1\database\initCER.ora= D:\oracle\product\10.2.0\db_1\database BR0416I 1 file found to restore, size 0.000 MB BR0421I Restore device type: util_file BR0280I BRRESTORE time stamp: 2011-12-14 09.03.37 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2011-12-14 09.03.40 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-14 09.03.40 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyntp.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=<TRD> -------------------------- backint Command Line ------------------------- backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyntp.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=14426 Token=<14426:2:1> Success in init with JM Cannot obtain the Index MediaAgent from the Archive Manager.. Attaching CommServer Session AfileNumber=19928, AcommCellId=2 AgroupNumber=23 archfilename= D:\oracle\product\10.2.0\db_1\database\initCER.ora copy=36 BID=13310 reqBID=13310 afileFlags=4d BR0280I BRRESTORE time stamp: 2011-12-14 09.04.04 #FILE..... D:\oracle\product\10.2.0\db_1\database\initCER.ora D:\oracle\product\10.2.0\db_1\database\initCER.ora #RESTORED. 1021752_13310 Successful restore; 1 File(s); total transferred bytes=4696 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-14 09.04.05 BR0374I 1 of 1 file restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehkyntp.rsf 2011-12-14 09.04.05 BR0280I BRRESTORE time stamp: 2011-12-14 09.04.05 BR0402I BRRESTORE completed successfully
Rename initCER.ora to initTRD.ora.	Example: D:\oracle\product\10.2.0\db_1\database>move initCER.ora initTRD.ora 1 file(s) moved
Edit the init<NEW_SID>.ora file and replace the parameters with a new directory Structure:	Example: control_files = (D:\oracle\trd\sapdata1\cntrl\ctrlCER.ctl, D:\oracle\trd\sapdata2\cntrl\ctrlCER.ctl, D:\oracle\trd\saparch\cntrl\ctrlCER.ctl) background_dump_dest = D:\oracle\trd\saptrace\background user_dump_dest = D:\oracle\trd\saptrace\usertrace log_archive_dest = D:\oracle\trd\saparch
Create an SPFILE from the PFILE.	Example: 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>
Copy or restore the <OLD_SID>.log file.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\sapbackup\backCER.log==D:\oracle\TRD\sapbackup -r d:\param.txt 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 \#NULL: 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> CvClientName=<sde-sap1> numstreams=<1> srccrossclient=<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 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=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
Rename the back<OLD_SID>.log to back<NEW_SID>.log file.	Example: D:\oracle\TRD\sapbackup>move backCER.log backTRD.log 1 file(s) moved.
Copy or restore the arch<OLD_SID>.log. It is recommended to copy the Log Summary File from the source computer. However, it can also be restored.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\saparch\archCER.log==D:\oracle\TRD\saparch -r d:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkyscr.rsf 2011-12-14 09.52.37 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkyscr.rsf BR0280I BRRESTORE time stamp: 2011-12-14 09.52.37 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkyscr BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\CER\saparch\archCER.log=D:\oracle\TRD\saparch BR0416I 1 file found to restore, size 0.000 MB BR0421I Restore device type: util_file BR0280I BRRESTORE time stamp: 2011-12-14 09.52.37 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: BR0280I BRRESTORE time stamp: 2011-12-14 09.52.37 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: cc BR0280I BRRESTORE time stamp: 2011-12-14 09.52.49 BR0258W Wrong reply: 'cc' BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2011-12-14 09.52.53 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-14 09.52.53 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyscr.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=<TRD> -------------------------- backint Command Line ------------------------- backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyscr.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=14432 Token=<14432:2:1> Success in init with JM Cannot obtain the Index MediaAgent from the Archive Manager.. Attaching CommServer Session AfileNumber=19932, AcommCellId=2 AgroupNumber=23 archfilename=D:\oracle\CER\saparch\archCER.log copy=36 BID=13310 reqBID=13310 afileFlags=14d BR0280I BRRESTORE time stamp: 2011-12-14 09.53.15 #FILE..... D:\oracle\CER\saparch\archCER.log D:\oracle\TRD\saparch\archCER.log #RESTORED. 1021752_13310 Successful restore; 1 File(s); total transferred bytes=11644 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-14 09.53.16 BR0374I 1 of 1 file restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehkyscr.rsf 2011-12-14 09.53.16 BR0280I BRRESTORE time stamp: 2011-12-14 09.53.16 BR0403I BRRESTORE completed successfully with warnings.
Rename arch<OLD_SID>.log to arch<NEW_SID>.log	Example: D:\oracle\TRD\saparch>move archCER.log archTRD.log 1 file(s) moved.
You can copy or identify and restore the detail files needed for for cross client restore to a different SID name. It is recommended to copy the detail files from the sapbackup and the saparch directory onto the destination computer.
Identify the corresponding detail file in $SAPDATA_HOME/sapbackup directory from Source computer and restore it.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\sapbackup\behkctrv.anf==D:\oracle\TRD\sapbackup -r D:\param.txt
Identify the corresponding detail file in $SAPDATA_HOME/saparch directory from Source computer and restore it.	brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\saparch\aehkctzc.sve==D:\oracle\TRD\saparch -r D:\param.txt
Restore the Control File using BRRESTORE.	brrestore -d util_file -b last -m 0 -r D:\param.txt
Restore the database files using BRRESTORE.	brrestore -d util_file -m all -b behkctrv.anf -r D:\param.txt
Restore the logs using BRRESTORE.	brrestore -d util_file -a 65-75==D:\oracle\TRD\saparch -r D:\param.txt
Set the database in MOUNT mode and copy the backup control file to trace on the destination computer.	Perform the below on target machine. 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\TRD\sapbackup\CNTRLTRD.NEW'; Database altered. SQL> alter database backup controlfile to trace as 'D:\oracle\TRD\sapbackup\control.ora'; Database altered. SQL>
For an online backup, create a control file using the following SQL script for restoring the online backup:	Example: Below case is Cross Client Restore from Online Backup: Now Shutdown DB. Goto SPFILE and Edit parameter "db_name" from <OLD_SID> to <NEW_SID> Then make DB NOMOUNT. Open trace file('D:\oracle\TRD\sapbackup\control.ora') that created from above syntax. Change the SQL qurey from REUSE to SET, OLD_SID to NEW_SID & NORESETLOGS to RESETLOGS. Edit the Path from Old DIR Structure to New DIR structure. Now the Query should look like below: STARTUP NOMOUNT CREATE CONTROLFILE SET DATABASE "TRD" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 16 MAXLOGHISTORY 1752 LOGFILE GROUP 1 ( 'D:\ORACLE\TRD\ORIGLOGA\LOG1_M1.DBF', 'D:\ORACLE\TRD\MIRRLOGA\LOG1_M2.DBF' ) SIZE 10M, GROUP 2 ( 'D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF', 'D:\ORACLE\TRD\MIRRLOGB\LOG2_M2.DBF' ) SIZE 10M, GROUP 3 ( 'D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF', 'D:\ORACLE\TRD\MIRRLOGA\LOG3_M2.DBF' ) SIZE 10M, GROUP 4 ( 'D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF', 'D:\ORACLE\TRD\MIRRLOGB\LOG4_M2.DBF' ) SIZE 10M -- STANDBY LOGFILE DATAFILE 'D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1', 'D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1', 'D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF', 'D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1', 'D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1' CHARACTER SET US7ASCII ;
Run the SQL query to create a control file.	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 "TRD" 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\TRD\ORIGLOGA\LOG1_M1.DBF', 10 'D:\ORACLE\TRD\MIRRLOGA\LOG1_M2.DBF' 11 ) SIZE 10M, 12 GROUP 2 ( 13 'D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF', 14 'D:\ORACLE\TRD\MIRRLOGB\LOG2_M2.DBF' 15 ) SIZE 10M, 16 GROUP 3 ( 17 'D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF', 18 'D:\ORACLE\TRD\MIRRLOGA\LOG3_M2.DBF' 19 ) SIZE 10M, 20 GROUP 4 ( 21 'D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF', 22 'D:\ORACLE\TRD\MIRRLOGB\LOG4_M2.DBF' 23 ) SIZE 10M 24 -- STANDBY LOGFILE 25 DATAFILE 26 'D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1', 27 'D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1', 28 'D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF', 29 'D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1', 30 'D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1' 31 CHARACTER SET US7ASCII 32 ; Control file created.
Manually, run the SQL query to Recover DB, Open DB and add the temporary tablespace.	SQL> SQL> 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\TRD\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\TRD\SAPARCH\ARC00075_0769082544.001 ORA-00280: change 397401 for thread 1 is in sequence #75 ORA-00278: log file 'D:\ORACLE\TRD\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\TRD\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\TRD\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\TRD\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\TRD\SAPDATA1\TEMP_1\TEMP.DATA1' REUSE; Tablespace altered. SQL>

Cross Client Restore to a different SID name using BRRECOVER from Command Line

Prior to performing a cross-client restore to a different SID name using BRRECOVER, do the following:

Use BR*Tools 7.00 and above to perform a cross-client restore to a different SID name using BRRECOVER. If you are using BR*Tools below the 7.00 versions, then use BRRESTORE to perform a cross-client restore to a different SID name.
You need to create a top level directory structure for the destination Database. This will allow you to configure the environment variables like Oracle_SID and other pertinent variables (based on the SAP Note: 0001003028).

Use the following steps to restore to a different SID name using BRRECOVER from Command Line:

Configure initTRD.utl file for cross client restore to a different SID name. Configure the srcCrossClient in the initCER.utl and define the destination client, source client name and the source SID.	Example: D:\oracle\product\10.2.0\db_1\database>more initTRD.utl.txt numstreams 4 CvInstanceName Instance001 CvClientName sde-sap1 srcCrossClient sde-sap2 srccrossdbname CER
Copy or restore the initCER.sap on to the destination client. It is recommended to copy the file initCER.sap from the source client. However, it can also be restored.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\product\10.2.0\db_1\database\initCER.sap= =D:\oracle\product\10.2.0\db_1\database -r d:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkylvd.rsf 2011-12-14 08.41.45 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkylvd.rsf BR0280I BRRESTORE time stamp: 2011-12-14 08.41.45 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkylvd BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\product\10.2.0\db_1\database\initCER.sap= D:\oracle\product\10.2.0\db_1\database BR0416I 1 file found to restore, size 0.000 MB BR0421I Restore device type: util_file BR0280I BRRESTORE time stamp: 2011-12-14 08.41.45 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2011-12-14 08.41.49 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-14 08.41.49 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkylvd.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=<TRD> -------------------------- backint Command Line ------------------------- backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkylvd.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.prodcert.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=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
Rename the file init<OLD_SID>.sap to init<NEW_SID>.sap.	Example: D:\oracle\product\10.2.0\db_1\database>move initCER.sap initTRD.sap 1 file(s) moved
Edit the parameters in init<SID>.sap to customize it for cross client restore:	Example: backup_root_dir = D:\oracle\CER\sapbackup stage_root_dir = D:\oracle\CER\sapbackup compress_cmd = "D:\usr\sap\CER\sys\exe\run\mkszip -c $ > $" uncompress_cmd = "D:\usr\sap\CER\sys\exe\run\uncompress -c $ > $" compress_dir = D:\oracle\CER\sapreorg archive_copy_dir = D:\oracle\CER\sapbackup archive_stage_dir = D:\oracle\CER\sapbackup Change the above parameters with NEW_SID name appropriately as below. backup_root_dir = D:\oracle\trd\sapbackup stage_root_dir = D:\oracle\trd\sapbackup compress_cmd = "D:\usr\sap\TRD\sys\exe\run\mkszip -c $ > $" uncompress_cmd = "D:\usr\sap\TRD\sys\exe\run\uncompress -c $ > $" compress_dir = D:\oracle\trd\sapreorg archive_copy_dir = D:\oracle\trd\sapbackup archive_stage_dir = D:\oracle\trd\sapbackup
Copy or restore the init<OLD_SID>.ora on to the destination client. It is recommended to copy the initCER.ora from the source onto the destination computer. However, it can also be restored.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\product\10.2.0\db_1\database\initCER.ora= =D:\oracle\product\10.2.0\db_1\database -r d:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkyntp.rsf 2011-12-14 09.03.37 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkyntp.rsf BR0280I BRRESTORE time stamp: 2011-12-14 09.03.37 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkyntp BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\product\10.2.0\db_1\database\initCER.ora= D:\oracle\product\10.2.0\db_1\database BR0416I 1 file found to restore, size 0.000 MB BR0421I Restore device type: util_file BR0280I BRRESTORE time stamp: 2011-12-14 09.03.37 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2011-12-14 09.03.40 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-14 09.03.40 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyntp.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=<TRD> -------------------------- backint Command Line ------------------------- backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyntp.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=14426 Token=<14426:2:1> Success in init with JM Cannot obtain the Index MediaAgent from the Archive Manager.. Attaching CommServer Session AfileNumber=19928, AcommCellId=2 AgroupNumber=23 archfilename= D:\oracle\product\10.2.0\db_1\database\initCER.ora copy=36 BID=13310 reqBID=13310 afileFlags=4d BR0280I BRRESTORE time stamp: 2011-12-14 09.04.04 #FILE..... D:\oracle\product\10.2.0\db_1\database\initCER.ora D:\oracle\product\10.2.0\db_1\database\initCER.ora #RESTORED. 1021752_13310 Successful restore; 1 File(s); total transferred bytes=4696 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-14 09.04.05 BR0374I 1 of 1 file restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehkyntp.rsf 2011-12-14 09.04.05 BR0280I BRRESTORE time stamp: 2011-12-14 09.04.05 BR0402I BRRESTORE completed successfully
Rename initCER.ora to initTRD.ora.	Example: D:\oracle\product\10.2.0\db_1\database>move initCER.ora initTRD.ora 1 file(s) moved
Edit the init<NEW_SID>.ora file and replace the parameters with a new directory Structure:	Example: control_files = (D:\oracle\trd\sapdata1\cntrl\ctrlCER.ctl, D:\oracle\trd\sapdata2\cntrl\ctrlCER.ctl, D:\oracle\trd\saparch\cntrl\ctrlCER.ctl) background_dump_dest = D:\oracle\trd\saptrace\background user_dump_dest = D:\oracle\trd\saptrace\usertrace log_archive_dest = D:\oracle\trd\saparch
Create an SPFILE from the PFILE.	Example: 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>
Copy or restore the <OLD_SID>.log file.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\sapbackup\backCER.log==D:\oracle\TRD\sapbackup -r d:\param.txt 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 \#NULL: 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> CvClientName=<sde-sap1> numstreams=<1> srccrossclient=<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 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=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
Rename the back<OLD_SID>.log to back<NEW_SID>.log file.	Example: D:\oracle\TRD\sapbackup>move backCER.log backTRD.log 1 file(s) moved.
Copy or restore the arch<OLD_SID>.log. It is recommended to copy the Log Summary File from the source computer. However, it can also be restored.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\saparch\archCER.log==D:\oracle\TRD\saparch -r d:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkyscr.rsf 2011-12-14 09.52.37 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkyscr.rsf BR0280I BRRESTORE time stamp: 2011-12-14 09.52.37 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkyscr BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\CER\saparch\archCER.log=D:\oracle\TRD\saparch BR0416I 1 file found to restore, size 0.000 MB BR0421I Restore device type: util_file BR0280I BRRESTORE time stamp: 2011-12-14 09.52.37 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: BR0280I BRRESTORE time stamp: 2011-12-14 09.52.37 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: cc BR0280I BRRESTORE time stamp: 2011-12-14 09.52.49 BR0258W Wrong reply: 'cc' BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2011-12-14 09.52.53 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-14 09.52.53 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyscr.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=<TRD> -------------------------- backint Command Line -------------------- backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkyscr.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=14432 Token=<14432:2:1> Success in init with JM Cannot obtain the Index MediaAgent from the Archive Manager.. Attaching CommServer Session AfileNumber=19932, AcommCellId=2 AgroupNumber=23 archfilename=D:\oracle\CER\saparch\archCER.log copy=36 BID=13310 reqBID=13310 afileFlags=14d BR0280I BRRESTORE time stamp: 2011-12-14 09.53.15 #FILE..... D:\oracle\CER\saparch\archCER.log D:\oracle\TRD\saparch\archCER.log #RESTORED. 1021752_13310 Successful restore; 1 File(s); total transferred bytes=11644 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-14 09.53.16 BR0374I 1 of 1 file restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehkyscr.rsf 2011-12-14 09.53.16 BR0280I BRRESTORE time stamp: 2011-12-14 09.53.16 BR0403I BRRESTORE completed successfully with warnings.
Rename arch<OLD_SID>.log to arch<NEW_SID>.log	Example: D:\oracle\TRD\saparch>move archCER.log archTRD.log 1 file(s) moved.
Identify the corresponding detail file in $SAPDATA_HOME/sapbackup directory from Source computer and restore it. You can copy or identify and restore the detail files needed for for cross client restore to a different SID name. It is recommended to copy the detail files from the sapbackup and the saparch directory onto the destination computer.	Example: D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\sapbackup\behkctrv.anf==D:\oracle\TRD\sapbackup -r D:\param.txt
Identify the corresponding detail file in $SAPDATA_HOME/saparch directory from Source computer and restore it.	brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\saparch\aehkctzc.sve==D:\oracle\TRD\saparch -r D:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkysrd.rsf 2011-12-14 09.58.53 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkysrd.rsf BR0280I BRRESTORE time stamp: 2011-12-14 09.58.53 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkysrd BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\CER\sapbackup\behkctrv.anf=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.58.53 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2011-12-14 09.58.55 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-14 09.58.55 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkysrd.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=<TRD> -------------------------- backint Command Line ------------------------- backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkysrd.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=14434 Token=<14434:2:1> Success in init with JM Cannot obtain the Index MediaAgent from the Archive Manager.. Attaching CommServer Session AfileNumber=19913, AcommCellId=2 AgroupNumber=22 archfilename=D:\oracle\CER\sapbackup\behkctrv.anf copy=35 BID=13310 reqBID=13310 afileFlags=0d BR0280I BRRESTORE time stamp: 2011-12-14 09.59.18 #FILE..... D:\oracle\CER\sapbackup\behkctrv.anf D:\oracle\TRD\sapbackup\behkctrv.anf #RESTORED. 1021752_13310 Successful restore; 1 File(s); total transferred bytes=10940 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-14 09.59.19 BR0374I 1 of 1 file restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehkysrd.rsf 2011-12-14 09.59.19 BR0280I BRRESTORE time stamp: 2011-12-14 09.59.19 BR0402I BRRESTORE completed successfully Identify the corresponding Detail file in $SAPDATA_HOME/saparch DIR from Source machine and restore it. In the example below aehkctzc.sve is the source detail file pertaining to the log backups brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\saparch\aehkctzc.sve==D:\oracle\TRD\saparch -r D:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkytcm.rsf 2011-12-14 10.03.48 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkytcm.rsf BR0101I Parameters Name Value oracle_sid TRD oracle_home D:\oracle\product\10.2.0\db_1 oracle_profile D:\oracle\product\10.2.0\db_1\database\initTRD.ora sapdata_home D:\oracle\TRD sap_profile D:\oracle\product\10.2.0\db_1\database\initTRD.sap recov_interval 30 restore_mode D:\oracle\CER\saparch\aehkctzc.sve=D:\oracle\TRD\saparch backup_dev_type util_file util_par_file D:\param.txt system_info Administrator SDE-SAP1 Windows 6.1 Build 7601 Service Pack 1 AMD64 oracle_info CER 10.2.0.4.0 make_info NTAMD64 OCI_10201_SHARE Feb 25 2010 command_line brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\saparch\aehkctzc.sve==D:\oracle\TRD\saparch -r D:\param.txt BR0280I BRRESTORE time stamp: 2011-12-14 10.03.48 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkytcm BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\CER\saparch\aehkctzc.sve=D:\oracle\TRD\saparch BR0416I 1 file found to restore, size 0.000 MB BR0421I Restore device type: util_file BR0280I BRRESTORE time stamp: 2011-12-14 10.03.48 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: BR0280I BRRESTORE time stamp: 2011-12-14 10.03.52 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-14 10.03.52 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkytcm.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=<TRD> -------------------------- backint Command Line ---------------------backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehkytcm.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=14438 Token=<14438:2:1> Success in init with JM Cannot obtain the Index MediaAgent from the Archive Manager.. Attaching CommServer Session AfileNumber=19931, AcommCellId=2 AgroupNumber=23 archfilename=D:\oracle\CER\saparch\aehkctzc.sve copy=36 BID=13310 reqBID=13310 afileFlags=14d BR0280I BRRESTORE time stamp: 2011-12-14 10.04.17 #FILE..... D:\oracle\CER\saparch\aehkctzc.sve D:\oracle\TRD\saparch\aehkctzc.sve #RESTORED. 1021752_13310 Successful restore; 1 File(s); total transferred bytes=8258 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-14 10.04.17 BR0374I 1 of 1 file restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehkytcm.rsf 2011-12-14 10.04.17 BR0280I BRRESTORE time stamp: 2011-12-14 10.04.17 BR0402I BRRESTORE completed successfully
For an online backup, restore the data and logs, create a control file and recover and Open the database using BRRECOVER.	brrecover -f TRD -t dbpit -n last -c force -r D:\param.txt BR0701I BRRECOVER 7.20 (1) BR0705I Start of database recovery: vehkytgp.dpt 2011-12-14 10.05.35 BR0484I BRRECOVER log file: D:\oracle\TRD\sapbackup\vehkytgp.dpt BR0101I Parameters Name Value oracle_sid TRD oracle_home D:\oracle\product\10.2.0\db_1 oracle_profile D:\oracle\product\10.2.0\db_1\database\initTRD.ora sapdata_home D:\oracle\TRD sap_profile D:\oracle\product\10.2.0\db_1\database\initTRD.sap recov_type dbpit recov_copy_dir D:\oracle\TRD\sapbackup recov_interval 30 scroll_lines 20 backup_dev_type tape system_info Administrator SDE-SAP1 Windows 6.1 Build 7601 Service Pack 1 AMD64 oracle_info CER 10.2.0.4.0 make_info NTAMD64 OCI_10201_SHARE Feb 25 2010 command_line brrecover -f TRD -t dbpit -n last -c force -r D:\param.txt BR0280I BRRECOVER time stamp: 2011-12-14 10.05.35 BR0707I Recovery of database: TRD BR0708I BRRECOVER action ID: vehkytgp BR0709I BRRECOVER function ID: dpt BR0710I Recovery type: dbpit BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRECOVER time stamp: 2011-12-14 10.05.35 BR0655I Control menu 103 # please decide how to proceed ------------------------------------------------------------------------------- Database point-in-time recovery main menu 1 = Set point-in-time for recovery 2 * Select database backup or flashback 3 * Check the status of database files 4 * Restore control files 5 * Restore data files 6 * Restore split incremental control files 7 * Restore and apply incremental backup 8 * Restore and apply archivelog files 9 * Restore archivelog files and flashback 10 * Open database and post-processing 11 * Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.05.35 BR0134I Unattended mode with 'force' active - continuing processing with default reply '1' BR0280I BRRECOVER time stamp: 2011-12-14 10.05.35 BR0657I Input menu 104 # please enter/check input values ------------------------------------------------------------------------------- Options for point-in-time recovery of database CER 1 # Database instance of archivelog thread (instance) . [] 2 ~ Last archivelog sequence to apply (last_seq) ...... [99999999] 3 ~ Last system change number to apply (last_scn) ..... [] 4 ~ End point-in-time for recovery (end_pit) .......... [] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.05.35 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-14 10.05.35 BR0655I Control menu 103 # please decide how to proceed ------------------------------------------------------------------------------- Database point-in-time recovery main menu 1 + Set point-in-time for recovery 2 = Select database backup or flashback 3 * Check the status of database files 4 * Restore control files 5 * Restore data files 6 * Restore split incremental control files 7 * Restore and apply incremental backup 8 * Restore and apply archivelog files 9 * Restore archivelog files and flashback 10 * Open database and post-processing 11 * Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.05.35 BR0134I Unattended mode with 'force' active - continuing processing with default reply '2' BR0699I Reading log file D:\oracle\TRD\sapbackup\backTRD.log ... BR0350I Backup utility will be inquired for backup confirmation BR0280I BRRECOVER time stamp: 2011-12-14 10.05.35 BR0229I Calling backup utility with function 'inquire'... BR0278I Command output of 'backint -u TRD -f inquire -i D:\oracle\TRD\sapbackup\.vehkytgp.lst -t file -p D:\param.txt -c': -------------------------- Output of inquire ------------------------- BI_BACKUP=<PARTIAL> BI_CALLER=<BRRECOVER> BI_REQUEST=<NEW> -------------------------- Parameter Specified ------------------------- CvInstanceName=<Instance001> CvClientName=<sde-sap1> numstreams=<4> srccrossclient=<sde-sap2> srccrossdbname=<CER> destdbname=<TRD> -------------------------- backint Command Line ------------------------- backintCmd=[backint -u TRD -f inquire -i D:\oracle\TRD\sapbackup\.vehkytgp.lst -t file -p D:\param.txt -c ] CommServeHostName=satishp CommClientHostName=sde-sap1.idcprodcert.loc Galaxy CommCellID=2 Galaxy ClientID=219 Inquire has been requested 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 BR0280I BRRECOVER time stamp: 2011-12-14 10.05.37 BR1520I 6 file backups confirmed by backup utility BR0230I Backup utility called successfully BR0280I BRRECOVER time stamp: 2011-12-14 10.05.37 BR0659I List menu 105 # please select one or more entries ------------------------------------------------------------------------------- Database backups / flashback for database point-in-time recovery Pos. Log/FBack Start time Type/SCN Mode Device Rc UVol1/Stat. 1 = behkctrv.anf 2011-12-09 22.45.55 online all util_file 9 <confirmed> 2 - behjosei.anf 2011-12-07 02.07.44 online all util_file 0 .......... 3 - behjkmqh.aff 2011-12-06 05.33.35 offl_force all util_file 0 .......... 4 - behjhzai.anf 2011-12-05 17.14.20 online all util_fonl 0 .......... 5 - behjhyte.anf 2011-12-05 17.11.14 online all util_file 0 .......... Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.05.37 BR0134I Unattended mode with 'force' active - continuing processing with default reply '1' BR0699I Reading log file D:\oracle\TRD\sapbackup\behkctrv.anf ... 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 file was restored) BR0280I BRRECOVER time stamp: 2011-12-14 10.05.37 BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action BR0126I Unattended mode active - continuing processing with default reply 'cont' BR0772I Checking the availability of archivelog files for database instance TRD ... BR0699I Reading log file D:\oracle\TRD\saparch\archTRD.log for device type 'disk'... BR0699I Reading log file D:\oracle\TRD\saparch\archTRD.log for device type 'tape/backint/rman'... BR0699I Reading log file D:\oracle\TRD\saparch\archTRD.log for device type 'stage'... BR0280I BRRECOVER time stamp: 2011-12-14 10.05.37 BR0655I Control menu 103 # please decide how to proceed ------------------------------------------------------------------------------- Database point-in-time recovery main menu 1 + Set point-in-time for recovery 2 + Select database backup or flashback 3 = Check the status of database files 4 * Restore control files 5 * Restore data files 6 # Restore split incremental control files 7 # Restore and apply incremental backup 8 * Restore and apply archivelog files 9 # Restore archivelog files and flashback 10 * Open database and post-processing 11 * Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.05.37 BR0134I Unattended mode with 'force' active - continuing processing with default reply '3' BR0753W Control file 'D:\oracle\TRD\sapdata1\cntrl\ctrlCER.ctl' not found BR0753W Control file 'D:\oracle\TRD\sapdata2\cntrl\ctrlCER.ctl' not found BR0753W Control file 'D:\oracle\TRD\saparch\cntrl\ctrlCER.ctl' not found BR0617I Database instance TRD is started BR0064I Database instance TRD will be shut down now in mode 'IMMEDIATE' BR0280I BRRECOVER time stamp: 2011-12-14 10.05.38 BR0307I Shutting down database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-14 10.05.42 BR0308I Shutdown of database instance TRD successful BR0751W Database instance TRD cannot be mounted due to missing control files BR0755I Checking the status of database files for instance TRD... BR0280I BRRECOVER time stamp: 2011-12-14 10.05.42 BR0655I Control menu 103 # please decide how to proceed ------------------------------------------------------------------------------- Database point-in-time recovery main menu 1 + Set point-in-time for recovery 2 + Select database backup or flashback 3 + Check the status of database files 4 = Restore control files 5 * Restore data files 6 # Restore split incremental control files 7 # Restore and apply incremental backup 8 * Restore and apply archivelog files 9 # Restore archivelog files and flashback 10 * Open database and post-processing 11 * Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.05.42 BR0134I Unattended mode with 'force' active - continuing processing with default reply '4' BR0613I Database instance TRD is shut down BR0280I BRRECOVER time stamp: 2011-12-14 10.05.43 BR0657I Input menu 111 # please enter/check input values ------------------------------------------------------------------------------- BRRESTORE main options for restore of database files 1 - BRRESTORE profile (profile) ........ [initTRD.sap] 2 - BRBACKUP backup run (backup) ....... [behkctrv.anf] 3 - Fill-up previous restores (fillup) . [no] 4 - Restore device type (device) ....... [util_file] 5 - BACKINT/Mount profile (parfile) .... [D:\param.txt] 6 # Database user/password (user) ...... [system/******] 7 - Files for restore (mode) ........... [0] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.05.43 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-14 10.05.43 BR0657I Input menu 112 # please enter/check input values ------------------------------------------------------------------------------- Additional BRRESTORE options for restore of database files 1 - Confirmation mode (confirm) ...... [force] 2 - Query mode (query) ............... [no] 3 # Compression mode (compress) ...... [no] 4 # Parallel execution (execute) ..... [0] 5 - Additional output (output) ....... [no] 6 - Message language (language) ...... [E] 7 - BRRESTORE command line (command) . [-p initTRD.sap -b behkctrv.anf -d util_file -r D:\param.txt -m 0 -c force -l E] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.05.43 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0291I BRRESTORE will be started with options '-p initTRD.sap -b behkctrv.anf -d util_file -r D:\param.txt -m 0 -c force -l E' ================================================= BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkytgx.rsb 2011-12-14 10.05.43 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkytgx.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 file was restored) 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-14 10.05.43 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkytgx 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 BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRESTORE time stamp: 2011-12-14 10.05.43 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehkytgx.lst -t file -p D:\param.txt -c': 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\.rehkytgx.lst -t file -p D:\param.txt -c ] 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=14440 Token=<14440: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=13310 afileFlags=0d BR0280I BRRESTORE time stamp: 2011-12-14 10.06.12 #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-14 10.06.13 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: rehkytgx.rsb 2011-12-14 10.06.13 BR0280I BRRESTORE time stamp: 2011-12-14 10.06.13 BR0403I BRRESTORE completed successfully with warnings ============================================= BR0292I Execution of BRRESTORE finished with return code 1 BR0280I BRRECOVER time stamp: 2011-12-14 10.06.13 BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action BR0126I Unattended mode active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-14 10.06.13 BR0655I Control menu 103 # please decide how to proceed ------------------------------------------------------------------------------- Database point-in-time recovery main menu 1 + Set point-in-time for recovery 2 + Select database backup or flashback 3 + Check the status of database files 4 + Restore control files 5 = Restore data files 6 # Restore split incremental control files 7 # Restore and apply incremental backup 8 Restore and apply archivelog files 9 # Restore archivelog files and flashback 10 * Open database and post-processing 11 * Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.06.13 BR0134I Unattended mode with 'force' active - continuing processing with default reply '5' BR0613I Database instance TRD is shut down BR0750I Database instance TRD will be mounted now BR0280I BRRECOVER time stamp: 2011-12-14 10.06.14 BR0330I Starting and mounting database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-14 10.06.22 BR0331I Start and mount of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-14 10.06.22 BR0657I Input menu 111 # please enter/check input values ------------------------------------------------------------------------------- BRRESTORE main options for restore of database files 1 - BRRESTORE profile (profile) ........ [initTRD.sap] 2 - BRBACKUP backup run (backup) ....... [behkctrv.anf] 3 - Fill-up previous restores (fillup) . [no] 4 - Restore device type (device) ....... [util_file] 5 - BACKINT/Mount profile (parfile) .... [D:\param.txt] 6 # Database user/password (user) ...... [system/******] 7 - Files for restore (mode) ........... [all] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.06.22 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-14 10.06.22 BR0657I Input menu 112 # please enter/check input values ------------------------------------------------------------------------------- Additional BRRESTORE options for restore of database files 1 - Confirmation mode (confirm) ...... [force] 2 - Query mode (query) ............... [no] 3 # Compression mode (compress) ...... [no] 4 # Parallel execution (execute) ..... [0] 5 - Additional output (output) ....... [no] 6 - Message language (language) ...... [E] 7 - BRRESTORE command line (command) . [-p initTRD.sap -b behkctrv.anf -d util_file -r D:\param.txt -m all -c force -l E] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.06.22 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0291I BRRESTORE will be started with options '-p initTRD.sap -b behkctrv.anf -d util_file -r D:\param.txt -m all -c force -l E' ================================================= BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkytik.rsb 2011-12-14 10.06.22 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkytik.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 file was restored) BR0427I Files from the old sapdata_home D:\oracle\CER will be restored into the new sapdata_home D:\oracle\TRD BR0370I Directory D:\ORACLE\TRD\SAPDATA2\CER_1 created BR0370I Directory D:\ORACLE\TRD\SAPDATA3\CERUSR_1 created BR0456I Probably the database must be recovered due to restore from online backup BR0280I BRRESTORE time stamp: 2011-12-14 10.06.22 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkytik BR0409I BRRESTORE function ID: rsb BR0449I Restore mode: ALL BR0419I Files will be restored from backup: behkctrv.anf 2011-12-09 22.45.55 BR0416I 5 files found to restore, total size 660.039 MB BR0421I Restore device type: util_file BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRESTORE time stamp: 2011-12-14 10.06.22 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehkytik.lst -t file -p D:\param.txt -c': -------------------------- Output of restore ------------------------- BI_BACKUP=<FULL> 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\.rehkytik.lst -t file -p D:\param.txt -c ] 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 Total number of Collect Files Generated=<3> Setting the Number of streams desired=<3> to the total number of collect files generated. Number of streams desired=<3> Number of files to restore=<3> CMDLINE Job Restore has been requested SID=[CER] BkpSet=[default] AppType=[61] Success in getting Job id=14441 Token=<14441: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 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 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 CrossClientInstanceID=559 Galaxy CrossClientAppType=61 Galaxy CrossClientAppID=2283 Restore has been requested Success in init with JM Galaxy SrcCrossClientID=218 Attaching CommServer Session Galaxy CrossClientInstanceID=559 Galaxy CrossClientAppType=61 Galaxy CrossClientAppID=2283 Restore has been requested Success in init with JM Attaching CommServer Session Restoring from MediaId=<22_MagVolId_9086> Galaxy CrossClientInstanceID=559 Galaxy CrossClientAppType=61 Galaxy CrossClientAppID=2283 Restore has been requested Success in init with JM Attaching CommServer Session Restoring from MediaId=<22_MagVolId_9088> Restoring from MediaId=<22_MagVolId_9087> RESTORED backupId=<1021752_13310> nextFile=<D:\ORACLE\CER\SAPDATA2\CER_1\CER.DATA1> BR0280I BRRESTORE time stamp: 2011-12-14 10.06.48 #FILE..... D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1 #RESTORED. 1021752_13310 RESTORED backupId=<1021752_13310> nextFile=<D:\ORACLE\CER\SAPDATA3\CERUSR_1\CERUSR.DATA1> BR0280I BRRESTORE time stamp: 2011-12-14 10.06.50 #FILE..... D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1 #RESTORED. 1021752_13310 RESTORED backupId=<1021752_13310> nextFile=<D:\ORACLE\CER\SAPDATA1\UNDO_1\UNDO.DATA1> BR0280I BRRESTORE time stamp: 2011-12-14 10.06.56 #FILE..... D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1 #RESTORED. 1021752_13310 Sending file=<#EOF> to the Child=<3912> Successful restore; 1 File(s); total transferred bytes=104865966 RESTORED backupId=<1021752_13310> nextFile=<D:\ORACLE\CER\SAPDATA1\SYSTEM_1\SYSAUX.DBF> BR0280I BRRESTORE time stamp: 2011-12-14 10.07.12 #FILE..... D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF #RESTORED. 1021752_13310 Sending file=<#EOF> to the Child=<1920> Successful restore; 2 File(s); total transferred bytes=115360098 RESTORED backupId=<1021752_13310> nextFile=<D:\ORACLE\CER\SAPDATA1\SYSTEM_1\SYSTEM.DATA1> BR0280I BRRESTORE time stamp: 2011-12-14 10.11.16 #FILE..... D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 #RESTORED. 1021752_13310 Sending file=<#EOF> to the Child=<4536> Successful restore; 2 File(s); total transferred bytes=471875934 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-14 10.11.26 BR0374I 5 of 5 files restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehkytik.rsb 2011-12-14 10.11.26 BR0280I BRRESTORE time stamp: 2011-12-14 10.11.26 BR0403I BRRESTORE completed successfully with warnings ========================================= BR0292I Execution of BRRESTORE finished with return code 1 BR0280I BRRECOVER time stamp: 2011-12-14 10.11.26 BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action BR0126I Unattended mode active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-14 10.11.26 BR0655I Control menu 103 # please decide how to proceed ------------------------------------------------------------------------------- Database point-in-time recovery main menu 1 + Set point-in-time for recovery 2 + Select database backup or flashback 3 + Check the status of database files 4 + Restore control files 5 + Restore data files 6 # Restore split incremental control files 7 # Restore and apply incremental backup 8 = Restore and apply archivelog files 9 # Restore archivelog files and flashback 10 Open database and post-processing 11 * Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.11.26 BR0134I Unattended mode with 'force' active - continuing processing with default reply '8' BR0614I Database instance TRD is mounted BR0280I BRRECOVER time stamp: 2011-12-14 10.11.28 BR0370I Directory D:\oracle\TRD\sapbackup\vehkytgp created BR0280I BRRECOVER time stamp: 2011-12-14 10.11.28 BR1402I Dummy online redolog file 'D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo' created BR1403I Dummy online redolog file 'D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo' dropped BR0351I Restoring D:\ORACLE\TRD\ORIGLOGA\LOG1_M1.DBF BR0355I from D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo ... BR0351I Restoring D:\ORACLE\TRD\MIRRLOGA\LOG1_M2.DBF BR0355I from D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo ... BR0351I Restoring D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF BR0355I from D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo ... BR0351I Restoring D:\ORACLE\TRD\MIRRLOGB\LOG2_M2.DBF BR0355I from D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo ... BR0351I Restoring D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF BR0355I from D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo ... BR0351I Restoring D:\ORACLE\TRD\MIRRLOGA\LOG3_M2.DBF BR0355I from D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo ... BR0351I Restoring D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF BR0355I from D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo ... BR0351I Restoring D:\ORACLE\TRD\MIRRLOGB\LOG4_M2.DBF BR0355I from D:\oracle\TRD\sapbackup\vehkytgp\dummy.redo ... BR0280I BRRECOVER time stamp: 2011-12-14 10.11.29 BR1096I Database file 'D:\ORACLE\CER\SAPDATA2\CER_1\CER.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1' BR1096I Database file 'D:\ORACLE\CER\SAPDATA3\CERUSR_1\CERUSR.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1' BR0793I Temporary database file D:\ORACLE\CER\SAPDATA1\TEMP_1\TEMP.DATA1 has been dropped BR1096I Database file 'D:\ORACLE\CER\SAPDATA1\UNDO_1\UNDO.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1' BR1096I Database file 'D:\ORACLE\CER\SAPDATA1\SYSTEM_1\SYSAUX.DBF' renamed successfully to 'D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF' BR1096I Database file 'D:\ORACLE\CER\SAPDATA1\SYSTEM_1\SYSTEM.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1' BR1096I Database file 'D:\ORACLE\CER\ORIGLOGA\LOG1_M1.DBF' renamed successfully to 'D:\ORACLE\TRD\ORIGLOGA\LOG1_M1.DBF' BR1096I Database file 'D:\ORACLE\CER\MIRRLOGA\LOG1_M2.DBF' renamed successfully to 'D:\ORACLE\TRD\MIRRLOGA\LOG1_M2.DBF' BR1096I Database file 'D:\ORACLE\CER\ORIGLOGB\LOG2_M1.DBF' renamed successfully to 'D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF' BR1096I Database file 'D:\ORACLE\CER\MIRRLOGB\LOG2_M2.DBF' renamed successfully to 'D:\ORACLE\TRD\MIRRLOGB\LOG2_M2.DBF' BR1096I Database file 'D:\ORACLE\CER\ORIGLOGA\LOG3_M1.DBF' renamed successfully to 'D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF' BR1096I Database file 'D:\ORACLE\CER\MIRRLOGA\LOG3_M2.DBF' renamed successfully to 'D:\ORACLE\TRD\MIRRLOGA\LOG3_M2.DBF' BR1096I Database file 'D:\ORACLE\CER\ORIGLOGB\LOG4_M1.DBF' renamed successfully to 'D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF' BR1096I Database file 'D:\ORACLE\CER\MIRRLOGB\LOG4_M2.DBF' renamed successfully to 'D:\ORACLE\TRD\MIRRLOGB\LOG4_M2.DBF' BR0614I Database instance TRD is mounted BR0750I Database instance TRD will be remounted now in mode 'IMMEDIATE' BR0280I BRRECOVER time stamp: 2011-12-14 10.11.32 BR0307I Shutting down database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-14 10.11.36 BR0308I Shutdown of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-14 10.11.36 BR0330I Starting and mounting database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-14 10.11.44 BR0331I Start and mount of database instance TRD successful BR0776I First redolog file sequence to apply for database instance TRD: 74 BR0699I Reading log file D:\oracle\TRD\saparch\archTRD.log for device type 'disk'... BR0699I Reading log file D:\oracle\TRD\saparch\archTRD.log for device type 'tape/backint/rman'... BR0699I Reading log file D:\oracle\TRD\saparch\archTRD.log for device type 'stage'... BR0280I BRRECOVER time stamp: 2011-12-14 10.11.47 BR0660I List display 113 # no selection possible ------------------------------------------------------------------------------- Archivelog files to apply of database instance TRD Pos. Sequence Status Apply From Disk Tape Util Rman Stage 1 - 74 redo_back yes util .... .... yes .... .... 2 - 75 in_back yes util .... .... yes .... .... Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.11.47 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-14 10.11.47 BR0657I Input menu 117 # please enter/check input values ------------------------------------------------------------------------------- Applying archivelog files of database instance TRD 1 - First sequence number (first_seq) .. [74] 2 - Last sequence number (last_seq) .... [75] 3 - Use backup control file (back_ctl) . [yes] 4 ~ Parallel recovery (degree) ......... [] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.11.47 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-14 10.11.48 BR0657I Input menu 115 # please enter/check input values ------------------------------------------------------------------------------- BRRESTORE main options for restore of archivelog files 1 - BRRESTORE main profile (profile) ..... [initTRD.sap] 2 # Profile for cpio (prof_cpio) ......... [initTRD.sap] 3 # Profile for dd (prof_dd) ............. [] 4 # Profile for rman (prof_rman) ......... [] 5 # Profile for rman_dd (prof_rman_dd) ... [] 6 # Profile for rman_set (prof_rman_set) . [] 7 # Profile for brtools (prof_brtools) ... [] 8 ~ BACKINT/Mount profile (parfile) ...... [D:\param.txt] 9 # Database user/password (user) ........ [system/******] 10 - Destination directory (dest_dir) ..... [D:\oracle\TRD\saparch] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.11.48 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-14 10.11.48 BR0657I Input menu 116 # please enter/check input values ------------------------------------------------------------------------------- Additional BRRESTORE options for restore of archivelog files 1 - Confirmation mode (confirm) . [force] 2 - Additional output (output) .. [no] 3 - Message language (language) . [E] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.11.48 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0291I BRRESTORE will be started with options '-p initTRD.sap -a 74-75=D:\oracle\TRD\saparch -d util_file -r D:\param.txt -k no -c force -l E' =============================================== BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehkytuy.rsa 2011-12-14 10.11.48 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehkytuy.rsa BR0414I Offline redolog files for restore of database instance TRD: D:\oracle\TRD\saparch: 74,75 BR0280I BRRESTORE time stamp: 2011-12-14 10.11.49 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehkytuy BR0409I BRRESTORE function ID: rsa BR0419I Files will be restored from backup: aehkctzc.sve 2011-12-09 22.49.04 BR0416I 2 files found to restore, total size 2.202 MB BR0421I Restore device type: util_file BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRESTORE time stamp: 2011-12-14 10.11.49 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehkytuy.lst -t file -p D:\param.txt -c': -------------------------- 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\.rehkytuy.lst -t file -p D:\param.txt -c ] 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=<2> Setting the Number of streams desired=<2> to the total number of collect files generated. Number of streams desired=<2> Number of files to restore=<2> CMDLINE Job Restore has been requested SID=[CER] BkpSet=[default] AppType=[61] Success in getting Job id=14442 Token=<14442:2:1> Success in init with JM 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_9091> Restoring from MediaId=<23_MagVolId_9090> RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00074_0769082544.001> BR0280I BRRESTORE time stamp: 2011-12-14 10.12.08 #ARCHIVE.. D:\oracle\cer\saparch\ARC00074_0769082544.001 D:\oracle\TRD\saparch\ARC00074_0769082544.001 #RESTORED. 1021752_13310 Sending file=<#EOF> to the Child=<1788> Successful restore; 1 File(s); total transferred bytes=2302131 RESTORED backupId=<1021752_13310> nextFile=<D:\oracle\cer\saparch\ARC00075_0769082544.001> BR0280I BRRESTORE time stamp: 2011-12-14 10.12.16 #ARCHIVE.. D:\oracle\cer\saparch\ARC00075_0769082544.001 D:\oracle\TRD\saparch\ARC00075_0769082544.001 #RESTORED. 1021752_13310 Sending file=<#EOF> to the Child=<4248> Successful restore; 1 File(s); total transferred bytes=7347 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-14 10.12.26 BR0374I 2 of 2 files restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehkytuy.rsa 2011-12-14 10.12.26 BR0280I BRRESTORE time stamp: 2011-12-14 10.12.26 BR0402I BRRESTORE completed successfully =========================================== BR0292I Execution of BRRESTORE finished with return code 0 BR0783I Archivelog files with sequence number 74-75 of database instance TRD will be applied now BR0280I BRRECOVER time stamp: 2011-12-14 10.12.27 BR0336I Applying offline redolog file D:\oracle\TRD\saparch\ARC00074_0769082544.001 ... BR0336I Applying offline redolog file D:\oracle\TRD\saparch\ARC00075_0769082544.001 ... BR0280I BRRECOVER time stamp: 2011-12-14 10.12.37 BR0337I Offline redolog file D:\oracle\TRD\saparch\ARC00074_0769082544.001 applied successfully BR0280I BRRECOVER time stamp: 2011-12-14 10.12.37 BR0337I Offline redolog file D:\oracle\TRD\saparch\ARC00075_0769082544.001 applied successfully BR0800I Restored archivelog file can be deleted now - not deleting them can lead to space shortage in archive directory BR0280I BRRECOVER time stamp: 2011-12-14 10.12.38 BR0675I This is a recommended action - do you want to execute it now? BR0126I Unattended mode active - continuing processing with default reply 'yes' BR0280I BRRECOVER time stamp: 2011-12-14 10.12.38 BR0015I Offline redolog file D:\oracle\TRD\saparch\ARC00075_0769082544.001 deleted BR0800I Restored archivelog file can be deleted now - not deleting them can lead to space shortage in archive directory BR0280I BRRECOVER time stamp: 2011-12-14 10.12.38 BR0675I This is a recommended action - do you want to execute it now? BR0126I Unattended mode active - continuing processing with default reply 'yes' BR0280I BRRECOVER time stamp: 2011-12-14 10.12.38 BR0784I Media recovery completed BR0280I BRRECOVER time stamp: 2011-12-14 10.12.38 BR0655I Control menu 103 # please decide how to proceed ------------------------------------------------------------------------------- Database point-in-time recovery main menu 1 + Set point-in-time for recovery 2 + Select database backup or flashback 3 + Check the status of database files 4 + Restore control files 5 + Restore data files 6 # Restore split incremental control files 7 # Restore and apply incremental backup 8 + Restore and apply archivelog files 9 # Restore archivelog files and flashback 10 = Open database and post-processing 11 Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.12.38 BR0134I Unattended mode with 'force' active - continuing processing with default reply '10' BR0614I Database instance TRD is mounted BR0064I Database instance TRD will be shut down now in mode 'IMMEDIATE' BR0280I BRRECOVER time stamp: 2011-12-14 10.12.40 BR0307I Shutting down database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-14 10.12.45 BR0308I Shutdown of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-14 10.12.45 BR0657I Input menu 135 # please enter/check input values ------------------------------------------------------------------------------- Options for opening database instance TRD 1 ~ Reset logs option (reset_logs) .. [resetlogs] 2 * Open database command (command) . [alter database open resetlogs] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.12.45 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0786I Database instance TRD will be opened now in mode 'resetlogs' BR0787W No more archivelog files can be applied after database has been opened BR0280I BRRECOVER time stamp: 2011-12-14 10.12.45 BR0675I This is a recommended action - do you want to execute it now? BR0126I Unattended mode active - continuing processing with default reply 'yes' BR0280I BRRECOVER time stamp: 2011-12-14 10.12.45 BR0304I Starting and opening database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-14 10.13.01 BR0305I Start and open of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-14 10.13.03 BR0789I Temporary database file D:\ORACLE\TRD\SAPDATA1\TEMP_1\TEMP.DATA1 has been recreated BR0118I Tablespaces and data files Tablespace Status File Status Id. Size Creation time Creation scn Device Type Link PSAPCER ONLINE D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1 ONLINE 4 52428800 2011-12-05 10.33.15 176706 3 FILE NOLINK PSAPCERUSR ONLINE D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1 ONLINE 5 10485760 2011-12-05 10.33.15 176736 3 FILE NOLINK PSAPTEMP ONLINE# D:\ORACLE\TRD\SAPDATA1\TEMP_1\TEMP.DATA1 ONLINE -1 104865792 2011-12-14 10.13.03 397522 3 FILE NOLINK PSAPUNDO ONLINE D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1 ONLINE 2 104857600 2011-12-05 10.02.42 8337 3 FILE NOLINK SYSAUX ONLINE D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF ONLINE 3 104857600 2011-12-05 10.02.45 8460 3 FILE NOLINK SYSTEM ONLINE D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 SYSTEM 1 419430400 2011-12-05 10.02.36 7 3 FILE NOLINK BR0119I Redolog files File Status Group Thread Sequence Size First time First scn Device Type Link D:\ORACLE\TRD\ORIGLOGA\LOG1_M1.DBF INUSE 1 1 1 10485760 2011-12-14 10.12.52 397432 3 FILE NOLINK D:\ORACLE\TRD\MIRRLOGA\LOG1_M2.DBF INUSE 1 1 1 10485760 2011-12-14 10.12.52 397432 3 FILE NOLINK D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF INUSE 2 1 0 10485760 0000-00-00 00.00.00 0 3 FILE NOLINK D:\ORACLE\TRD\MIRRLOGB\LOG2_M2.DBF INUSE 2 1 0 10485760 0000-00-00 00.00.00 0 3 FILE NOLINK D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF INUSE 3 1 0 10485760 0000-00-00 00.00.00 0 3 FILE NOLINK D:\ORACLE\TRD\MIRRLOGA\LOG3_M2.DBF INUSE 3 1 0 10485760 0000-00-00 00.00.00 0 3 FILE NOLINK D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF INUSE 4 1 0 10485760 0000-00-00 00.00.00 0 3 FILE NOLINK D:\ORACLE\TRD\MIRRLOGB\LOG4_M2.DBF INUSE 4 1 0 10485760 0000-00-00 00.00.00 0 3 FILE NOLINK BR0120I Control files File Size Reset time Reset scn Device Type Link D:\ORACLE\TRD\SAPDATA1\CNTRL\CTRLCER.CTL 11288576 2011-12-14 10.12.52 397432 3 FILE NOLINK D:\ORACLE\TRD\SAPDATA2\CNTRL\CTRLCER.CTL 11288576 2011-12-14 10.12.52 397432 3 FILE NOLINK D:\ORACLE\TRD\SAPARCH\CNTRL\CTRLCER.CTL 11288576 2011-12-14 10.12.52 397432 3 FILE NOLINK BR0280I BRRECOVER time stamp: 2011-12-14 10.13.04 BR0319I Control file copy created: D:\oracle\TRD\sapbackup\vehkytgp\CNTRLTRD.NEW 11288576 BR0280I BRRECOVER time stamp: 2011-12-14 10.13.04 BR0595I Selecting indexes/partitions with NOLOGGING created during or after the selected backup behkctrv.anf 2011-12-09 22.45.55 ... BR0285I This function can take several seconds/minutes - be patient... BR0280I BRRECOVER time stamp: 2011-12-14 10.13.05 BR0596I No indexes found with NOLOGGING created during or after the selected backup behkctrv.anf 2011-12-09 22.45.55 BR0280I BRRECOVER time stamp: 2011-12-14 10.13.05 BR1959I No index partitions found with NOLOGGING created during or after the selected backup behkctrv.anf 2011-12-09 22.45.55 BR1404I New control files can be created now BR0280I BRRECOVER time stamp: 2011-12-14 10.13.05 BR0675I This is a recommended action - do you want to execute it now? BR0126I Unattended mode active - continuing processing with default reply 'yes' BR1404I New control files will be created now using SQL script D:\oracle\TRD\sapbackup\vehkytgp\control.sql BR0064I Database instance TRD will be shut down now BR0280I BRRECOVER time stamp: 2011-12-14 10.13.05 BR0307I Shutting down database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-14 10.13.23 BR0308I Shutdown of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-14 10.13.23 BR1273I SQLPLUS will be started for execution of SQL script D:\oracle\TRD\sapbackup\vehkytgp\control.sql BR0280I BRRECOVER time stamp: 2011-12-14 10.13.23 BR0278I Command output of 'D:\oracle\product\10.2.0\db_1\BIN\sqlplus /nolog < D:\oracle\TRD\sapbackup\.vehkytgp.spi': SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 14 10:13:23 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. SQL> SQL> Connected to an idle instance. SQL> SQL> 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 System altered. File created. ORA-01507: database not mounted ORACLE instance shut down. 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 Control file created. Database altered. Tablespace altered. SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options BR0280I BRRECOVER time stamp: 2011-12-14 10.13.40 BR1274I Execution of SQL script D:\oracle\TRD\sapbackup\vehkytgp\control.sql completed BR1275I SQLPLUS executed SQL script D:\oracle\TRD\sapbackup\vehkytgp\control.sql successfully BR1405I New control files created successfully BR0280I BRRECOVER time stamp: 2011-12-14 10.13.40 BR0716I Database point-in-time recovery completed BR0280I BRRECOVER time stamp: 2011-12-14 10.13.40 BR0655I Control menu 103 # please decide how to proceed ------------------------------------------------------------------------------- Database point-in-time recovery main menu 1 + Set point-in-time for recovery 2 + Select database backup or flashback 3 + Check the status of database files 4 + Restore control files 5 + Restore data files 6 # Restore split incremental control files 7 # Restore and apply incremental backup 8 + Restore and apply archivelog files 9 # Restore archivelog files and flashback 10 + Open database and post-processing 11 = Exit program 12 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-14 10.13.40 BR0134I Unattended mode with 'force' active - continuing processing with default reply '11' BR0797I Number of restored/recovered database files: 6/5 BR0798I Number of restored/applied incremental files: 0/0 BR0799I Number of restored/applied archivelog files: 2/2 BR0706I End of database recovery: vehkytgp.dpt 2011-12-14 10.13.40 BR0280I BRRECOVER time stamp: 2011-12-14 10.13.42 BR0703I BRRECOVER completed successfully with warnings
For Offline backup, copy the corresponding ".aff" file from source computer sapbackup directory or restore it using BRRECOVER	brrecover -f TRD -t reset -c force -r D:\param.txt BR0701I BRRECOVER 7.20 (1) BR0705I Start of database recovery: vehlbzto.drs 2011-12-15 01.57.36 BR0484I BRRECOVER log file: D:\oracle\TRD\sapbackup\vehlbzto.drs BR0101I Parameters Name Value oracle_sid TRD oracle_home D:\oracle\product\10.2.0\db_1 oracle_profile D:\oracle\product\10.2.0\db_1\database\initTRD.ora sapdata_home D:\oracle\TRD sap_profile D:\oracle\product\10.2.0\db_1\database\initTRD.sap recov_type reset recov_copy_dir D:\oracle\TRD\sapbackup recov_interval 30 scroll_lines 20 backup_dev_type tape system_info Administrator SDE-SAP1 Windows 6.1 Build 7601 Service Pack 1 AMD64 oracle_info TRD 10.2.0.4.0 make_info NTAMD64 OCI_10201_SHARE Feb 25 2010 command_line brrecover -f TRD -t reset -c force -r D:\param.txt BR0280I BRRECOVER time stamp: 2011-12-15 01.57.36 BR0707I Recovery of database: TRD BR0708I BRRECOVER action ID: vehlbzto BR0709I BRRECOVER function ID: drs BR0710I Recovery type: reset BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRECOVER time stamp: 2011-12-15 01.57.36 BR0655I Control menu 109 # please decide how to proceed ------------------------------------------------------------- Whole database reset main menu 1 = Select database backup or restore point 2 * Check the status of database files 3 * Restore control files and redolog files 4 * Restore data files 5 * Restore and apply incremental backup 6 * Apply archivelog files 7 * Restore archivelog files and flashback 8 * Open database and post-processing 9 * Exit program 10 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------ BR0280I BRRECOVER time stamp: 2011-12-15 01.57.36 BR0134I Unattended mode with 'force' active - continuing processing with default reply '1' BR0699I Reading log file D:\oracle\TRD\sapbackup\backTRD.log ... BR0350I Backup utility will be inquired for backup confirmation BR0280I BRRECOVER time stamp: 2011-12-15 01.57.36 BR0229I Calling backup utility with function 'inquire'... BR0278I Command output of 'backint -u TRD -f inquire -i D:\oracle\TRD\sapbackup\.vehlbzto.lst -t file -p D:\param.txt -c': -------------------------- Output of inquire ----------------------- BI_BACKUP=<PARTIAL> BI_CALLER=<BRRECOVER> BI_REQUEST=<NEW> -------------------------- Parameter Specified ---------------------- CvInstanceName=<Instance001> CvClientName=<sde-sap1> numstreams=<4> srccrossclient=<sde-sap2> srccrossdbname=<CER> destdbname=<TRD> -------------------------- backint Command Line ------------------------- backintCmd=[backint -u TRD -f inquire -i D:\oracle\TRD\sapbackup\.vehlbzto.lst -t file -p D:\param.txt -c ] CommServeHostName=satishp CommClientHostName=sde-sap1.idcprodcert.loc Galaxy CommCellID=2 Galaxy ClientID=219 Inquire has been requested 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 BR0280I BRRECOVER time stamp: 2011-12-15 01.57.38 BR1520I 6 file backups confirmed by backup utility BR0230I Backup utility called successfully BR0280I BRRECOVER time stamp: 2011-12-15 01.57.38 BR0658I List menu 110 # please select one entry ---------------------------------------------------------------------- Consistent database backups / restore points for whole database reset Pos. Log/RPoint Start time Type/SCN Mode Device Rc UVol1/Stat. 1 = behjkmqh.aff 2011-12-06 05.33.35 offl_force all util_file 0 <confirmed> Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 01.57.38 BR0134I Unattended mode with 'force' active - continuing processing with default reply '1' BR0699I Reading log file D:\oracle\TRD\sapbackup\behjkmqh.aff ... BR0454W Values of oracle_sid are different: current 'TRD', backup behjkmqh.aff 'CER' BR0455W Value 'TRD' of oracle_sid will be used for restore BR0454W Values of sapdata_home are different: current 'D:\oracle\TRD', backup behjkmqh.aff '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\behjkmqh.aff - log file incomplete (this is OK if the log file was restored) BR0280I BRRECOVER time stamp: 2011-12-15 01.57.38 BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action BR0126I Unattended mode active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-15 01.57.38 BR0655I Control menu 109 # please decide how to proceed --------------------------------------------------------------------------- Whole database reset main menu 1 + Select database backup or restore point 2 = Check the status of database files 3 * Restore control files and redolog files 4 * Restore data files 5 # Restore and apply incremental backup 6 # Apply archivelog files 7 # Restore archivelog files and flashback 8 * Open database and post-processing 9 * Exit program 10 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ---------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 01.57.38 BR0134I Unattended mode with 'force' active - continuing processing with default reply '2' BR0753W Control file 'D:\oracle\TRD\sapdata1\cntrl\ctrlCER.ctl' not found BR0753W Control file 'D:\oracle\TRD\sapdata2\cntrl\ctrlCER.ctl' not found BR0753W Control file 'D:\oracle\TRD\saparch\cntrl\ctrlCER.ctl' not found BR0613I Database instance TRD is shut down BR0751W Database instance TRD cannot be mounted due to missing control files BR0755I Checking the status of database files for instance TRD... BR0428W File D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1 will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1 will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA1\TEMP_1\TEMP.DATA1 will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1 will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 will be overwritten BR0280I BRRECOVER time stamp: 2011-12-15 01.57.39 BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action BR0126I Unattended mode active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-15 01.57.39 BR0655I Control menu 109 # please decide how to proceed ------------------------------------------------------------------------------- Whole database reset main menu 1 + Select database backup or restore point 2 + Check the status of database files 3 = Restore control files and redolog files 4 * Restore data files 5 # Restore and apply incremental backup 6 # Apply archivelog files 7 # Restore archivelog files and flashback 8 * Open database and post-processing 9 * Exit program 10 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 01.57.39 BR0134I Unattended mode with 'force' active - continuing processing with default reply '3' BR0613I Database instance TRD is shut down BR0280I BRRECOVER time stamp: 2011-12-15 01.57.40 BR0657I Input menu 111 # please enter/check input values ------------------------------------------------------------------------------- BRRESTORE main options for restore of database files 1 - BRRESTORE profile (profile) ........ [initTRD.sap] 2 - BRBACKUP backup run (backup) ....... [behjkmqh.aff] 3 - Fill-up previous restores (fillup) . [no] 4 - Restore device type (device) ....... [util_file] 5 - BACKINT/Mount profile (parfile) .... [D:\param.txt] 6 # Database user/password (user) ...... [system/******] 7 - Files for restore (mode) ........... [0,00] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 01.57.40 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-15 01.57.40 BR0657I Input menu 112 # please enter/check input values ------------------------------------------------------------------------------- Additional BRRESTORE options for restore of database files 1 - Confirmation mode (confirm) ...... [force] 2 - Query mode (query) ............... [no] 3 # Compression mode (compress) ...... [no] 4 # Parallel execution (execute) ..... [0] 5 - Additional output (output) ....... [no] 6 - Message language (language) ...... [E] 7 - BRRESTORE command line (command) . [-p initTRD.sap -b behjkmqh.aff -d util_file -r D:\param.txt -m 0,00 -c force -l E] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 01.57.40 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0291I BRRESTORE will be started with options '-p initTRD.sap -b behjkmqh.aff -d util_file -r D:\param.txt -m 0,00 -c force -l E' ==================================================== BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehlbzts.rsb 2011-12-15 01.57.40 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehlbzts.rsb BR0454W Values of oracle_sid are different: current 'TRD', backup behjkmqh.aff 'CER' BR0455W Value 'TRD' of oracle_sid will be used for restore BR0454W Values of sapdata_home are different: current 'D:\oracle\TRD', backup behjkmqh.aff '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\behjkmqh.aff - log file incomplete (this is OK if the log file was restored) 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 01.57.40 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehlbzts BR0409I BRRESTORE function ID: rsb BR0449I Restore mode: partial BR0411I Database files for restore: D:\ORACLE\CER\ORIGLOGA\LOG1_M1.DBF D:\ORACLE\CER\MIRRLOGA\LOG1_M2.DBF D:\ORACLE\CER\ORIGLOGB\LOG2_M1.DBF D:\ORACLE\CER\MIRRLOGB\LOG2_M2.DBF D:\ORACLE\CER\ORIGLOGA\LOG3_M1.DBF D:\ORACLE\CER\MIRRLOGA\LOG3_M2.DBF D:\ORACLE\CER\ORIGLOGB\LOG4_M1.DBF D:\ORACLE\CER\MIRRLOGB\LOG4_M2.DBF 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: behjkmqh.aff 2011-12-06 05.33.35 BR0416I 5 files found to restore, total size 50.768 MB BR0421I Restore device type: util_file BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRESTORE time stamp: 2011-12-15 01.57.40 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehlbzts.lst -t file -p D:\param.txt -c': -------------------------- Output of restore ------------------------- BI_BACKUP=<PARTIAL> 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\.rehlbzts.lst -t file -p D:\param.txt -c ] 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 Total number of Collect Files Generated=<2> Setting the Number of streams desired=<2> to the total number of collect files generated. Number of streams desired=<2> Number of files to restore=<2> CMDLINE Job Restore has been requested SID=[CER] BkpSet=[default] AppType=[61] Success in getting Job id=14518 Token=<14518:2:1> Success in init with JM 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=2283 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=2283 Restore has been requested Success in init with JM Attaching CommServer Session Restoring from MediaId=<22_MagVolId_9030> Restoring from MediaId=<22_MagVolId_9032> RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\ORIGLOGB\LOG4_M1.DBF> BR0280I BRRESTORE time stamp: 2011-12-15 01.57.56 #FILE..... D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF #RESTORED. 1021752_12884 Sending file=<#EOF> to the Child=<4316> Successful restore; 1 File(s); total transferred bytes=10486440 RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\ORIGLOGA\LOG1_M1.DBF> BR0280I BRRESTORE time stamp: 2011-12-15 01.58.06 #FILE..... D:\ORACLE\TRD\ORIGLOGA\LOG1_M1.DBF #RESTORED. 1021752_12884 RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\ORIGLOGB\LOG2_M1.DBF> BR0280I BRRESTORE time stamp: 2011-12-15 01.58.10 #FILE..... D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF #RESTORED. 1021752_12884 RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\ORIGLOGA\LOG3_M1.DBF> BR0280I BRRESTORE time stamp: 2011-12-15 01.58.15 #FILE..... D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF #RESTORED. 1021752_12884 RESTORED backupId=<1021752_12884> nextFile=<D:\oracle\CER\sapdata1\cntrl\ctrlCER.ctl> BR0280I BRRESTORE time stamp: 2011-12-15 01.58.20 #FILE..... D:\ORACLE\TRD\SAPDATA1\CNTRL\ctrlCER.ctl #RESTORED. 1021752_12884 Sending file=<#EOF> to the Child=<2336> Successful restore; 4 File(s); total transferred bytes=42748070 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-15 01.58.30 BR0374I 5 of 5 files restored by backup utility BR0230I Backup utility called successfully BR0351I Restoring D:\ORACLE\TRD\MIRRLOGA\LOG1_M2.DBF BR0355I from D:\ORACLE\TRD\ORIGLOGA\LOG1_M1.DBF ... BR0351I Restoring D:\ORACLE\TRD\MIRRLOGB\LOG2_M2.DBF BR0355I from D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF ... BR0351I Restoring D:\ORACLE\TRD\MIRRLOGA\LOG3_M2.DBF BR0355I from D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF ... BR0351I Restoring D:\ORACLE\TRD\MIRRLOGB\LOG4_M2.DBF BR0355I from D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF ... BR0351I Restoring D:\ORACLE\TRD\SAPDATA2\CNTRL\ctrlCER.ctl BR0355I from D:\ORACLE\TRD\SAPDATA1\CNTRL\ctrlCER.ctl ... BR0351I Restoring D:\ORACLE\TRD\SAPARCH\CNTRL\ctrlCER.ctl BR0355I from D:\ORACLE\TRD\SAPDATA1\CNTRL\ctrlCER.ctl ... BR0406I End of file restore: rehlbzts.rsb 2011-12-15 01.58.30 BR0280I BRRESTORE time stamp: 2011-12-15 01.58.30 BR0403I BRRESTORE completed successfully with warnings =================================================== BR0292I Execution of BRRESTORE finished with return code 1 BR0280I BRRECOVER time stamp: 2011-12-15 01.58.30 BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action BR0126I Unattended mode active - continuing processing with default reply 'cont' BR0613I Database instance TRD is shut down BR0618I Database instance TRD will be started now BR0280I BRRECOVER time stamp: 2011-12-15 01.58.31 BR0619I Starting database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-15 01.58.34 BR0620I Start of database instance TRD successful BR1031I Database parameter db_name altered successfully from 'TRD' to 'CER' BR0280I BRRECOVER time stamp: 2011-12-15 01.58.34 BR0655I Control menu 109 # please decide how to proceed ------------------------------------------------------------------------ Whole database reset main menu 1 + Select database backup or restore point 2 + Check the status of database files 3 + Restore control files and redolog files 4 = Restore data files 5 # Restore and apply incremental backup 6 # Apply archivelog files 7 # Restore archivelog files and flashback 8 Open database and post-processing 9 * Exit program 10 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------ BR0280I BRRECOVER time stamp: 2011-12-15 01.58.35 BR0134I Unattended mode with 'force' active - continuing processing with default reply '4' BR0617I Database instance TRD is started BR0750I Database instance TRD will be mounted now BR0280I BRRECOVER time stamp: 2011-12-15 01.58.36 BR0307I Shutting down database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-15 01.58.41 BR0308I Shutdown of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-15 01.58.41 BR0330I Starting and mounting database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-15 01.58.48 BR0331I Start and mount of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-15 01.58.48 BR0657I Input menu 111 # please enter/check input values -------------------------------------------------------------------------- BRRESTORE main options for restore of database files 1 - BRRESTORE profile (profile) ........ [initTRD.sap] 2 - BRBACKUP backup run (backup) ....... [behjkmqh.aff] 3 - Fill-up previous restores (fillup) . [no] 4 - Restore device type (device) ....... [util_file] 5 - BACKINT/Mount profile (parfile) .... [D:\param.txt] 6 # Database user/password (user) ...... [system/******] 7 - Files for restore (mode) ........... [all] Standard keys: c - cont, b - back, s - stop, r - refr, h - help --------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 01.58.48 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0280I BRRECOVER time stamp: 2011-12-15 01.58.48 BR0657I Input menu 112 # please enter/check input values ---------------------------------------------------------------------------- Additional BRRESTORE options for restore of database files 1 - Confirmation mode (confirm) ...... [force] 2 - Query mode (query) ............... [no] 3 # Compression mode (compress) ...... [no] 4 # Parallel execution (execute) ..... [0] 5 - Additional output (output) ....... [no] 6 - Message language (language) ...... [E] 7 - BRRESTORE command line (command) . [-p initTRD.sap -b behjkmqh.aff -d util_file -r D:\param.txt -m all -c force -l E] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 01.58.48 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0291I BRRESTORE will be started with options '-p initTRD.sap -b behjkmqh.aff -d util_file -r D:\param.txt -m all -c force -l E' ================================================== BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehlbzwi.rsb 2011-12-15 01.58.48 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehlbzwi.rsb BR0454W Values of oracle_sid are different: current 'TRD', backup behjkmqh.aff 'CER' BR0455W Value 'TRD' of oracle_sid will be used for restore BR0454W Values of sapdata_home are different: current 'D:\oracle\TRD', backup behjkmqh.aff '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\behjkmqh.aff - log file incomplete (this is OK if the log file was restored) BR0427I Files from the old sapdata_home D:\oracle\CER will be restored into the new sapdata_home D:\oracle\TRD BR0428W File D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1 will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1 will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA1\TEMP_1\TEMP.DATA1 will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1 will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF will be overwritten BR0428W File D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 will be overwritten BR0280I BRRESTORE time stamp: 2011-12-15 01.58.48 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehlbzwi BR0409I BRRESTORE function ID: rsb BR0449I Restore mode: ALL BR0419I Files will be restored from backup: behjkmqh.aff 2011-12-06 05.33.35 BR0416I 6 files found to restore, total size 760.047 MB BR0421I Restore device type: util_file BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRESTORE time stamp: 2011-12-15 01.58.48 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u CER -f restore -i D:\oracle\TRD\sapbackup\.rehlbzwi.lst -t file -p D:\param.txt -c': -------------------------- Output of restore ------------------------- BI_BACKUP=<FULL> 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\.rehlbzwi.lst -t file -p D:\param.txt -c ] 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 Total number of Collect Files Generated=<3> Setting the Number of streams desired=<3> to the total number of collect files generated. Number of streams desired=<3> Number of files to restore=<3> CMDLINE Job Restore has been requested SID=[CER] BkpSet=[default] AppType=[61] Success in getting Job id=14519 Token=<14519: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 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 Restore has been requested Success in init with JM 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 Attaching CommServer Session Galaxy CrossClientInstanceID=559 Galaxy CrossClientAppType=61 Galaxy CrossClientAppID=2283 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=2283 Restore has been requested Success in init with JM Attaching CommServer Session Restoring from MediaId=<22_MagVolId_9030> Restoring from MediaId=<22_MagVolId_9032> Restoring from MediaId=<22_MagVolId_9031> RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\SAPDATA2\CER_1\CER.DATA1> BR0280I BRRESTORE time stamp: 2011-12-15 01.59.14 #FILE..... D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1 #RESTORED. 1021752_12884 RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\SAPDATA3\CERUSR_1\CERUSR.DATA1> BR0280I BRRESTORE time stamp: 2011-12-15 01.59.16 #FILE..... D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1 #RESTORED. 1021752_12884 RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\SAPDATA1\TEMP_1\TEMP.DATA1> BR0280I BRRESTORE time stamp: 2011-12-15 01.59.21 #FILE..... D:\ORACLE\TRD\SAPDATA1\TEMP_1\TEMP.DATA1 #RESTORED. 1021752_12884 RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\SAPDATA1\SYSTEM_1\SYSAUX.DBF> BR0280I BRRESTORE time stamp: 2011-12-15 01.59.40 #FILE..... D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF #RESTORED. 1021752_12884 Sending file=<#EOF> to the Child=<5056> Successful restore; 2 File(s); total transferred bytes=157303132 RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\SAPDATA1\UNDO_1\UNDO.DATA1> BR0280I BRRESTORE time stamp: 2011-12-15 01.59.43 #FILE..... D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1 #RESTORED. 1021752_12884 Sending file=<#EOF> to the Child=<1796> Successful restore; 2 File(s); total transferred bytes=115360096 RESTORED backupId=<1021752_12884> nextFile=<D:\ORACLE\CER\SAPDATA1\SYSTEM_1\SYSTEM.DATA1> BR0280I BRRESTORE time stamp: 2011-12-15 02.00.14 #FILE..... D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 #RESTORED. 1021752_12884 Sending file=<#EOF> to the Child=<4596> Successful restore; 2 File(s); total transferred bytes=524304736 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-15 02.00.24 BR0374I 6 of 6 files restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehlbzwi.rsb 2011-12-15 02.00.24 BR0280I BRRESTORE time stamp: 2011-12-15 02.00.24 BR0403I BRRESTORE completed successfully with warnings ==================================================== BR0292I Execution of BRRESTORE finished with return code 1 BR0280I BRRECOVER time stamp: 2011-12-15 02.00.24 BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action BR0126I Unattended mode active - continuing processing with default reply 'cont' BR0614I Database instance TRD is mounted BR0280I BRRECOVER time stamp: 2011-12-15 02.00.26 BR1096I Database file 'D:\ORACLE\CER\SAPDATA2\CER_1\CER.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1' BR1096I Database file 'D:\ORACLE\CER\SAPDATA3\CERUSR_1\CERUSR.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1' BR1096I Database file 'D:\ORACLE\CER\SAPDATA1\TEMP_1\TEMP.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA1\TEMP_1\TEMP.DATA1' BR1096I Database file 'D:\ORACLE\CER\SAPDATA1\UNDO_1\UNDO.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1' BR1096I Database file 'D:\ORACLE\CER\SAPDATA1\SYSTEM_1\SYSAUX.DBF' renamed successfully to 'D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF' BR1096I Database file 'D:\ORACLE\CER\SAPDATA1\SYSTEM_1\SYSTEM.DATA1' renamed successfully to 'D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1' BR1096I Database file 'D:\ORACLE\CER\ORIGLOGA\LOG1_M1.DBF' renamed successfully to 'D:\ORACLE\TRD\ORIGLOGA\LOG1_M1.DBF' BR1096I Database file 'D:\ORACLE\CER\MIRRLOGA\LOG1_M2.DBF' renamed successfully to 'D:\ORACLE\TRD\MIRRLOGA\LOG1_M2.DBF' BR1096I Database file 'D:\ORACLE\CER\ORIGLOGB\LOG2_M1.DBF' renamed successfully to 'D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF' BR1096I Database file 'D:\ORACLE\CER\MIRRLOGB\LOG2_M2.DBF' renamed successfully to 'D:\ORACLE\TRD\MIRRLOGB\LOG2_M2.DBF' BR1096I Database file 'D:\ORACLE\CER\ORIGLOGA\LOG3_M1.DBF' renamed successfully to 'D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF' BR1096I Database file 'D:\ORACLE\CER\MIRRLOGA\LOG3_M2.DBF' renamed successfully to 'D:\ORACLE\TRD\MIRRLOGA\LOG3_M2.DBF' BR1096I Database file 'D:\ORACLE\CER\ORIGLOGB\LOG4_M1.DBF' renamed successfully to 'D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF' BR1096I Database file 'D:\ORACLE\CER\MIRRLOGB\LOG4_M2.DBF' renamed successfully to 'D:\ORACLE\TRD\MIRRLOGB\LOG4_M2.DBF' BR0280I BRRECOVER time stamp: 2011-12-15 02.00.28 BR0655I Control menu 109 # please decide how to proceed --------------------------------------------------------------------------- Whole database reset main menu 1 + Select database backup or restore point 2 + Check the status of database files 3 + Restore control files and redolog files 4 + Restore data files 5 # Restore and apply incremental backup 6 # Apply archivelog files 7 # Restore archivelog files and flashback 8 = Open database and post-processing 9 Exit program 10 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 02.00.28 BR0134I Unattended mode with 'force' active - continuing processing with default reply '8' BR0614I Database instance TRD is mounted BR0064I Database instance TRD will be shut down now in mode 'IMMEDIATE' BR0280I BRRECOVER time stamp: 2011-12-15 02.00.30 BR0307I Shutting down database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-15 02.00.37 BR0308I Shutdown of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-15 02.00.37 BR0657I Input menu 135 # please enter/check input values ------------------------------------------------------------------------------- Options for opening database instance TRD 1 ~ Reset logs option (reset_logs) .. [] 2 * Open database command (command) . [alter database open] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 02.00.37 BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont' BR0329I Database instance TRD will be opened now BR0787W No more archivelog files can be applied after database has been opened BR0280I BRRECOVER time stamp: 2011-12-15 02.00.37 BR0675I This is a recommended action - do you want to execute it now? BR0126I Unattended mode active - continuing processing with default reply 'yes' BR0280I BRRECOVER time stamp: 2011-12-15 02.00.37 BR0304I Starting and opening database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-15 02.00.49 BR0305I Start and open of database instance TRD successful BR0118I Tablespaces and data files Tablespace Status File Status PSAPCER ONLINE D:\ORACLE\TRD\SAPDATA2\CER_1\CER.DATA1 ONLINE PSAPCERUSR ONLINE D:\ORACLE\TRD\SAPDATA3\CERUSR_1\CERUSR.DATA1 ONLINE PSAPTEMP ONLINE# D:\ORACLE\TRD\SAPDATA1\TEMP_1\TEMP.DATA1 ONLINE PSAPUNDO ONLINE D:\ORACLE\TRD\SAPDATA1\UNDO_1\UNDO.DATA1 ONLINE SYSAUX ONLINE D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSAUX.DBF ONLINE SYSTEM ONLINE D:\ORACLE\TRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 SYSTEM Id. Size Creation time Creation scn Device Type Link 4 52428800 2011-12-05 10.33.15 176706 3 FILE NOLINK 5 10485760 2011-12-05 10.33.15 176736 3 FILE NOLINK -1 104857600 2011-12-05 10.02.46 9390 3 FILE NOLINK 2 104857600 2011-12-05 10.02.42 8337 3 FILE NOLINK 3 104857600 2011-12-05 10.02.45 8460 3 FILE NOLINK BR0119I Redolog files File Status Group Thread Sequence D:\ORACLE\TRD\ORIGLOGA\LOG1_M1.DBF STALE 1 1 49 D:\ORACLE\TRD\MIRRLOGA\LOG1_M2.DBF STALE 1 1 49 D:\ORACLE\TRD\ORIGLOGB\LOG2_M1.DBF INUSE 2 1 50 D:\ORACLE\TRD\MIRRLOGB\LOG2_M2.DBF INUSE 2 1 50 D:\ORACLE\TRD\ORIGLOGA\LOG3_M1.DBF INUSE 3 1 47 D:\ORACLE\TRD\MIRRLOGA\LOG3_M2.DBF INUSE 3 1 47 D:\ORACLE\TRD\ORIGLOGB\LOG4_M1.DBF INUSE 4 1 48 D:\ORACLE\TRD\MIRRLOGB\LOG4_M2.DBF INUSE 4 1 48 Size First time First scn Device Type Link 10485760 2011-12-05 22.00.10 216582 3 FILE NOLINK 10485760 2011-12-05 22.00.10 216582 3 FILE NOLINK 10485760 2011-12-06 03.55.50 244501 3 FILE NOLINK 10485760 2011-12-06 03.55.50 244501 3 FILE NOLINK 10485760 2011-12-05 17.13.06 207639 3 FILE NOLINK 10485760 2011-12-05 17.13.06 207639 3 FILE NOLINK 10485760 2011-12-05 17.16.11 207777 3 FILE NOLINK 10485760 2011-12-05 17.16.11 207777 3 FILE NOLINK BR0120I Control files File Size Reset time D:\ORACLE\TRD\SAPDATA1\CNTRL\CTRLCER.CTL 11288576 2011-12-05 10.02.24 D:\ORACLE\TRD\SAPDATA2\CNTRL\CTRLCER.CTL 11288576 2011-12-05 10.02.24 D:\ORACLE\TRD\SAPARCH\CNTRL\CTRLCER.CTL 11288576 2011-12-05 10.02.24 Reset scn Device Type Link 1 3 FILE NOLINK 1 3 FILE NOLINK 1 3 FILE NOLINK BR0280I BRRECOVER time stamp: 2011-12-15 02.00.51 BR0370I Directory D:\oracle\TRD\sapbackup\vehlbzto created BR0280I BRRECOVER time stamp: 2011-12-15 02.00.51 BR0319I Control file copy created: D:\oracle\TRD\sapbackup\vehlbzto\CNTRLTRD.NEW 11288576 BR1404I New control files can be created now BR0280I BRRECOVER time stamp: 2011-12-15 02.00.51 BR0675I This is a recommended action - do you want to execute it now? BR0126I Unattended mode active - continuing processing with default reply 'yes' BR1404I New control files will be created now using SQL script D:\oracle\TRD\sapbackup\vehlbzto\control.sql BR0064I Database instance TRD will be shut down now BR0280I BRRECOVER time stamp: 2011-12-15 02.00.51 BR0307I Shutting down database instance TRD ... BR0280I BRRECOVER time stamp: 2011-12-15 02.01.09 BR0308I Shutdown of database instance TRD successful BR0280I BRRECOVER time stamp: 2011-12-15 02.01.09 BR1273I SQLPLUS will be started for execution of SQL script D:\oracle\TRD\sapbackup\vehlbzto\control.sql BR0280I BRRECOVER time stamp: 2011-12-15 02.01.09 BR0278I Command output of 'D:\oracle\product\10.2.0\db_1\BIN\sqlplus /nolog < D:\oracle\TRD\sapbackup\.vehlbzto.spi': SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 15 02:01:09 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. SQL> SQL> Connected to an idle instance. SQL> SQL> 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 System altered. File created. ORA-01507: database not mounted ORACLE instance shut down. 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 Control file created. Database altered. Tablespace altered. SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options BR0280I BRRECOVER time stamp: 2011-12-15 02.01.28 BR1274I Execution of SQL script D:\oracle\TRD\sapbackup\vehlbzto\control.sql completed BR1275I SQLPLUS executed SQL script D:\oracle\TRD\sapbackup\vehlbzto\control.sql successfully BR1405I New control files created successfully BR0280I BRRECOVER time stamp: 2011-12-15 02.01.28 BR0720I Whole database reset completed BR0280I BRRECOVER time stamp: 2011-12-15 02.01.28 BR0655I Control menu 109 # please decide how to proceed ------------------------------------------------------------------------------- Whole database reset main menu 1 + Select database backup or restore point 2 + Check the status of database files 3 + Restore control files and redolog files 4 + Restore data files 5 # Restore and apply incremental backup 6 # Apply archivelog files 7 # Restore archivelog files and flashback 8 + Open database and post-processing 9 = Exit program 10 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0280I BRRECOVER time stamp: 2011-12-15 02.01.28 BR0134I Unattended mode with 'force' active - continuing processing with default reply '9' BR0797I Number of restored/recovered database files: 11/0 BR0798I Number of restored/applied incremental files: 0/0 BR0799I Number of restored/applied archivelog files: 0/0 BR0706I End of database recovery: vehlbzto.drs 2011-12-15 02.01.28 BR0280I BRRECOVER time stamp: 2011-12-15 02.01.30 BR0703I BRRECOVER completed successfully with warnings
You can also restore an Offline backup using BRRESTORE	D:\scripts>brrestore -d util_file -b2 \#NULL -m D:\oracle\CER\sapbackup\behjkmqh.aff==D:\oracle\TRD\sapbackup -r D:\param.txt BR0401I BRRESTORE 7.20 (1) BR0405I Start of file restore: rehlbzlt.rsf 2011-12-15 01.54.13 BR0484I BRRESTORE log file: D:\oracle\TRD\sapbackup\rehlbzlt.rsf BR0280I BRRESTORE time stamp: 2011-12-15 01.54.13 BR0407I Restore of database: TRD BR0408I BRRESTORE action ID: rehlbzlt BR0409I BRRESTORE function ID: rsf BR0415I File for restore using backup utility ID \#NULL: D:\oracle\CER\sapbackup\behjkmqh.aff=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-15 01.54.13 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE: c BR0280I BRRESTORE time stamp: 2011-12-15 01.54.16 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRRESTORE time stamp: 2011-12-15 01.54.16 BR0229I Calling backup utility with function 'restore'... BR0278I Command output of 'backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehlbzlt.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=<TRD> -------------------------- backint Command Line -------------------- backintCmd=[backint -u TRD -f restore -i D:\oracle\TRD\sapbackup\.rehlbzlt.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=14517 Token=<14517:2:1> Success in init with JM Cannot obtain the Index MediaAgent from the Archive Manager.. Attaching CommServer Session AfileNumber=19589, AcommCellId=2 AgroupNumber=22 archfilename=D:\oracle\CER\sapbackup\behjkmqh.aff copy=35 BID=12884 reqBID=12884 afileFlags=0d BR0280I BRRESTORE time stamp: 2011-12-15 01.54.40 #FILE..... D:\oracle\CER\sapbackup\behjkmqh.aff D:\oracle\TRD\sapbackup\behjkmqh.aff #RESTORED. 1021752_12884 Successful restore; 1 File(s); total transferred bytes=11991 Success in sending JMSUCCESS to server Success in sending JMSUCCESS to server BR0280I BRRESTORE time stamp: 2011-12-15 01.54.41 BR0374I 1 of 1 file restored by backup utility BR0230I Backup utility called successfully BR0406I End of file restore: rehlbzlt.rsf 2011-12-15 01.54.41 BR0280I BRRESTORE time stamp: 2011-12-15 01.54.41 BR0402I BRRESTORE completed successfully D:\scripts>

Restoring Entire Database

At times, if the database gets corrupted, you might need to restore the entire database and recover it back to the current state.

However, in order to recover a database, you will also need to restore the logs. Both the data and the logs can be restored using the SAP utility or RMAN utility depending on which utility was used for the backup. You can restore the database in-place or out-of-place with the same directory structure and SID name.

From the CommCell Browser, right-click the instance on the source client and select All Tasks | Browse Backup Data.
Click OK.
From the General tab, select the name of the client computer with the database you want to restore in the Destination Client from the list.
Choose the Number of streams to use for restore.
Select all of the the following options to restore and recover the database.
- Restore Data
- Restore Archive Logs
- Recover
Verify that the Status of the database is displayed as MOUNTED; if necessary click on the Refresh button to refresh the status.
Click Advanced.
From the Advanced Restore Options (Options) tab, select the following:
- Set the Reset Logs to Yes.
- Select Open DB.

Restoring Individual Data Files/Table Spaces

If required, you can also restore individual data files or table spaces that was lost or corrupted. However, note that, you can only use the browse and restore method to restore the individual files.

From the CommCell Browser, right-click the instance and click All Tasks | Browse Backup Data.
Click OK.
From the Browse window, select the instance node in the left pane and from the right pane, browse to and select the required data file or table space to be restored.
Click Recover All Selected.
Select the name of the client computer with the database you want to restore in the Destination Client from the list.
Choose the Number of streams to use for restore.
Select the following options to restore and recover individual data files/ table spaces:
- Restore Data
- Recover
Verify that the Status of the database is displayed as MOUNTED; if necessary click on the Refresh button to refresh the status.
Click OK.

Restoring Archive Logs

In addition to restoring data files/ table spaces, the SAP for Oracle iDataAgent also enables you to restore the archive logs. Archive logs can be restored along with the data or separately.

Archive logs can be restored from the latest log backups or from log backups from a specific point in time.

Consider the following scenarios:

In most cases, users will want to view the pertinent logs of a backup cycle. In such cases, you can specify Browse Latest Data or Specify Browse Time to view only the pertinent logs (logs pertaining to a cycle).
If, due to a hard disk corruption, logs from a specific time range were lost, you can restore them by performing a point in time restore of the logs. When you browse between a specific point of time range, the logs pertaining to all the cycles within the specified time range will be listed.
Assume there is a database failure and you need to restore the database as well as the logs to recover the database to the recent state. In such case, you will choose to restore all the logs.
In certain cases, you might need to restore only specific logs that are missing in the database. In such situations, you can browse the latest logs in the browse window, and choose specific individual logs for the restore operation.

restoring with specific Log Time

When restoring the archive logs based on the log time, if the data is also included in the restore, ensure that the time range is the same for both data and the logs.

From the CommCell Browser, right-click the instance and select All Tasks | Restore.
From the General tab, select these options:
- Select the name of the client computer with the Archived file you want to restore in the Destination Client from the list.
- Choose the Number of streams to use for restore and then select the option for Restore Archive Log to restore the Archive logs.
Click Advanced.
From the Restore tab, select Restore Archive Log.
Select By Log Time option and specify the point in time restore of archived log file.
Use the space to type the desired location or click Browse to find the location of the Target Directory.
Click OK.
Click OK to close the Restore Options window and initiate the job.

Restoring with Log Serial Number

When restoring based on the log serial number, note the following:

The end serial number must be greater than or equal to the start serial number.
The start and the end serial number cannot be 0.
The range of serial numbers to be restored could be from one or more backup jobs or from a part of a job and from one or more cycles.
If only the start sequence number is provided then the logs starting from that sequence number will be restored.

When restoring the archive logs based on the log time, if the data is also included in the restore, ensure that the time range is the same for both data and the logs.

From the CommCell Browser, right-click the instance and select All Tasks | Restore.
From the General tab, select these options:
- Select the name of the client computer with the Archived file you want to restore in the Destination Client from the list.
- Choose the Number of streams to use for restore and then select the option for Restore Archive Log to restore the Archive logs
Verify that the Status of the database is displayed as MOUNTED; if necessary click on the Refresh button to refresh the status.
Click Advanced.
From the Restore tab, select Restore Archive Log.
Select By Log Serial Number option and specify the restore between two serial numbers. Optionally, select From Second Copy.
Use the space to type the desired location or click Browse to find the location of the Target Directory.
Click OK.
Click OK to close the Restore Options window and initiate the job.

Restoring Control Files

The SAP for Oracle iDataAgent also enables to restore a missing control file. Control file is required to recover a database to the current state. You can restore the control file only when the database is in NOMOUNT mode.

From the CommCell Browser, right-click the instance and select All Tasks | Restore.
From the General tab, select Restore Control File.
Click Advanced.
Click the Ctrl Files tab of the Oracle Advanced Restore Options window, then select Restore Control File option and specify the name and location where the file need to be restored in the Restore Control File As text box.
If you do not specify a location, the control file is restored to the default location.
Click OK to save the settings and close the Advanced Restore Options window.
Click OK to close the Restore Options window and initiate the job.

Restoring Data from a Specific Time range

A point in time restore job allows you to restore your database to a specific point in time, and, typically, this point in time would be just before an undesired transaction or update to your database.

When you select the Point in Time option, all necessary backups that are required to restore the database to the indicated time are restored.

From the CommCell Browser, right-click the SAP instance, select All Tasks then click Restore.
From the General tab, select these options:
- Select the name of the client computer with the database you want to restore in the Destination Client from the list.
- Choose the Number of streams to use for restore.
- Select Restore Control File, Restore Data, Restore Archive Logs, and Recover options to restore and recover the entire database.
- Verify that the Status of the database is displayed as STARTED; if necessary click on the Refresh button to refresh the status.
Click Advanced.
From the Restore tab, do the following:
- Select Restore Data and Restore Control File.
- Select To Point In Time option and specify the point in time to restore the database. When you select the To Point in Time option, the backups that are required to restore the database to the indicated time are restored.
- Select By Log Time option and specify the point in time restore of Archived log file. If you select By Log Serial Number option, specify the restore between two serial numbers.
- If you know the exact device SAP device type used for the backup, select the Sap Device Type and choose either the util_file (file level backups) or rman_util (Oracle RMAN backups) device. Alternatively, you may select Auto Detect Device to allow the system to choose the exact device type that is used for the latest backup.
From the Recover tab, select Recover.
- Select Current Time to Recover an entire database at the current time and to the original host or to a different host.
- Select Point In Time option and specify the a specific point in time to restore the database. When you select the To Point in Time option, the backups that are required to restore the database to the indicated time are restored.
From the Options tab, select Reset Database.
Select Open DB to open the database after recovering the database. If required select Reset Logs to reset the logs after opening the database.
Click OK to save the settings and close the Advanced Restore Options window.
Click OK to close the Restore Options window and initiate the job.

Restoring to Specific Time Range Using Util_interface From SAP Command Line

Restore the control file from the Full Backup detail file name

brrestore -d util_file -b [detailFileName] -m 0

eg:

brrestore -d util_file -b bebwkurt.anf -m 0

Restore the data files

brrestore -d util_file -b [detailFileName] -m all -u /

Restore the detail files and summary file pertaining to the log backups using b2 restores. Provide the appropriate SAP Backup Stamps. It is recommended to create a copy of the Original arch<SID>.log before a restore process.

eg:

brrestore -d util_file -b2 SAP_007_1005 -m

home/oracle/product/10g/SAPDB/CER/saparch/archCER.log,/home/oracle/product/10g/SAPDB/CER/saparch/aebwlqlg.sve

Restore the Archive Logs

brrestore -d util_file -a <From ARCHIVE LOG#>-<To ARCHIVE LOG#>

Recover the database until the recover time using the control file

sql> recover database until time 'YYYY-MM-DD hh.mm.ss' using backup controlfile until cancel;

Open DB with RESET Logs option

sql>alter database open resetlogs;

Recovering a Database

In certain cases, you might restore the data and then recover the database at a later point of time. To facilitate this capability, SAP for Oracle iDataAgent allows you to perform a recover operation independently.

From the CommCell Browser, right-click the instance and select All Tasks | Restore.
From the General tab, select the following options:
- Select the name of the client computer with the database you want to restore in the Destination Client from the list.
- Choose the Number of streams to use for restore
- Recover to restore and recover the database based on the criteria specified in Oracle/SAP for Oracle Restore Options.
- Verify that the Status of the database is displayed as STARTED; if necessary click on the Refresh button to refresh the status.
Click Advanced.
From the Recover tab, select Recover.
- Select Current Time to recover an entire database at the current time and to the original host or to a different host.
- Select Point In Time option and specify the a specific point in time to restore the database. When you select the To Point in Time option, the backups that are required to restore the database to the indicated time are restored.
Select the Options tab and select Reset Database.
Select Open DB to open the database after recovering the database. If required select Reset Logs to reset the logs after opening the database.
Click OK.

The system automatically resets the logs and the database. Before you can restore and recover the database to the current time, it is good practice to perform another full backup and wait for it to complete successfully.

Scheduling A restore

1.	From the CommCell Console, navigate to Client Computers \| SAP for Oracle. Right-click an instance and click All Tasks \| Browse Backup Data. Click OK.
2.	Select data files, table spaces, or logs to restore. Click Recover All Selected.
3.	Click Job Initiation tab and click Schedule. Click Configure.
4.	Select the appropriate scheduling options. For example: Click Weekly. Check the days you want the run the restore job. Change the Start Time to 9:00 PM Click OK to close the Schedule Details dialog Click OK to close the Restore Options dialog The restore job will execute as per the schedule.

Restoring from Command Line

In addition to restores from CommCell Console, you can also perform restores from the Command Line Interface. Note that backups taken from CommCell Console can be restored via Command Line and vice versa. However, backups taken from a previous version of CommCell Console can be restored only from the Command Line.

You can perform command line restores using one of the following methods:

Using Qcommands
Using SAP Command Line
Using BRTools Interface

However, SAP command line and BRTools are the most preferred methods for performing command line restores.

Using Qcommands

You can use qcommands to perform restore operations from the command line interface. You can also integrate these qcommands into your own scripts or scheduling programs. In addition, you can also generate scripts for specific operations from the CommCell Console using the Save As Script option. These scripts can later be executed using the commands from the command line interface.

For comprehensive information on command line restores, refer to the Command Line Interface documentation.

Using SAP Command Line

For the SAP for Oracle iDataAgent, data is restored using the BRRESTORE command. From the SAP command line, these programs can restore the following:

Database data files, control files, and archive log files that were saved using BRBACKUP
Non-database files that were saved using BRBACKUP
Profiles and logs

To restore data from the SAP command line using the BRRESTORE program:

From the client prompt, type brrestore and press Enter.
Use the subsequent options that appear as appropriate.

When performing command line restores, note the following:

Customize init<SID>.utl and init<SID>.sap. If init<SID>.sap file do not exist under $ORACLE_HOME/dbs DIR, you need to create an empty init<SID>.sap file (For example: touch $ORACLE_HOME/dbs/init<SID>.sap), and then restore it using the following command:
Brrestore -d util_file -b2 \#NULL -m $ORACLE_HOME/dbs/init<SID>.sap
Database should be in MOUNT mode before you begin a restore operation from command line. If you are restoring logs only from the command line, the database could be in OPEN Mode. If you are restoring the Control File, the database should be in the NOMOUNT mode.
If you want to restore the control file from a RMAN log backup (i.e,. BRARCHIVE backup) use the following command:
brrestore -b2 <archive file ID> -m <control file path>

For example,

brrestore -b2 SAP_1445_18400 -m /u01/app/oracer/product/10.2.0/db_1/CER/sapreorg/cntrlCER.dbf
If you want to restore an entire database, use the following command:

brrestore -d util_file -b last -m all

After a restore, you need to manually recover the database.
Whenever you restore the control file from Command Line Interface and manually recover the database, you need to reset the logs prior to opening the database. Refer Reset Logs for detailed information on resetting logs.
For SAP for Oracle iDataAgent, Job Details may display the name defaultDummyInstanceForSAP as the SID when a restore is run from the command line.

Examples:

Perform a full restore of the database using the util_file interface

brrestore -d util_file -m all -b beeonnpz.anf -u /
Perform a log only restore

brrestore -d util_file -a 1119-1121 -u /
Perform a control file restore

brrestore -b2 SAP_1020140_4613 -m /u01/app/oracer/product/10.2.0/db_1/CER/sapreorg/cntrlCER.dbf

Some of the command options commonly used by BRRestore command are listed below

Option	Argument	Values
-a	-archive	[<DB_SID>,<log_no>[=<rest_dest>]
-b	-backup	<log_name>\|last
-b2	-backup2	<util_backup_id>\|#NULL
-c	-confirm	force
-d	-device	util_file\|rman_util
-m	-mode	all\|full\|incr\|
-o	-output	dist\|time[,time\|dist]

PARAMETER FILE

If your restores will be using the SAP utility files, be sure to customize the init<SID>.utl and init <SID>.sap files by adding values for the following parameters. Note that some parameters are optional.
- CvInstanceName <name of instance>, which specifies the name of the instance for the iDataAgent (for example, Instance001)
- CvClientName <name of client>, which specifies the name of the computer with the installed iDataAgent (for example, bumblebee)
- numstreams <number of streams> (optional), which specifies the number of streams. Default value is 1 (for example,1)
- CV_restCopyPrec <name of copy> (optional), which specifies the copy to restore from. Default value is 0, which means any available copy (for example,1).This parameter can take values 0, 1, 2 etc,. However, in the case of selective copies, you need to specify values 1001,1002,etc.
- srcCrossClient <name of source client> (optional), which specifies the name of the source client with the iDataAgent for cross-machine restore purposes (for example, hotdog)
Ensure that the iDataAgent is installed on both the source computer and the target computer, and run the restore on the target computer.
RestoreSnapToTape, which specifies the source copy for restore. Default value is 0, which means that media will be used for restores.
RevertSnapVolume, which specifies that the revert operation is enabled. Default value is 0, which means that revert is disabled.
It is recommended to revert the data volumes, control file restores, log restores and recovery. You should reset the value of RevertSnapVolume to 0 to ensure that a revert operation is not unintentionally performed.

For example:

CvInstanceName

Instance001

CvClientName

bumblebee

numstreams

CV_restCopyPrec

srcCrossClient

hotdog

Running RMAN Restores from SAP Command Line

Use the following steps to run an RMAN restore from auxiliary copy using the SAP command line:

1.	Set the CV_restCopyPrec parameter in the init <SID>.sap file.	For example: rman_parms="BLKSIZE=1048576,SBT_LIBRARY=/opt/calypso/Base/libobk.so,ENV=(CvClientName=tigersnap2,CvInstanceName=Instance001,CV_restCopyPrec=4)"
2.	Run the restore command from the SAP command line.	For example: brrestore -d rman_util -b last -m all

Restoring from Consistent Online Backups

When you restore from consistent online backups, the offline redo log files of the same backup can be imported.

Use the following steps to restore the data, logs, and the control file from a consistent online backup:

Include the instance name and client name parameters in the init.utl file.

For example:

CvInstanceName

Instance001

CvClientName

client1

Run the restore command from the SAP command line.

For example:

brrestore -d util_file -m full -b begqxybq.fnf

Use the following steps to restore only the data from a consistent online backup:

Include the instance name and client name parameters in the init.utl file.

For example:

CvInstanceName

Instance001

CvClientName

client1

Run the restore command from the SAP command line.

For example:

brrestore -d util_file -m full -b begqxybq.fnf

Use the following steps to restore only the logs from a consistent online backup:

Include the instance name and client name parameters in the init.utl file.

For example:

CvInstanceName

Instance001

CvClientName

client1

Run the restore command from the SAP command line.

For example:

brrestore -d util_file -b2 1020458_18262 -m /database/oracle/10GR2/CER/saparch/1_102_756928037.dbf

BRTools Interface

In addition to SAP command line, you can also use the BRTools user interface to perform backup and restore operations. BRTools is an easy-to-use interface that provides menus to run different types of backup or restore operations.

BACKINT Interface

BACKINT is another interface program that internally uses the SAP BRTools to communicate with the SAP Oracle Database and perform backup and restore operations. It also allows you to inquire about backup requests and executes them.

backint -u <user_id> [-f <function>] [-t <type>] [-p <par_file>] [-i <in_file>] [-o <out_file>] [-c]

-u	Specifies the BACKINT user ID. Normally, this will be the database instance name (ORACLE_SID)	None
-f	Specifies the operation (backup, restore, or inquire)	backup
-t	Specifies the backup type: file or file_online	file
-p	Specifies the backup utility parameter file containing the parameters that determine the backup procedure specific to the backup utility. The SAP BRtools specify the location of this utility parameter file in their own parameter file (parameter util_par_file), but they do not evaluate its contents.	none
-i	Specifies the input file (text file) that defines the files and directories to be backed up.	By default, the data is read from the standard input.
-o	Specifies the output text file that will contain the processing messages and the results of the operation.	By default, the messages are displayed on the standard output.
-c	unattended mode (does not involve user interaction)	attended mode

The BACKINT interface allows you to restore files based on the user ID name, backup ID, or file name as specified in the input file. For example, if you include the tag #NULL in front of the file name, the specific file from the most recent backup will be restored.

backint -u C11 �f restore -t file �p /oracle/CER/dbs/initC11.utl -i dummy -o dummy.out

The output file looks like below:

Program: backint

Parameters:

Client node: RC1

Function: backup

Input File: dummy

Output File: dummy.out

Profile: /oracle/CER/dbs/initCER.utl

Parallel sessions: 1

BKI0032I: Number of bytes to restore: 0.012 MB.

Restore process started ...

#RESTORED SAP___9409020458 /oracle/CER/sapdata1/user1i_1/user1i.data1

BKI0023I: Bytes restored so far: 0.012 MB (100.0%).

Browse Data

The option to browse the backup data provides the facility to view and selectively restore/recover the data that was backed up.

The browse option can be invoked from the client, agent, or instance level depending on the functionality of a given agent.

Depending on the agent, there are several additional options to customize your browse, including:

Capability to browse the most recent (latest) data.
Capability to browse data in a specified time range.
Capability to limit the browse to a specified path.
Facility to specify the page size of the browse window.
Ability to browse the image of the data as it existed at the specified browse time.
Ability to browse from a specified storage policy copy.
Ability to browse all data including deleted items secured by data protection operations.

Use the following steps to browse data:

From the CommCell Browser, navigate to <Client>.
Right-click Instance and click All Tasks | Browse Backup Data.
Click OK.

Browsing Data from Before the Most Recent Full Backup

To browse data that is older than the most recent full backup specify a Browse Data Before date that pre-dates the full backup. Remember, the Browse Data Before date establishes the ending point of the search. Consequently, using a Browse Data Before date that pre-dates the most recent full backup starts the search in the previous full backup cycle. This is only valid if the data in that full backup cycle has not expired.

Browse Data Before a Specified Time

Follow the steps given below to browse data that was backed up before a specified time:

From the CommCell Browser, navigate to <Client>.
Right-click Instance and click All Tasks | Browse Backup Data.
Select Specify Browse Time and the Time Zone.
Click OK.

Browse Data Between a Specified Time

Follow the steps given below to browse data backed up during a specified time interval:

From the CommCell Browser, navigate to <Client>.
Right-click Instance and click All Tasks | Browse Backup Data.
Select Specify Browse Time and the Time Zone.
Click Advanced.
Select Exclude Data Before, select the date and time from which you wish to view the data in the browse window.
Click OK.

Listing Media

List media option is useful to predict media required for the following operations:

To restore data associated with a specific backup set, subclient or instance
To restore the index required to browse data associated with a specific backup set or subclient
To restore a specific file (or specific files and folders)
To restore data associated with a specific job

The list media operation can be performed for instances, backup sets, and subclients. The following sections describe each of these methods.

The List Media feature can also be used in a number of other capacities. Refer to the List Media documentation for a complete overview of this feature.

Listing Media For a Subclient

From the CommCell Browser, right-click the subclient for which you wish to list media and then click List Media.
From the List Media dialog box choose one of the following options:
- Click Media For the Latest Data to list media associated with the most recent data protection cycle.
- Click Specify Time Range to list media associated with data protection operations up to the specified date and time range.
  Use the Data Before box to specify the end date and time.
- Click Advanced and then click Exclude Data Before to list media associated with data protection operations after the specified date and time.
Note that you can use the Specify Browse Time and Exclude Data Before options to list media between a specified date and time range.
Click OK.
The appropriate media is listed in the Media dialog box.

Listing Media For a Backup Set or Instance

From the CommCell Browser, right-click the backup set or instance for which you wish to list media, click All Tasks and then click Browse.
From the Browse Options dialog box, if required, select the following options:
- Click Browse the Latest Data to list media associated with the most recent data protection cycle.
- Click Specify Browse Time to list media associated with data protection operations up to the specified date and time range.
  Use the Browse Data Before box to specify the end date and time.
- Click Advanced and then click Exclude Data Before and then select the date and time from which you wish to list media associated with data protection operations.
Note that you can use the Specify Browse Time and Exclude Data Before options to list media between a specified date and time range.
Click List Media.
From the List Media dialog box, click List Media for restore within specified time range and click OK.
The appropriate media is listed in the Media dialog box.

Restoring by Jobs

The Restore By Jobs feature provides the facility to select a specific backup job to be restored. This method of restoring data is considerably faster as it reads continuously on the tape and retrieves the data and does not depend on the indexing subsystem to get the seek offsets on the media.

This feature can be used in different scenarios such as the following:

To restore point-in-time data associated with a specific backup job, such as full, incremental, differential, etc.
To restore CommServe DR data for the disaster recovery or for creating a hot-site purposes.
To restore multiplexed data from the same client.

Consider the following when restoring by jobs:

Run a restore by jobs whenever you want to restore the entire contents of the job.
Avoid running restores by jobs for jobs associated with the default subclient. If you do this, the entire contents of the machine will be restored. As such, this may cause problems (e.g., the machine might run out of space) or produce undesirable results (e.g., you might end up restoring operating system files or directories that you really do not want to restore).
Avoid modifying the contents of any associated subclients since this may result in the retrieval of older data.

Use the following steps to restore data by jobs.

From the CommCell Browser, right-click the level whose data you want to browse, click View and then click the Backup History.
From the Backup History Filter window, select the filter options, if any, that you want to apply and click OK.
From the Backup Job History window, right-click the backup job that need to be restored and select Browse. From the Browse Options dialog box, click OK to execute the browse using the Browse the Latest Data option.
From the Browse window, select the instance node in the left pane and then select the required data and logs in the right pane, and click the Recover All Selected button at the bottom of the window. Select the desired restore options and click OK.

Manage Restore Jobs

Once you initiate the restore operation, a restore job is generated in the Job Controller. Jobs can be managed in a number of ways. The following sections provide information on the different job management options available:

Restart Jobs

Jobs that fail to complete successfully are automatically restarted based on the job restartability configuration set in the Control Panel. This configuration can be changed at any time; however, changes to this configuration will affect all jobs run in the entire CommCell.

It is also possible to override the default CommServe configuration for individual jobs by configuring retry settings when initiating the job. This configuration, however, will apply only to the specific job.

Restore jobs for this Agent are re-started from the beginning.

Configure job restartability at the CommServe level

In the CommCell Console, click the Control Panel icon, then double-click Job Management.
In the Job Restarts tab of the Job Management dialog box, select a job type from the Job Type list, and then select the Restartable check box.
To change the maximum number of times the Job Manager will try to restart a job, select a number in the Max Restarts box.
To change the time interval between attempts by the Job Manager to restart the job, select a number of minutes in the Restart Interval (Mins) box.
Click OK to save your changes.

Configure Job Restartability for an Individual Job

From the Restore Options dialog box, click Advanced, then select the Job Retry tab and specify the following as desired:
- Total Running Time - The maximum elapsed time, in hours and minutes, from the time that the job is created.
- Number of Retries - The number of times that Job Manager will attempt to restart the job.
- Kill Running Jobs When Total Running Time Expires - Option to kill the job when the specified Total Running Time has elapsed, even if its state is "Running".
Click OK.

Resubmit Jobs

If a restore job fails to complete successfully, you can resubmit the job without the need to reconfigure the original job's restore options using the Resubmit Job feature. When a job is resubmitted, all the original options, restore destinations, and other settings configured for the job remain in tact.

Resubmit a Restore Job

From the CommCell Browser, right-click a client computer whose data recovery history you want to view, click View, then click to view a job history.
From the Job History Filter dialog box, select Restore.
- If you want to view more advanced options for restores, from the Job History Filter, select Restore, then click Advanced.
- From the Data Recovery History Advanced Filter select the destination client computer of the restores you would like to view, then click OK.
The system displays the results of the options you selected in the Data Recovery Job History window.
Right-click on any job, and select Resubmit.
Select the job options.
Click OK.

Control Jobs

The following controls are available for running jobs in the Job Controller window:

Suspend	Temporarily stops a job. A suspended job is not terminated; it can be restarted at a later time. Only preemptible jobs can be suspended.
Resume	Resumes a job and returns the status to Waiting, Pending, Queued, or Running depending on the availability of resources or the state of the operation windows and activity control settings. Restore jobs for this Agent are resumed from the beginning.
Kill	Terminates a job.

These controls can be applied to:

All jobs in the Job Controller.
All selected jobs in the Job Controller providing you have the correct security associations at the proper level for each job selected.
All data protection operations running for a particular client or client/agent.
All data protection operations running for a particular MediaAgent.

Control A Job

From the Job Controller of the CommCell Console, right-click the job and select Kill, Suspend, or Resume as desired.
- When killing a job:
  Click Yes when the confirmation prompt appears if you are sure you want to kill the job. The job status may change to Kill Pending for a few moments while the operation completes. Once completed, the job status will change to Killed and it will be removed from the Job Controller window after five minutes.
- When suspending a job:
  The job status may change to Suspend Pending for a few moments while the operation completes. The job status then changes to Suspended.
- When resuming a job:
  As the Job Manager attempts to restart the job, the job status changes to Waiting, Pending, or Running.

Job Status

In the case of SAP for Oracle iDataAgent, the job status is displayed depending on the BRTOOLs error codes.

BRTools Error Code

Message

Job Status

0	Successful	Completed
1	Warnings � all files were processed (for example, backed up or restored)	Completed With Warning
2	Canceled during the initialization phase by a user or other signal	Completed With One or More Errors
3	Errors occurred during the initialization phase, processing was not started	Completed With One or More Errors
4	Canceled by a user or other signal during processing	Completed With One or More Errors
5	Started, but not completed because errors occurred during processing	Completed With One or More Errors
6	Internal termination	Completed With One or More Errors

Additional Restore Options

Several additional options are available to further refine your restore operations. These options are available from the Advanced Backup Options window.

To access the Advanced restore Options window:

From the CommCell Browser, expand Client Computers by double-clicking Client Computers | SAP for Oracle | <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane.
To restore from the instance level, right-click the instance, and click Restore.
From the SAP/Oracle Restore Options dialog box, click Advanced.

The following table describes the additional options:

Option	Description	related topic
Use hardware revert capability if available	This option allow you to revert the data to the time when the snapshot was created. Selecting this option brings back the entire LUN to the point when the snapshot was created, overwriting all the modifications to data since the snapshot creation. This option is available if the snapshot engine used for SnapProtect Backup supports the revert operation. From the CommCell Browser, click Client Computers \| SAP for Oracle \| <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data. From the Browse Options window, click OK. From the browse window, select the data to be restored and click Recover all Selected. From the Restore Options for All Selected Items dialog box, click Advanced. From the Advanced Restore Options (General) tab, select Use hardware revert capability if available.
Startup Options	The Job Manager will use the startup priority setting when allocating the required resources. This is useful if you have jobs that are very important and must complete, or jobs that can be moved to a lower priority. From the CommCell Browser, click Client Computers \| <agent> \| <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data. From the Browse Options window, click OK. From the browse window, select the data to be restored and click Recover all Selected. From the Restore Options for All Selected Items dialog box, click Advanced. From the Advanced Restore Options (General) tab, select Use Default Priority option. Select Change Priority option to change the priority for a job, between 0 (highest priority) and 999 (lowest priority). Select Start up in Suspended State option to specify the selected job to start in the Job Controller in a suspended state. Click OK.	Refer to Job Priority and Priority Precedence.
Copy Precedence	When you select Restore from copy precedence option, the system recovers or retrieves data from the selected storage policy copy (Synchronous Copy or Selective Copy). If data does not exist in the specified copy, the data recovery or retrieve operation fails even if the data exists in another copy of the same storage policy. When cleared, (or by default) the system recovers or retrieves data from the storage policy copy with the lowest copy precedence. If the data was pruned from the primary copy, the system automatically recovers or retrieves from the other copies of the storage policy in the lowest copy precedence to highest copy precedence order. Once the data is found, it is recovered or retrieved, and no further copies are checked. From the CommCell Browser, click Client Computers \| <agent> \| <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data. From the Browse Options window, click OK. From the browse window, select the data to be restored and click Recover all Selected. From the Restore Options for All Selected Items dialog box, click Advanced. From the Advanced Restore Options (General) tab, select Restore from copy precedence option. Select the number to change the selected copy's precedence. The numbers will move a copy to a higher or lower precedence in increments of 1. Click OK.	Refer to Recovering Data From Copies.
Data Path Options	Data Recovery operations use a specific data path (Library, MediaAgent, Drive Pool, and Drive) to perform the restore operations as configured in the CommCell. By default, the system automatically identifies the data path for the restore operations. You can change the data path at the restore level by selecting a specific MediaAgent, library, drive pool or drive in the Advanced Restore Options dialog. The following are some of the important situations where you may need to change the data path: To free heavily loaded resources such as MediaAgents and libraries. A library suffers severe hardware damage and you need to move its media to a different library in order to access data secured by data protection operations. A drive pool within a library is being used much more frequently than another, and a storage policy copy from the more active drive pool can be assigned to the less active one. From the CommCell Browser, click Client Computers \| <agent> \| <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data. From the Browse Options window, click OK. From the browse window, select the data to be restored and click Recover all Selected. From the Restore Options for All Selected Items dialog box, click Advanced. From the Advanced Restore Options (General) tab, select the MediaAgent and Library that you wish to perform the restore. Select the Drive Pool and Drive for optical and tape libraries. Click OK.	Refer to Change Data Path.
Alerts	The Alert option is used for setting up the criteria to raise notifications/alerts for job statuses such as failure, success, or any other conditions triggered by the restore job. Adding alerts helps the user or the user group to get the notification automatically about the status of the restore job. From the CommCell Browser, click Client Computers \| <agent> \| <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data. From the Browse Options window, click OK. From the browse window, select the data to be restored and click Recover all Selected. From the Restore Options for All Selected Items dialog box, click Advanced. From the Advanced Restore Options (General) tab, click Add Alert. From the Add Alert Wizard window, select the Threshold and Notification Criteria. Click Next. Select the Notification Types. Click Next. Select the Users and User Groups. Click Next. Verify the Summary. Click Finish.	Refer to Alert.
Reset Database	When you select this option, a new database incarnation record is created for the new database after recovering the database. From the CommCell Browser, click Client Computers \| SAP for Oracle \| <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data. From the Browse Options window, click OK. From the browse window, select the data to be restored and click Recover all Selected. From the Restore Options for All Selected Items dialog box, click Advanced. From the Advanced Restore Options (Options) tab, select Reset Database option.
Open DB	Once you recover the database, you can choose whether to open the database after the restore/recovery operation has completed. Selecting this option will open the database, and enable the Reset Logs option. From the CommCell Browser, click Client Computers \| SAP for Oracle \| <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data. From the Browse Options window, click OK. From the browse window, select the data to be restored and click Recover all Selected. From the Restore Options for All Selected Items dialog box, click Advanced. From the Advanced Restore Options (Options) tab, select Open DB option.
Reset logs	This option is available from the Options tab in the Advanced Restore Options window. Whenever you restore the control file from Command Line Interface and manually recover the database, you need to reset the logs prior to opening the database. To enable the Reset Logs option, the Open DB checkbox must be selected. From the CommCell Browser, click Client Computers \| SAP for Oracle \| <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data. From the Browse Options window, click OK. From the browse window, select the data to be restored and click Recover all Selected. From the Restore Options for All Selected Items dialog box, click Advanced. From the Advanced Restore Options (Options) tab, ensure the Open DB checkbox is selected. You can Reset Logs as follows: None - Open the database without any RESETLOGS option. Yes - Open the database with RESETLOGS option. No - Open the database with NORESETLOGS option.

Advanced - SAP for Oracle Restore

Table of contents

Related Topics

Choosing Restore Types

Backup Type

Restore Level

Notes

Restoring Control Files

Restoring to Specific Time Range Using Util_interface From SAP Command Line

PARAMETER FILE

Running RMAN Restores from SAP Command Line

Restoring from Consistent Online Backups

Browse Data Between a Specified Time

Configure job restartability at the CommServe level

Configure Job Restartability for an Individual Job

Resubmit a Restore Job

Suspend

Resume

Kill

Control A Job