You can use BR*Tools for Oracle to perform a tablespace point-in-time (PIT) recovery. BRRECOVER performs the recovery.
This section discusses how to perform a tablespace PIT recovery.
For more information on how to approach a tablespace PIT recovery, see Tablespace Point-in-Time Recovery.
Tablespace PIT recovery is especially useful for Multiple Components in One Database (MCOD). It allows you to restore the tablespaces for a single component - for example, if a component upgrade has failed - without affecting the other components in the same database.
Make sure you have set the necessary BRRECOVER parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRRECOVER.
BRRECOVER calls BRRESTORE as necessary to perform restore functions.
BRRECOVER calls SQLPLUS as necessary to apply offline redo log files.
BRRECOVER calls the Oracle EXP/EXPDP and IMP/IMPDP tools to export and import the tablespaces that are not to be recovered.
To start this procedure, you must be able to open the database.
BRRECOVER opens the database in RESTRICT mode - that is, only the database administrator (DBA) can access the database. For SAP systems, including all other components installed in the same database, the database is unavailable.
BRRECOVER always recovers the SYSTEM and UNDO tablespaces in addition to the tablespaces that you select.
You start BRGUI or BRTOOLS.
You choose
.You can do one of the following:
Set the command line now and run the recovery in unattended mode
Wait for BRRECOVER to prompt you during the recovery, that is, run the recovery in attended mode
We recommend you to normally run the recovery in attended mode.
If you want to run the recovery in unattended mode, you select force in Confirmation mode (confirm).
To start the recovery, you choose Continue.
BRRECOVER starts the recovery. You perform the following steps with BRRECOVER.
If you are running in attended mode, BRRECOVER guides you through the recovery, prompting you as necessary.
You export the tablespaces that are not required for the recovery.
If required, you restore and apply an incremental backup.
You restore and apply the online redo log - that is, archivelog - files
You open the database and plug in the previously exported tablespaces.
You check the results in the BRRECOVER and BRRESTORE logs:
The summary log recov<DBSID>.log displays the return code.
The detail log v<encoded timestamp>.rsa displays the progress.
BRRESTORE logs for the restore functions:
The summary log rest<DBSID>.log displays the return code
The detail log r<encoded timestamp>.<ext> displays the progress.
For more information about how to view the logs, see Showing Profiles and Logs with BR*Tools.