Whole Database Reset with BR*Tools

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

• 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.

1. You start BRGUI or BRTOOLS.

2. You choose  Restore and recovery  Whole database reset .

   You can do one of the following:

   • Set the command line now and run the reset in unattended mode

   • Wait for BRRECOVER to prompt you during the reset, that is, run the reset in attended mode

     Recommendation

     We recommend you to normally run the reset in attended mode.

     If you are sure of the required entries - for example, for a routine database copy - you can run the reset in unattended mode.

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

4. To start the reset, you choose Continue.

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

   Note

   If you are running in attended mode, BRRECOVER guides you through the reset, prompting you as necessary.

5. You select a consistent database backup or a restore point.

6. You check the status of the database files.

   If you are using a restore point, continue with step 11 below.

7. You restore the control files and the redo log files. You only restore the online redo log files if you selected a consistent offline backup.

8. You restore data files.

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

10. You restore and apply the offline redo log - that is, archivelog - files. You only restore the offline redo log files if you selected a consistent online backup.

11. You restore and apply the offline redo log - that is, archivelog - files and flash back to the restore point.

12. You open the database.

13. 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>.drs 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.