Using BRRESTORE (SAP Library - Database Administration (Oracle) with SAPDBA)

Using BRRESTORE

This SAP utility enables you to restore an entire database backup or parts of it, when the backup was performed with BRBACKUP. Any non-database files and directories you saved can also be restored. In the process, the subdirectories in sapdata<n> directories are automatically created, when necessary.

You can also restore the offline redo log files that were archived with BRARCHIVE. This operation can be performed at the same time as the restore of the corresponding backup.

BRRESTORE can not run unattended. The option -c only suppresses the first confirmation prompts for mounting a volume.

BRRESTORE uses the BRBACKUP logs and the summary log from BRARCHIVE to decide where to restore the requested file. You can manually specify a different directory as well.

One or more incomplete BRRESTORE runs can be completed with the option -f . BRRESTORE automatically determines the files to be restored.

BRRESTORE only restores the selected backup; it does not recover the database. To do this, start the recovery afterwards using the SAP utility SAPDBA (see SAPDBA Database Recovery) or with the ORACLE utility SVRMGR (see Recovery with SVRMGR).

Restoring Files

Examples

Logging