RAC with BRRESTORE and BRRECOVER

Use

This section describes how to set up the Oracle Real Application Cluster (RAC) with BRRESTORE and BRRECOVER.

Prerequisites

If the database uses raw devices, BRRESTORE uses the dd command to restore files that were saved on a volume (tape, hard disk, and so on) with this command. Therefore, make sure that the init<DBSID>.sap parameters dd_flags and dd_in_flags are set accordingly.

Activities

BRRESTORE for Restoring Database Files

There are no special BRRESTORE features to restore database files on RAC.

BRRESTORE for Restoring the Archived Offline Redo Log Files

You can restore the required archived redo log files of all Oracle instances with one BRRESTORE call.

You must have the necessary archived offline redo log files in order to recover the database. For more information, see RAC with BRARCHIVE.

The BRRESTORE options -a|-a1|-a2 let you specify the instance name <DBSID>. For more information, see:

·        -a|-archive|a1|archive1

·        RAC with BRARCHIVE

brrestore -a 110-120,RAC002,70-80,RAC003,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 RAC002 and those with log sequence numbers 85-95 of instance RAC003 are restored.

BRRECOVER for Recovering the Database

We recommend that only an experienced database administrator, familiar with RAC, performs recovery.

You normally perform restore and recovery from the dedicated database (DDB) instance. Other database instances are normally stopped at this time. BRRECOVER manages the restore and recovery of the RAC database by controlling the applying of the offline redo log files of all threads, that is, the files that have been generated by the different instances.

For more information, see Restore and Recovery with BR*Tools.