Special Features of BRRESTORE (SAP Library - Database Administration (Oracle) with SAPDBA)

Special Features of BRRESTORE

BRRESTORE uses the dd command to restore files that were saved on a volume (tape, hard disk,...) with this command. You should therefore make sure that the init<DBSID>.sap parameter dd_in_flags is set accordingly. See Supporting the Raw Device Configuration with BRBACKUP and BRRESTORE.

BRRESTORE for Restoring Database Files

There are no special features of BRRESTORE concerning the functionality of the utility programs.

BRRESTORE for Restoring the Archived Offline Redo Log Files

Distributed Scenario: BRRESTORE must be started on every ORACLE instance in order to restore the corresponding archived redo log files into the local archiving directory. If required, the restored redo log files can be copied onto the DDB instance using operating system resources or be made available via several NFS-mounts. (This is necessary, for example, if a SQLDBA recovery session is to be started, which is normally done on the DDB instance). See also "Further Remarks " in Distributed Scenario.

Central and Mixed Scenario: The required archived redo log files of all ORACLE instances can be restored with one BRRESTORE call. To do this, the syntax of BRRESTORE was extended with the options -a|-a1|-a2 to specify the instance ID <DBSID> . See -a|-archive|a1|archive1 or -a2|-archive2. See also "Further Remarks " in Central Scenario and Mixed Scenario.

brrestore -a 110-120,C11_002,70-80,C11_003,85-95

The archived offline redo log files with log sequence numbers 110-120 of the local ORACLE instance, those with log sequence numbers 70-80 of ORACLE instance C11_002 and those with log sequence numbers 85-95 of instance C11_003 are restored.