Restoring Data Files

Use

You use this procedure when using BRRECOVER to perform:

·        Complete database recovery

·        Database point-in-time (PIT) recovery

·        Tablespace point-in-time (PIT) recovery

·        Whole database reset

·        Restore of individual backup files

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

...

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

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

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.

       2.      To start the restore with the selected options, choose Continue.

       3.      Check the results in the BRRESTORE logs:

Ў        The summary log rest<DBSID>.log displays the return code.

Ў        The detail log r<encoded timestamp>.<ext> 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:

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.

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