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.