Disaster Recovery with BR*Tools

Purpose

You can use BR*Tools for Oracle to recover from a disaster. You use BRRECOVER to restore missing or damaged profiles and log files. BRRESTORE is not called by disaster recovery, because it always requires the BRBACKUP Logs or the BRARCHIVE Logs, which might not be available in a disaster.

You use this process if either of the following is true:

·        You have lost the entire database, including the profiles and the BRBACKUP logs or the BRARCHIVE logs.

·        You have only lost the profiles and the BRBACKUP or BRARCHIVE logs.

This process does not actually restore data files or recover redo log files. It only restores the profiles and BRBACKUP or BRARCHIVE logs from copies that you made during previous backups. Therefore, it prepares the database for you to perform one of the following guided BR*Tools options:

·        Database point-in-time (PIT) recovery

·        Whole database reset

Complete database recovery and database PIT recovery are not possible after disaster recovery because the current control file (required for complete database recovery) is missing and the database cannot be opened (required for tablespace PIT recovery).

Only perform this process if you are an expert in Oracle database administration. Even as an expert, we recommend that you first try other types of recovery supported by BR*Tools.

If you are not an expert, you might severely damage the database with this procedure. You might lose data and cause downtime to fix the problem.

This section discusses how to perform disaster recovery.

For more information on how to approach disaster recovery, see Disaster Recovery.

Prerequisites

·        Since this function is designed for experts, the usual safeguards are not present:

Ў        There is no database status check.

Ў        You have less guidance than otherwise, since BRRECOVER does not guide you step by step through restore and recovery.

Ў        You can choose individual actions independently.

·        For all procedures, the backup medium with the required backup files must obviously be present.

·        You need to know exactly which file to restore and where it is. You are effectively performing a copy at operating-system level.

·        BRRECOVER restores the profiles and logs to the standard directory.

·        If you choose device type Backup utility for the restore, note the following:

Ў        The BACKINT repository with the latest backup must be available because the tapes are administered using this repository in the backup utility.

Ў        The BACKINT parameter file must normally exist, depending on the specific implementation that you are using. If it is required but is unavailable, you must first try and recreate it before performing disaster recovery.

Ў        BRRECOVER calls BACKINT to perform the restore.

Ў        BACKINT performs the restore from the profiles or logs of the latest backup.

Process Flow

...

       1.      You start BRGUI or BRTOOLS.

       2.      You choose Restore and recovery ® Disaster recovery.

       3.      You choose the required procedure:

Ў        Restore profiles and logs files from BRBACKUP backup

Ў        Restore profiles and logs files from BRARCHIVE backup

BRRECOVER starts the restore and displays the menu Device Type.

       4.      You choose the device tape where the backups of the profiles or logs are stored.

BRRECOVER displays the parameters for restoring the profiles or logs, depending on what kind of device type you specified. The default parameters are taken from the current profile, Initialization Profile init<DBSID>.sap, if available.

       5.      For a disk backup or a utility backup, you note the following:

Ў        For a disk backup, you can specify the backup directory. BRRECOVER looks in the sub-directory <DBSID> of the specified directory to find the summary log for BRBACKUP or BRARCHIVE. It uses the information there for the restore.

Ў        For a utility backup, check “Prerequisites” above.

       6.      You choose Continue to continue the restore with the displayed parameters.

BRRECOVER warns you that the profiles and logs might be overwritten.

BRRECOVER displays the restore menu where you can specify which profiles and logs to restore:

Ў        If a log or profile already exists on disk, the recommendation is No to avoid overwriting it.

Ў        If a log or profile does not exist on disk, the recommendation is Yes to let you restore it.

       7.      If required, you change the recommended values for restoring the profiles and logs. You can select several profiles or logs to restore.

       8.      You choose Continue to start restoring the selected profiles or logs.

       9.      You check the results in the BRRECOVER logs:

Ў        The summary log recov<DBSID>.logdisplays the return code.

Ў        The detail log v<encoded timestamp>.drv displays the progress.

For more information on how to view the logs, see Showing Logs with BR*Tools.

Example

This example shows the contents of the BRRECOVER detail log file for Restore profiles and log files from BRBACKUP backup, using a local tape.

BR0655I Choice menu 136 - please decide how to proceed

-------------------------------------------------------------------

Disaster recovery main menu

 

 1 = Restore profiles and log files from BRBACKUP backup

 2 - Restore profiles and log files from BRARCHIVE backup

 3 - Exit program

 4 - Reset program status

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------

BR0662I Enter your choice:

BR0280I Time stamp 2003-01-31 18.18.27

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0280I Time stamp 2003-01-31 18.18.27

BR0656I Choice menu 137 - please make a selection

-------------------------------------------------------------------

Device type for restoring profiles and log files from BRBACKUP backup

 

 1 = Local tape

 2 - Remote tape

 3 - Local disk

 4 - Remote disk

 5 - Backup utility

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------

BR0662I Enter your choice:

BR0280I Time stamp 2003-01-31 18.18.28

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0280I Time stamp 2003-01-31 18.18.28

