Show TOC

Opening the DatabaseLocate this document in the navigation structure

Prerequisites

  • BRRECOVER:

    • Checks tablespaces and, if offline, recommends you to switch them online

    • Checks data files and warns you if they are not online

  • BRRECOVER deletes files that were added after the selected backup (for whole database reset) or the PIT (for database or tablespace PIT). It identified these during the database status check or selection of database backups. This does not apply to complete database recovery.

  • The resetlogs parameter to open the database is relevant for the following types of recovery:

    • Database PIT

    • Tablespace PIT

    • Whole database reset if the selected backup was online

    • Restore and application of offline redo log files

      Note

      Resetlogs reformats the online redo log files and resets their sequence number to 1. In addition, it updates the control files to reflect a new incarnation of the database.

  • For tablespace PIT recovery, BRRECOVER reinstates the tablespaces that were exported because they were not required for the recovery. To do this, BRRECOVER does the following after it has reopened the database:

    • It temporarily drops the affected tablespaces.

    • It calls the Oracle IMP or IMPDP tool to import the affected tablespaces (to be precise, it imports the metadata of these tablespaces).

    • It sets the affected tablespaces to READ-WRITE status.

Context

You use this procedure when using BRRECOVER to perform:

This procedure opens the database.

For tablespace PIT recovery, it also plugs in the exported tablespaces.

Procedure


  1. Select the required option for Reset logs option (reset_logs).

    Recommendation

    Unless you are an expert, we recommend you to accept the setting that BRRECOVER proposes.

    If the resetlogs option is set, BRRECOVER warns you that no more logs can be applied after the database has been opened. Normally you can ignore this warning.

  2. Choose Yes to continue opening the database.

    BRRECOVER opens the database.

    BRRECOVER recreates the missing temporary database files.

    BRRECOVER then checks the tablespaces and data files, the redo log files, and the control files.

    For a PIT recovery and whole database reset, BRRECOVER deletes files that are no longer used by the database.

    For a tablespace PIT recovery, BRRECOVER reinstates the tablespaces that were exported as described at the end of Prerequisites above.

    If successful, BRRECOVER displays a message like the following, depending on the type of recovery:

    Database point-in-time recovery completed.

  3. Check the results in the BRRECOVER detail log, v<encoded timestamp>.<ext>.

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