Restoring Files (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Restoring Files

BRRESTORE can be called directly from the operating system command level. A list of the command options can be found in the sections Command Options for BRRESTORE.

BRRESTORE also requires several parameters to be configured in the initialization profile init<DBSID>.sap.

The options -d, -k, -m, and -r can be preset using the appropriate BRRESTORE profile parameters. See Effects of the Command Options.

Only one of the options -a, -b, or -n can be set. If you do not select any of these options, -b last is selected.

However, BRRESTORE can be started with option -a in parallel to BRRESTORE with option -b or -n.

BRRESTORE can restore a database in parallel. BRRESTORE can also restore archived redo log files in parallel if they are located on several volumes. In both cases, several tape devices must be available, and the number of parallel copy processes must correspond to the number of tape devices. This is the standard setting with exec_parallel.

To restore a complete backup (reset the database), use the option -m full.

The key word all can be combined with other options in an <object list> (for example, non-database files or directories). However, database files and non-database files are restored separately from each other, if they were backed up in separate backup runs, as recommended.

Non-database files and directories must be defined with their complete path. Single files from the backed up directory can also be restored.

Database data files can be defined with either a full or generic path. A generic path must contain the directory SAPDATA_HOME and a generic specification (e.g. sapdata<n> directory).

All the file IDs used in a specified interval <file_ID1>-<file_ID2> must be known in the database.

Online redo log files can only be addressed directly by using the redo log group numbers with an additional leading zero (0<n>). To address all the online redo log files, specify file ID 00.

The control file can only be addressed directly by using file ID 0.

When you start the restore of online redo log files or the control file, the mirror copies of these files are automatically recreated.

Archived offline redo log files can be addressed using their log sequence numbers.