SAP Note 14004 - Description of the call options for BRRESTORE

Symptom:

Parallel restoration of the database and archive logs

Other terms

BR*Tools

Reason and Prerequisites

Support for restoring the entire database
Support for parallel restoration from multiple tape drives
Support for restoration into other target directories

Solution
BRRESTORE is bundled directly in SAPDBA as of Version 3.0. The program, however, can also be used directly or interactively if you are using an older version of SAPDBA (< 3.0) or if the restore using SAPDBA is denied or fails for other reasons:

Call options of BRRESTORE
-----------------------------

With BRRESTORE, you can restore parts of, or an entire database backup from an offline or online BRBACKUP backup, including files unrelated to the database and directories of which a backup was made.
The subdirectories in sapdata directories are automatically created if they do not already exist.
You can also restore the Redo log files stored with BRARCHIVE (possibly at the same time as restoring the database).

BRRESTORE supports the following call options:

[-a|-archive|-a1|-archive1 [=]|-
[=]|]
,- - Log sequence number of Redo log files, which are to be restored from the first copies of the offline Redo log files.
- Restore directory into which the Redo log files are to be restored, otherwise the original directory is used.

[-a2|-archive2 [=]|-
[=]|]
,- - Log sequence number of Redo log files, which are to be restored from the second copies of the offline Redo log files.
- Restore directory into which the Redo log files are to be restored, otherwise the original directory is used.

[-b|-backup |last]
- Name of the BRBACKUP log file used for restoring the database, "last" - the last successful backup default: last.

[-c|-confirm]
Unsupervised mode - in contrast to BRBACKUP/BRARCHIVE, only tape mount confirmations are suppressed. All other BRRESTORE confirmation requests must be answered.

[-d|-device tape|tape_auto|disk|pipe|pipe_auto|util_file]
Device type for restoring. Default: tape.

[-h|-help [version]]
Help info about the BRRESTORE options (Version of BRRESTORE).

[-k|-compress [no|yes|hardware]]
Type of compression - if software compression was activated for the backup, you should use "yes". BRRESTORE does not differentiate internally between "no" and "hardware." Default: no.

[-l|-language D|E]
Language in which BRRESTORE messages are issued, "D" - German, "E" - English. Default: E.

[-m|-mode all|full|[=]|
[=]|-[=]

List of the objects (tablespaces, database files, files or directories not related to the database) to be restored.
"all" restores all the tablespaces without control files or online Redo log files.
"full" restores the entire backup including files not related to the database, directories, control files and online Redo log files.
refers to the Oracle file ID for data files. File ID 0 identifies the control file.
IDs with leading zeros - Online Redo log files.
If is a complete path name, one database file, one file not related to the database or one directory is restored, otherwise must at least include Oracle home.
In this case, the system selects all the database DATA files whose name starts with this path.

- Restore directory to which the files are restored, otherwise the original directory is used.
is a list of the tablespace/file specifications separated by commas.
Default: all.

[-n|-number |init_ora|init_sap|reorg_log|det_log|sum_log]
[=]
This option is only supported for:
backup_dev_type = tape | tape_auto | pipe | pipe_auto
You can use this option to restore a file directly from tape (without specifying the log name of the backup or the log sequence number).
Specify the position of the file on the tape.
- Position of the file on the tape.
init_ora - init.ora is restored, corresponds to position 2.
init_sap - init.sap is restored, corresponds to position 3.
reorg_log - reorg.log is restored. Corresponds to the third from last position on the tape det_log - the detailed BRBACKUP/BRARCHIVE log is restored. Corresponds to the second from last position on the tape.
sum_log - the summary BRBACKUP/BRARCHIVE log is restored, corresponds to the final position on the tape.
Caution:
Corresponds to the third from last position on the tape from which you called BRRESTORE. You can change this by explicitly entering a directory . For example, if you want to restore the detailed log of BRBACKUP, you can use the following calls:
brrestore -n det_log=/oracle/C11/sapbackup
or
cd /oracle/C11/sapbackup
brrestore -n det_log

[-o|-output dist|time[,time|dist]]
Extended output in the detailed log. Default: normal output.
-o|-output dist - generates information about the distribution of the files on the media used (tape/disk).
-o|-output time - generates additional information about the backup duration of the individual files.

[-p|-profile ]
BRRESTORE profile name.
Default: init.sap. [-q|-query [check]]
Query option - the restore process is not started. Only tape names and other resources that are necessary for the restore are issued. "Check" also checks whether the correct tapes have been placed in the tape drives.

[-r|-parfile ]
Parameter file for an external backup program.
Default: no parfile.

Comments:
------------
Options -d, -k, -m and -r can be preset by the corresponding BRRESTORE profile parameter.
Only one of the options -a, -b or -n may be set. If no setting is made, "-b last" is assumed.
BRRESTORE with option -a can be started in parallel to BRRESTORE with the options -b or -n.
To restore a complete offline backup (restore database), you must use the "-m full" option.
The keyword "all" can be combined with other specifications in an (for example, files not related to the database or directories).
All the s used and the file IDs occurring in the area - must be known to the database.
Files and directories not related to the database must be defined with a complete path.
Database data files can be defined with a complete or a generic path. The generic path must contain the Oracle home directory plus one additional generic specification, such as a sapdata directory. This specification is then regarded as a wildcard:
*
Online Redo log files can only be explicitly accessed with the group number of the Redo log files, which must also be provided with a leading zero.
The Oracle control file can only be explicitly accessed with the file ID 0.

Example:
----------

brrestore -b last -m all
Restoring all tablespaces without Oracle control files and online Redo log files from the last successful backup.

brrestore -b bcnmhluz.aft -m full
Restoring all files from the backup bcnmhluz.aft, including Oracle control files and online Redo logs files.

brrestore -m all,/usr/sap/C11/SYS/exe/run,/usr/sap/C11/SYS/profile
Restoring all tablespaces, SAP executables and profiles

brrestore -m /oracle/C11/sapdata1/=/oracle/C11/sapdata5
Restoring all database data files from the subdirectories of /oracle/C11/sapdata1 into the directory /oracle/C11/sapdata5.

brrestore -b last -m 1-10,01-04,0
Restoring all database data files with Oracle file IDs between 1 and 10 inclusive, the four online Redo log files and the control file.

brrestore -m 0
Restoring the Oracle control file.

brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5
Reloading a database data file.

brrestore -a 200-220
Restoring the archived Redo log files with log sequence numbers between 200 and 220 inclusive into the archive directory.

brrestore -a 40-70=/oracle/C11/sapbackup,71-90=/oracle/C11/sapreorg
Restoring archived Redo log files with log sequence numbers between 40 and 70 inclusive into the directory /oracle/C11/sapbackup, and log sequence numbers between 71 and 90 inclusive into the directory /oracle/C11/sapreorg.

New init.sap parameters
----------------------------

Three new init.sap parameters have been introduced to support the database restore by means of SAPDBA:

cpio_in_flags - cpio options for importing the files from tape
Default: -iuvB
Example:
cpio_in_flags = -iuvB

uncompress_cmd - command for decompression,
(no default)
Example:
uncompress_cmd = "uncompress -c $ > $"

tape_pos_cmd - Command for positioning on tape,
(no default)
Example:
tape_pos_cmd = "mt -f $ fsf $"

Keyword: BRRESTORE