BR0657I Input menu 138 - please check/enter input values

-------------------------------------------------------------------

Parameters for restoring profiles and log files from local BRBACKUP tape

 

 1 - Backup profile (profile) .................. [/oracle/GC2/dbs/initGC2.sap]

 2 - Tape drive with no-rewind (tape_address) .. [/dev/rmt/1mn]

 3 - Tape drive with rewind (tape_address_rew) . [/dev/rmt/1m]

 4 - Tape rewind command (rewind) .............. [mt -f $ rewind]

 5 - Tape positioning command (tape_pos_cmd) ... [mt -f $ fsf $]

 6 - Cpio input options (cpio_in_flags) ........ [-iuv -C 65536]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------

BR0662I Enter your choice:

BR0280I Time stamp 2003-01-31 18.18.29

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

.....

 

BR0280I Time stamp 2003-01-31 18.18.40

BR0657I Input menu 145 - please check/enter input values

-------------------------------------------------------------------

Restore of profiles and log files from BRBACKUP backup

 

 1 – BR*Tools profile (init_sap) ....... [no]

 2 - Oracle profile (init_ora) ......... [no]

 3 - Oracle spfile (sp_file) ........... [no]

 4 # BACKINT/Mount profile (init_utl) .. [no]

 5 - Detail log (det_log) .............. [yes]

 6 - Summary log (sum_log) ............. [no]

 7 – BRSPACE summary log (space_log) ... [no]

 8 - BRSPACE structure log (struc_log) . [no]

 9 – BRSPACE parameter log (param_log) . [no]

10 # Control file copy (control_file) .. [no]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------

BR0662I Enter your choice:

BR0280I Time stamp 2003-01-31 18.18.42

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0746I File /oracle/GC2/sapreorg/reorgGC2.log will be restored from /dev/rmt/1mn

BR0746I File /oracle/GC2/sapreorg/structGC2.log will be restored from /dev/rmt/1mn

 

BR0280I Time stamp 2003-01-31 18.18.42

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I Time stamp 2003-01-31 18.18.44

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

BR0210I Please mount BRBACKUP volume, if you have not already done so

 

BR0280I Time stamp 2003-01-31 18.18.44

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I Time stamp 2003-01-31 18.18.46

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

BR0280I Time stamp 2003-01-31 18.18.46

BR0226I Rewinding tape volume in device /dev/rmt/1m ...

 

BR0370I Directory /oracle/GC2/sapbackup/vdjwrcgu.1 created

 

BR0280I Time stamp 2003-01-31 18.19.10

BR0226I Rewinding tape volume in device /dev/rmt/1m ...

 

BR0226I Winding tape volume in device /dev/rmt/1m ...

BR0285I This function can take several seconds/minutes - be patient

 

BR0351I Restoring /oracle/GC2/sapbackup/vdjwrcgu.1/reorg_log+struct_log

BR0355I from /dev/rmt/1mn ...

 

#FILE..... /oracle/GC2/sapbackup/vdjwrcgu.1/reorg_log+struct_log

#RESTORED. reorgGC2.log,structGC2.log  #0/26

 

BR0370I Directory /oracle/GC2/sapbackup/vdjwrcgu created

 

BR0202I Saving /oracle/GC2/sapreorg/reorgGC2.log

BR0203I to /oracle/GC2/sapbackup/vdjwrcgu/reorgGC2.log ...

BR0428W File /oracle/GC2/sapreorg/reorgGC2.log will be overwritten

BR0746I File /oracle/GC2/sapreorg/reorgGC2.log will be restored from /oracle/GC2/sapbackup/vdjwrcgu.1/reorgGC2.log

 

BR0202I Saving /oracle/GC2/sapreorg/structGC2.log

BR0203I to /oracle/GC2/sapbackup/vdjwrcgu/structGC2.log ...

BR0428W File /oracle/GC2/sapreorg/structGC2.log will be overwritten

BR0746I File /oracle/GC2/sapreorg/structGC2.log will be restored from /oracle/GC2/sapbackup/vdjwrcgu.1/structGC2.log

 

BR0668I Warnings or errors occured - you can continue to ignore them or go back to repeat the last action

BR0280I Time stamp 2003-01-31 18.22.32

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I Time stamp 2003-01-31 18.22.35

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

BR0351I Restoring /oracle/GC2/sapreorg/reorgGC2.log

BR0355I from /oracle/GC2/sapbackup/vdjwrcgu.1/reorgGC2.log ...

 

#FILE..... /oracle/GC2/sapreorg/reorgGC2.log

#RESTORED. /oracle/GC2/sapbackup/vdjwrcgu.1/reorgGC2.log

 

BR0351I Restoring /oracle/GC2/sapreorg/structGC2.log

BR0355I from /oracle/GC2/sapbackup/vdjwrcgu.1/structGC2.log ...

 

#FILE..... /oracle/GC2/sapreorg/structGC2.log

#RESTORED. /oracle/GC2/sapbackup/vdjwrcgu.1/structGC2.log

 

BR0749I 2 files have been successfully restored

==================================================================