Show TOC

Process documentationComplete Database Recovery with BR*Tools Locate this document in the navigation structure

 

You can use BR*Tools for Oracle to perform a complete database recovery. BRRECOVER performs the recovery.

Note Note

This section discusses how to perform a complete database recovery.

For more information about how to approach a complete database recovery, see Complete Database 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

  1. You start BRGUI or BRTOOLS.

  2. You choose   Restore and recovery   Complete database recovery  .

    You can do one of the following:

    • Set the required entries 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 Recommendation

    We recommend you to run the recovery in attended mode.

    End of the recommendation.

  3. If you want to run the recovery in unattended mode, you select force in Confirmation mode (confirm).

  4. To start the recovery, you choose Continue.

    BRRECOVER starts the recovery. You perform the following steps with BRRECOVER.

    Note Note

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

    End of the note.

  5. You check the status of the database files.

  6. You select database backups.

  7. You restore data files.

  8. If required, you restore and apply an incremental backup.

  9. You restore and apply the online redo log – that is, archivelog – files.

  10. You open the database.

  11. You check the results in the BRRECOVER and BRRESTORE logs:

    For more information about how to view the logs, see Showing Logs with BR*Tools.