Restore of Individual Backup Files with BR*Tools

Purpose

You can use BR*Tools for Oracle to restore individual backup files. BRRECOVER calls BRRESTORE to perform the restore.

Only perform this procedure 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 if you use this procedure. You might lose data and cause downtime to fix the problem.

This section discusses how to perform a restore of individual backup files.

For more information on how to approach restore of individual backup files, see Restore of Individual Backup Files.

Prerequisites

·        Make sure you have set the necessary BRRECOVER parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRRECOVER.

·        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:

§         BRRECOVER does not always use the BR*Tools logs to guide you.

§         BRRECOVER does not guide you step by step through restore and recovery.

Ў        You can choose individual actions independently.

Ў        The database is closed for the shortest time possible.

·        You must meet the following prerequisites before starting the restore:

Procedure

Limitations

BRBACKUP logs

Restore files from BRBACKUP backup

You can only restore files saved by BRBACKUP, not by BRARCHIVE.

BRBACKUP summary and detail logs required

Restore individual files from tape

You cannot restore files from an RMAN backup.

No logs required

Restore individual files from disk

You cannot restore directories from a disk backup.

No logs required

Restore individual files from backup utility

You cannot restore files from an rman_util backup.

No logs required

Restore and apply incremental backup

You can only apply incremental backup, not offline redo log files.

BRBACKUP summary and detail logs required

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

Process Flow

...

       1.      You start BRGUI or BRTOOLS.

       2.      You choose Restore and recovery ® Restore of individual backup files.

       3.      You choose the required procedure from the list shown in the above table.

BRRECOVER starts the restore.

Processing now depends on which procedure you chose.

       4.      If you chose Restore files from BRBACKUP backup or Apply incremental backup:

                            a.      You select a single database backup.

If you are sure it contains the data that you require, you can select a backup that terminated with errors.

If you are performing Restore files from BRBACKUP backup, BRRECOVER displays a list of data files in the selected backup.

                            b.      You select the files that you want to restore.

This does not apply to Restore and apply incremental backup, because changes to all data files are stored in one incremental save set.

                            c.      You restore data files or restore and apply incremental backup.

       5.      If you chose one of the remaining procedures:

You need to know exactly which file to restore and where it is. With these procedures, you are effectively performing a copy at operating-system level.

You cannot use these procedures to restore an RMAN backup, except an RMAN backup to disk, which is effectively a one-to-one copy of database files.

                            a.      You specify the location of the file:

§         The position on tape for Restore individual files from tape

§         The name of the backup file on disk for Restore individual files from disk

§         The file name and back_id for Restore individual files from backup utility

For all these procedure, you can also specify the destination for the restore.

If a disk or backup utility is involved in the restore, you must specify the full path to the file that you want to restore.

                            b.      You perform the restore, which uses the following main BRRESTORE parameters:

§         -n|-number for Restore individual files from tape

§         -n2|-number2 for Restore individual files from disk

§         -b2|-back2 for Restore individual files from backup utility

       6.      You check the results in the BRRECOVER and BRRESTORE logs:

Ў        BRRECOVER logs:

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

§         The detail log v<encoded timestamp>.rif displays the progress.

Ў        BRRESTORE logs for the restore functions:

§         The summary log rest<DBSID>.logdisplays the return code

§         The detail log r<encoded timestamp>.rif 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 files from BRBACKUP backup.

BOR655I Choice menu 120 - please decide how to proceed

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

Restore of individual backup files

 

 1 = Restore files from BRBACKUP backup

 2 - Restore individual files from tape

 3 - Restore individual files from disk

 4 - Restore individual files from backup utility

 5 - Apply incremental backup

 6 - Exit program

 7 - Reset program status

 

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

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

BR0662I Enter your choice:

BR0280I Time stamp 2003-01-29 19.05.25

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0699I Reading log file /oracle/GC2/sapbackup/backGC2.log ...

 

BR0280I Time stamp 2003-01-29 19.05.25

BR0658I List menu 121 - please select one entry

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

BRBACKUP database backups for restore

 

Pos.  Log           Start                Type              Files  Device     Rc

 

  1 = bdjwhckx.ffd  2003-01-29 17.30.51  offline             0/0  disk        0

  2 - bdjwhadu.fft  2003-01-29 17.05.14  offline             0/0  tape        1

  3 - bdjwgyrq.fff  2003-01-29 16.48.42  offline             0/0  util_onl    0

  4 - bdjwgwtj.fnt  2003-01-29 16.26.55  onl_cons            0/0  tape        0

  5 - bdjwgvvh.fnf  2003-01-29 16.16.29  onl_cons            0/0  util_onl    0

  6 - bdjwcgfm.ffd  2003-01-28 17.48.54  offline           17/17  disk        0

  7 - bdjvdblz.fff  2003-01-23 14.52.03  offline             0/0  util_onl    0

.....

