Example: Restarting a NetBackup for SAP restore job (Windows)
This section shows how to restart a failed restore job. Assume that the you deliberately cancelled the job from the activity monitor. In reality, the job might fail due to different reasons.
This example shows the log messages that brrestore created while restoring the files for the CER database, using the following command:
brrestore -d util_file -b last -m all
The following are excerpts from the corresponding brrestore log file:
BR0280I BRRESTORE time stamp: 2006-05-18 23.18.15 BR0407I Restore of database: CER BR0408I BRRESTORE action ID: rdsqcxdf BR0409I BRRESTORE function ID: rsb BR0449I Restore mode: ALL BR0419I Files will be restored from backup: bdsqcwtl.aff 2006-05-18 23.14.01 BR0416I 19 files found to restore, total size 645.148 MB BR0421I Restore device type: util_file BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRESTORE time stamp: 2006-05-18 23.18.16 BR0229I Calling backup utility with function 'restore'...
BR0278I Command output of 'backint -u CER -f restore -I C:\oracle\SUD\sapbackup\.rdsqcxdf.lst -t file -p C:\oracle\Ora920\dbs\initCER.utl -c':
******************************************************************************
Program: backint 6.5 Input File: C:\oracle\SUD\sapbackup\.rdsqcxdf.lst Profile: C:\oracle\Ora920\dbs\initCER.utl
Function: RESTORE ****************************************************************************** BR0280I BRRESTORE time stamp: 2006-05-18 23.18.57
#FILE..... C:\oracle\SUD\sapdata1\btabd_1\btabd.data1
#RESTORED. VXF1147974254 …. …. BR0280I BRRESTORE time stamp: 2006-05-18 23.18.57
#FILE..... C:\oracle\SUD\sapdata1\el46bi_1\el46bi.data1
#RESTORED. VXF1147974254 *********************************************************************** BR0374E 7 of 19 files restored by backup utility BR0280I BRRESTORE time stamp: 2006-05-18 23.18.57 BR0231E Backup utility call failed
After you start the brrestore command, you cancel the restore job from the activity monitor. As the preceding log indicates, brrestore restored 7 out of the 19 files. You can restore the remaining files as part of a new brrestore session. In a production situation, you should identify and correct the cause of failure before restarting brrestore.
Enter the following command with the -f option to start brrestore:
brrestore -d util_file -m all -f last
The following output is an excerpt from the corresponding brrestore log file:
BR0453W Error message found in C:\oracle\SUD\sapbackup\rdsqcxdf.rsb:
'BR0374E 7 of 19 files restored by backup utility'
BR0453W Error message found in C:\oracle\SUD\sapbackup\rdsqcxdf.rsb:
'BR0231E Backup utility call failed'
BR0471W Restore C:\oracle\SUD\sapbackup\rdsqcxdf.rsb terminated with errors BR0428W File C:\oracle\SUD\sapdata6\es46bd_1\es46bd.data1 will be overwritten
BR0280I BRRESTORE time stamp: 2006-05-18 23.19.20 BR0407I Restore of database: CER BR0408I BRRESTORE action ID: rdsqcxfs BR0409I BRRESTORE function ID: rsb BR0449I Restore mode: ALL BR0419I Files will be restored from backup: bdsqcwtl.aff 2006-05-18 23.14.01 BR0416I 12 files found to restore, total size 520.094 MB BR0445I 7 files were already restored in the following run: rdsqcxdf.rsb BR0421I Restore device type: util_file
brrestore checks the previous log file and finds that 12 files need to be restored and that 7 files are already restored. brrestore directs backint to restore the 12 files. The log file is as follows:
BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRRESTORE time stamp: 2006-05-18 23.19.20 BR0229I Calling backup utility with function 'restore'...
BR0278I Command output of '/usr/sap/CER/SYS/exe/run/backint -u CER -f restore -I C:\oracle\SUD\sapbackup\.rdsqcxfs.lst -t file -p C:\oracle\Ora920\dbs\initCER.utl -c':
***********************************************************************
Program:/usr/sap/CER/SYS/exe/run/backint 6.5 Input File:C:\oracle\SUD\\sapbackup\.rdsqcxfs.lst Profile:C:\oracle\Ora920\dbs\initCER.utl
Function:RESTORE *********************************************************************** BR0280I BRRESTORE time stamp: 2006-05-18 23.20.09
#FILE..... C:\oracle\SUD\sapdata6\es46bd_1\es46bd.data1
#RESTORED. VXF1147974254 …. …. BR0280I BRRESTORE time stamp: 2006-05-18 23.20.09
#FILE..... C:\oracle\SUD\sapdata1\pooli_1\pooli.data1
#RESTORED. VXF1147974254 *********************************************************************** BR0280I BRRESTORE time stamp: 2006-05-18 23.20.09 BR0374I 12 of 12 files restored by backup utility BR0230I Backup utility called successfully
As the preceding log shows, the remaining 12 files are restored successfully.