Restore of Individual Backup Files with BR*Tools (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

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.

Caution

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.

Note

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:

Note

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...