Database Point-In-Time Recovery with BR*Tools

You can use BR*Tools for Oracle to perform a database point-in-time (PIT) recovery. BRRECOVER performs the recovery.

Note Note

This section discusses how to perform a database PIT recovery.

For more information on how to approach a database PIT recovery, see Database Point-In-Time Recovery.

End of the note.

Prerequisites

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.

Process

You start BRGUI or BRTOOLS.
You choose Restore and recovery Database point-in-time recovery .
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
  
  Recommendation
  
  We recommend you to normally run the recovery in attended mode.
  
  If you are sure of the required entries – for example, for a routine database copy – you can run the recovery in unattended mode.
  
  End of the recommendation.
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:

Note

If you are using attended mode, BRRECOVER guides you through the recovery, prompting you as necessary.

End of the note.
You set a point in time for the recovery.
You select database backups or flashback.
You check the status of the database files.
If you are using flashback database, continue with step 13 below.
If required, you restore the control files.
You restore data files.
If required, you restore split incremental control files.
If required, you restore and apply an incremental backup.
You restore and apply the offline redo log – that is, archivelog – files
You restore the offline redo log – that is, archivelog – files and perform the flashback database.
You open the database.
You check the results in the BRRECOVER and BRRESTORE logs:
- BRRECOVER logs:
  - The summary log recov<DBSID>.log displays the return code.
  - The detail log v<encoded timestamp>.dpt 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 on how to view the logs, see Showing Profiles and Logs with BR*Tools.