Restoring Data Files

You use this procedure when using BRRECOVER to perform:

This procedure calls BRRESTORE to restore files as follows:

Type of Recovery	What is Restored
Complete database recovery	Data files that BRRECOVER identified as missing in Checking the Status of Database Files
Database PIT recovery and whole database reset	All data files
Tablespace PIT recovery	Data files of the selected tablespaces plus the data files for the system and undo tablespaces
Restore individual backup files	For Restore files from BRBACKUP backup: Selected data files For Apply incremental backup: Incremental backup save set

Prerequisites

BRRECOVER repeats this phase as required to restore all required files.
BRRECOVER avoids duplicate restores by logging which files it has already restored.

See Example below for the contents of the log file.

Procedure

Set the required options:

Menu Entry	Equivalent BRRESTORE Command Option
BRRESTORE profile (profile)	-p\|-profile
BRBACKUP run (backup)	-b\|-backup\|b1\|backup1
Fill-up previous restores (fillup)	-f\|-fillup
Restore device type (device)	-d\|-device
BACKINT/Mount profile (parfile)	-r\|-parfile
Database user/password (user)	-u\|-user
Restore destination (rest_dest)	Only for restore individual backup files, option Restore files from BRBACKUP backup: -m\|-mode = <rest_dest>
Files for restore (mode)	B1-4 Complete database recovery: -m\|-mode <file_ID1>-<file_ID2> Database PIT recovery or whole database reset: -m\|-mode all Tablespace PIT recovery: -m\|-mode <tablespace_list> Restore individual backup files: Restore files from BRBACKUP backup: -m\|-mode <file_ID1>-<file_ID2> Apply incremental backup: -m\|-mode incr
Confirmation mode (confirm)	-c\|-confirm
Query mode (query)	-q\|-query
Compression mode (compress)	-k\|-compress
Parallel execution (execute)	-e\|-execute
Additional output (output)	-o\|-output
Message language (language)	-l\|-language
BRRESTORE command line (command)	This shows you the BRRESTORE command that is to be executed using the current settings.

Note Note

Restore device type (device) is taken from the device type used for the selected backup.

Files for restore (mode) refers to the Oracle file ID, a tablespace, or a keyword such as incr or all. The files for restore can vary, as described in the table above at the start of this procedure.

End of the note.

To start the restore with the selected options, choose Continue.
Check the results in the BRRESTORE logs:
- The summary log rest<DBSID>.log displays the return code.
- The detail log r<encoded timestamp>.rsb 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 this procedure when executed as part of a complete database recovery:

Note Note

This example shows files 9 and 10 to be restored. However, the files for restore can vary, as described in the table above at the start of this procedure.

End of the note.

BRRESTORE main options for restore of database files

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

2 - BRBACKUP backup run (backup) ....... [bdjwhckx.ffd]

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

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

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

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

7 - Files for restore (mode) ........... [9-10]

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

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

BR0280I Time stamp 2003-01-29 19.12.43

BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont'

BR0280I Time stamp 2003-01-29 19.12.43

BR0657I Input menu 112 # please check/enter input values

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

Additional BRRESTORE options for restore of database files

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

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 bdjwhckx.ffd -d disk -m 9-10 -c force -k no -e 0 -l E]

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

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

BR0280I Time stamp 2003-01-29 19.12.43

BR0134I Unattended mode with 'force' active - continuing processing with default reply 'cont'

BR0291I BRRESTORE will be started with options '-p initGC2.sap -b bdjwhckx.ffd -d disk -m 9-10 -c force -k no -e 0 -l E'

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

BR0401I BRRESTORE 6.40 (0)

BR0405I Start of file restore: rdjwhlma.rsb 2003-01-29 19.12.44

BR0457I Probably the database must be recovered due to partial restore

BR0280I Time stamp 2003-01-29 19.12.44

BR0407I Restore of database: GC2

BR0408I BRRESTORE action ID: rdjwhlma

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: PARTIAL

BR0411I Database files for restore:

/oracle/GC2/sapdata5/stabd_1/stabd.data1

/oracle/GC2/sapdata6/stabi_1/stabi.data1

BR0419I Files will be restored from backup: bdjwhckx.ffd 2003-01-29 17.30.51

BR0416I 2 files found to restore, total size 12.016 MB

BR0424I Files will not be decompressed

BR0421I Restore device type: disk

BR0420I Files will be restored from directory: /sapmnt/uw1030/b/backup/bdjwhckx

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0351I Restoring /oracle/GC2/sapdata5/stabd_1/stabd.data1

BR0355I from /sapmnt/uw1030/b/backup/bdjwhckx/stabd.data1 ...

#FILE..... /oracle/GC2/sapdata5/stabd_1/stabd.data1

#RESTORED. /sapmnt/uw1030/b/backup/bdjwhckx/stabd.data1 #2/5

BR0280I Time stamp 2003-01-29 19.12.46

BR0418I 1 of 2 files restored - 8.008 MB of 12.016 MB done

BR0204I Percentage done: 66.64%, estimated end time: 19:12

BR0001I *********************************_________________

BR0351I Restoring /oracle/GC2/sapdata6/stabi_1/stabi.data1

BR0355I from /sapmnt/uw1030/b/backup/bdjwhckx/stabi.data1 ...

#FILE..... /oracle/GC2/sapdata6/stabi_1/stabi.data1

#RESTORED. /sapmnt/uw1030/b/backup/bdjwhckx/stabi.data1 #2/11

BR0280I Time stamp 2003-01-29 19.12.46

BR0418I 2 of 2 files restored - 12.016 MB of 12.016 MB done

BR0204I Percentage done: 100.00%, estimated end time: 19:12

BR0001I **************************************************

BR0406I End of file restore: rdjwhlma.rsb 2003-01-29 19.12.46

BR0280I Time stamp 2003-01-29 19.12.46

BR0402I BRRESTORE terminated successfully

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

BR0292I Execution of BRRESTORE terminated with return code 0