> CommCell Console > Backup and Restore Agents > Databases > SAP > SAP for Oracle > SAP on Oracle Restores > SAP on Oracle Restore Examples Using the BR*Tools Command Line Interface

BR*Tools Example: Restoring from Older Backups without the Job ID

Use this procedure to restore from a backup other than the most recent backup when you do not have the job ID.

Note

When you use the \#NULL option, the following files are restored from the most recent backup.

  1. back<SID>.log

  2. arch<SID>.log

  3. init<SID>.utl

  4. init<SID>.ora

  5. init<SID>.sap

Before You Begin

  1. Enable restores of earlier backups without specifying the job ID.

  2. Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

Procedure

  • On the command line, type on of the following commands.

    Restore the data detail file

    Substitute the detail_detail_file variable. You must include the full path and the file name of the data detail file.

     
    brrestore -d util_file b2 \#NULL -m data_detail_file -c force 
#FILE..... data_detail_file
#RESTORED. log_detail_file
    Restore the log detail file

    Substitute the log_detail_file variable. You must include the full path and the file name of the log detail file.

     
    brrestore -d util_file b2 \#NULL -m data_detail_file -c force 
#FILE..... data_detail_file 
#RESTORED. log_detail_file

Example

The following data detail files are saved.

bepwqvwv anf 2015-02-17 16:20:21 2015-02-17 16:22:55 0 ............... 22 21 0 44 3106259 45 3131323 ALL online util_file ------ 7.40 (4) CER
 bepwqxdq anf 2015-02-17 16:34:34 2015-02-17 16:37:41 0 ............... 22 21 0 46 3131363 47 3131759 ALL online util_file ------ 7.40 (4) CER
 bepwrhjw anf 2015-02-17 18:29:56 2015-02-17 18:32:32 0 ............... 22 21 0 48 3131801 49 3134337 ALL online util_file ------ 7.40 (4) CER
 bepwriot anf 2015-02-17 18:43:19 2015-02-17 18:46:03 0 ............... 22 21 0 50 3134379 51 3134741 ALL online util_file ------ 7.40 (4) CER 
 bepwrtic anf 2015-02-17 20:44:22 2015-02-17 20:48:12 0 ............... 22 21 0 52 3134786 53 3137449 ALL online util_file ------ 7.40 (4) CER

The following log detail files are saved.

SAVED.... aepwqwdg svd *262791520_88118
 SAVED.... aepwqxlj svd *262791520_88120
 SAVED.... aepwrhqi svd *262791520_88127
 SAVED.... aepwrivs svd *262791520_88130
 SAVED.... aepwrtrl svd *262791520_88154

The most recent backup job is 88154.

The following can be used to restore older backups.

Restore the data detail file

brrestore -d util_file b2 \#NULL -m G:\oracle\CER\sapbackup\bepwqvwv.anf -c force 
 #FILE..... G:\oracle\CER\sapbackup\bepwqvwv.anf
 #RESTORED.262791520_88118

Restore the log detail file

brrestore -d util_file b2 \#NULL -m G:\oracle\CER\sapbackup\aepwqwdg.svd -c force 
 #FILE..... G:\oracle\CER\saparch\aepwqwdg.svd 
 #RESTORED.262791520_88118
×

Loading...