Loading...

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

    Restore the 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

Last modified: 3/21/2019 8:48:43 PM