Show TOC

Function documentationRestore and Recovery with BR*Tools Locate this document in the navigation structure

 

You can restore and recover your Oracle database with BR*Tools.

This section discusses how to perform restore and recovery.

For more information on the approach to restore and recovery, see Restore and Recovery.

Integration

  • BRTOOLS calls the SAP tool BRRECOVER. You can also perform restore and recovery with SQLPLUS, but only if you are an expert.

  • Make sure that you have set the necessary parameters for BRRECOVER in the Initialization Profile init<DBSID>.sap.

  • You have to have SYSDBA privilege to let BRRECOVER connect to the database. This means that you have to log on as ora<sid> (UNIX) or <sid>adm (Windows).

  • The recovery is normally attended, that is, you have to enter parameters as the recovery runs, when prompted by BRRECOVER.

Features

You can perform the following restore and recovery functions with BR*Tools:

  • Complete database recovery

  • Database point-in-time (PIT) recovery

  • Tablespace point-in-time (PIT) recovery

  • Whole database reset

  • Restore of individual backup files

  • Restore and application of archivelog (that is, offline redo log) files

  • Disaster recovery

Activities

  1. You call the restore and recovery function in BRTOOLS and check the displayed parameters, changing them as required.

    The default parameter values, which are set in the initialization profile init<DBSID>.sap, are as follows:

    • Recovery type is complete database recovery.

    • Serial recovery for applying offline redo logs, using the Oracle default settings

    • Interval of 30 days for the displayed backups to be restored. This me ans that only backups from the last 30 days can be selected by default.

    • Scrolling of 20 lines for the list menus, only relevant for character-mode menus

      Note Note

      BRTOOLS only lets you change certain parameters for the backup. If you have to make other changes, you must change the init<DBSID>.sap profile manually and then restart BRTOOLS.

      End of the note.
  2. If required, you change the default values for the restore and recovery parameters in the initialization profile init<DBSID>.sap and restart BRTOOLS.

  3. If required, you choose   Restore and recovery   Reset program status   to set the defaults used to the values in the initialization profile init<DBSID>.sap. For certain input values, there is no corresponding parameter in the initialization profile, in which case the default value from the BRTOOLS program is used.

  4. You start the restore or recovery.

    BRRECOVER takes you through the recovery step by step, displaying sub-menus as required.

  5. You check the results in the BRRECOVER logs.