BR0280I Time stamp 2003-01-29 19.05.29

BR0663I Your selection: '5'

 

BR0699I Reading log file /oracle/GC2/sapbackup/bdjwgvvh.fnf ...

 

BR0280I Time stamp 2003-01-29 19.05.29

BR0659I List menu 122 + please select one or more entries

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

Backup files for restore

 

 Pos.  Tablespace        Id. Name

 

   1 - DRSYS              3  /oracle/GC2/sapdata1/drsys_1/drsys.data1

.....

   9 - PSAPTESTD          2  /oracle/GC2/sapdata6/testd_1/testd.data1

  10 - PSAPTESTD         12  /oracle/GC2/sapdata6/testd_2/testd.data2

  11 - PSAPTESTI         11  /oracle/GC2/sapdata5/testi_1/testi.data1

.....

  18 -                    0  /oracle/GC2/sapbackup/cntrlGC2.dbf

  19 - archive_log           /oracle/GC2/saparch/1_8.dbf

  20 - archive_log           /oracle/GC2/saparch/1_9.dbf

 

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

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

BR0662I Enter your selection:

BR0280I Time stamp 2003-01-29 19.05.36

BR0663I Your selection: '9-11'

 

BR0280I Time stamp 2003-01-29 19.05.36

BR0657I Input menu 123 - please check/enter input values

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

BRRESTORE main options for restore from BRBACKUP backup

 

 1 - BRRESTORE profile (profile) ........ [initGC2.sap]

 2 - BRBACKUP backup run (backup) ....... [bdjwgvvh.fnf]

 3 - Fill-up previous restores (fillup) . [no]

 4 - Restore device type (device) ....... [util_file]

 5 - BACKINT/Mount profile (parfile) .... [initGC2.utl]

 6 # Database user/password (user) ...... [system/*******]

 7 ~ Restore destination (rest_dest) .... []

 8 - Files for restore (mode) ........... [2,11-12]

 

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

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

BR0662I Enter your choice:

BR0280I Time stamp 2003-01-29 19.05.37

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0280I Time stamp 2003-01-29 19.05.37

BR0657I Input menu 124 - please check/enter input values

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

Additional BRRESTORE options for restore from BRBACKUP backup

 

 1 - Confirmation mode (confirm) ...... [yes]

 2 - Query mode (query) ............... [no]

 3 # Compression mode (compress) ...... [no]

 4 # Parallel execution (execute) ..... [0]

 5 - Additional output (output) ....... [no]

 6 - Message language (language) ...... [E]

 7 - BRRESTORE command line (command) . [-p initGC2.sap -b bdjwgvvh.fnf -d util_file -r /oracle/GC2/dbs/initGC2.utl -m 2,11-12 -l E]

 

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

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

BR0662I Enter your choice:

BR0280I Time stamp 2003-01-29 19.05.39

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0342I Database instance GC2 is open

BR0064I Database instance GC2 will be shut down now

.....

 

BR291I BRRESTORE will be started with options '-p initGC2.sap -b bdjwgvvh.fnf -d util_file -r /oracle/GC2/dbs/initGC2.utl -m 2,11-12 -l E'

 

BR0280I Time stamp 2003-01-29 19.05.49

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

BR0280I Time stamp 2003-01-29 19.06.04

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

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

BR401I BRRESTORE 6.40 (0)

BR405I Start of file restore: rdjwhkwq.rsb 2003-01-29 19.06.04

 

BR0428W File /oracle/GC2/sapdata6/testd_1/testd.data1 will be overwritten

BR0428W File /oracle/GC2/sapdata6/testd_2/testd.data2 will be overwritten

BR0428W File /oracle/GC2/sapdata5/testi_1/testi.data1 will be overwritten

BR0280I Time stamp 2003-01-29 19.06.04

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel the program:

BR0280I Time stamp 2003-01-29 19.06.05

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

.....

 

BR0280I Time stamp 2003-01-29 19.06.06

BR0229I Calling backup utility...

 

BR0280I Time stamp 2003-01-29 19.08.04

#FILE..... /oracle/GC2/sapdata6/testd_2/testd.data2

#RESTORED. 1043853566

 

BR0280I Time stamp 2003-01-29 19.08.04

#FILE..... /oracle/GC2/sapdata6/testd_1/testd.data1

#RESTORED. 1043853582

 

BR0280I Time stamp 2003-01-29 19.08.04

#FILE..... /oracle/GC2/sapdata5/testi_1/testi.data1

#RESTORED. 1043853591

 

BR0280I Time stamp 2003-01-29 19.08.04

BR0374I 3 of 3 files restored by backup utility

BR0230I Backup utility called successfully

 

BR0406I End of file restore: rdjwhkwq.rsb 2003-01-29 19.08.04

BR0280I Time stamp 2003-01-29 19.08.04

BR0403I BRRESTORE terminated successfully with warnings

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