Call options of BRRESTORE
-------------------------
You can restore an entire database backup or parts of it starting from an off-line or online BRBACKUP backup with
BRRESTORE, including the non-database files and directories that were saved. The subdirectories in sapdata
directories are automatically created if they do not exist. The redo log files archived with BRARCHIVE can also be restored
(possibly at the same time as the database restore).
BRRESTORE supports the following call options:
[-a|-archive|-a1|-archive1 <log_no>[=<rest_dir>]|<log_no1>-<log_no2>
[=<rest_dir>]|<log_no_list>]
<log_no>,<log_no1>-<log_no2> - log sequence numbers of the redo log
files that are to be restored from the first copies of the off-line redo log files.
<rest_dir> - restore directory into which the redo log files are to be restored, otherwise the original directory is used.
[-a2|-archive2 <log_no>[=<rest_dir>]|<log_no1>-<log_no2>
[=<rest_dir>]|<log_no_list>]
<log_no>,<log_no1>-<log_no2> - log sequence numbers of the redo log
files that are to be restored from the second copies of the off-line redo log files.
<rest_dir> - restore directory into which the redo log files are to be restored, otherwise the original directory is used.
[-b|-backup <log_name>|last] <log_name> - name of the BRBACKUP log file that is used for the
database restore, "last" - last successful backup Default: last.
[-c|-confirm] unattended mode - in contrast to BRBACKUP/BRARCHIVE only mount tape 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 the restore. Default: tape.
[-h|-help [version]] Help information about BRRESTORE options (version of BRRESTORE).
[-k|-compress [no|yes|hardware]] Compression type - if software compression was switched on during
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 output, "D" - German, "E" - English. Default: E.
[-m|-mode all|full|<tablespace_name>[=<rest_dir>]|<file_ID>
[=<rest_dir>]|<file_ID1>-<file_ID2>[=<rest_dir>]
|<generic_path>|<object_list> List of the objects (tablespaces, database files, non-database files
or directories) which are restored. "all" restores all the tablespaces, without control files or online redo log files.
"full" restores the entire backup, including non-database files, directories, control files or online redo log files.
<file_ID> refers to the ORACLE file ID for data files. File ID 0 identifies the control file.
IDs with leading zeros identify the online redo log files. If <generic_path> is a full path name, then a database file, a
non-database file or a directory is restored, otherwise <generic_path> must contain at least the ORACLE home directory.
In this case, all the database DATA files whose name starts with this path are selected.
<rest_dir> - restore directory into which the files are restored, otherwise the original directory is used.
<object_list> is a list of the tablespace/file specifications separated by commas. Default: all.
[-n|-number <file_pos>|init_ora|init_sap|reorg_log|det_log|sum_log]
With this option you can directly restore a file from the tape (without
specifying the log name of the backup or the log sequence number). Enter the position of the file on tape.
<file_pos> - position of the file on tape. init_ora - init<SID>.ora is restored, corresponds to position 2.
init_sap - init<SID>.sap is restored, corresponds to position 3.
reorg_log - reorg<SID>.log is restored, corresponds to the third-to-last position on tape det_log - the detailed
BRBACKUP/BRARCHIVE log is restored, corresponds to the next to last position on tape.
sum_log - the summary BRBACKUP/BRARCHIVE log is restored, corresponds to the last position on the tape.
[-o|-output dist|time[,time|dist]] Extended output in the detailed log. Default: normal output.
-o|-output dist - generates information on the distribution of the files on the volumes used (tape, hard disk).
-o|-output time - generates additional information on the time it takes to restore individual files.
[-p|-profile <profile>] BRRESTORE profile name. Default: init<SID>.sap.
[-q|-query [check]]
Query option - the restore process is not started. Only tape names and
other resources that are required for the restore are output. "check"
also checks whether the correct tapes were inserted into the tape units.
[-r|-parfile <parfile>]
Parameter file for an external backup program. Default: no parfile.
Notes:
- The options -d, -k, -m and -r can be preselected using the corresponding BRRESTORE profile parameters.
- Only one of the options -a, -b or -n may be set. If none are set, -b last is assumed.
- BRRESTORE with the option -a can be started in parallel to BRRESTORE with the option -b or -n.
- To restore a complete off-line backup (reset database), you must use the option -m full.
- The key word "all" can be combined with other specifications in an
<object_list> (for example, non-database files or directories).
- All the <file_ID>s used and all the file IDs occurring in the area
<file_ID1>-<file_ID2> must be recognized by the database.
- Non-database files and directories must be defined with their full path.
- Database data files can be defined with a full or generic path. The generic path must contain the ORACLE home directory and an
additional generic specification, for example, a sapdata directory.
- online redo log files can only be explicitly accessed with the redo
log group number which must also be provided with a leading zero.
- the ORACLE control file can only be explicitly accessed with file ID 0.
Examples:
brrestore -b last -m all
Restore all the tablespaces without the ORACLE control file and the online redo log files starting from the last successful backup.
brrestore -b bcnmhluz.aft -m full Restore all the files starting from backup bcnmhluz.aft, including
the ORACLE control files and online redo log files.
brrestore -m all,/usr/sap/C11/SYS/exe/run,/usr/sap/C11/SYS/profile
Restore all the tablespaces, SAP executables and profiles.
brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5
Restore all the 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 Restore all the 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 Restore the ORACLE control file.
brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5 Restore a database data file.
brrestore -a 200-220
Restore the archived redo log files into the archiving directory for the log sequence numbers from 200 to 220 inclusive
brrestore -a 40-70=/oracle/C11/sapbackup,71-90=/oracle/C11/sapreorg
Restore the archived redo log files with the log sequence numbers
from 40 to 70 inclusive into the directory /oracle/C11/sapbackup, and
the log sequence numbers from 71 to 90 inclusive into the directory /oracle/C11/sapreorg
New init<SID>.sap parameter
---------------------------
Three new init<SID>.sap parameters were introduced to support the restore of the database using SAPDBA:
cpio_in_flags - cpio options for importing the files from tape, default: -iduvB, example: cpio_in_flags = -iduvB
uncompress_cmd - decompression command, no default, example: uncompress_cmd = "uncompress -c $ > $"
tape_pos_cmd - command for positioning on tape, no default, example: tape_pos_cmd = "mt -t $ fsf $"
Adjusting the profile init<SID>.sap
Restore of the saved files.