Procedure documentationMaking the Standby Database the Active Database Locate this document in the navigation structure

Prerequisites

  • You have set up a standby database.

    More information: Standby Database

  • The standby database has not been in the ONLINE operational state since it was last initialized.

Procedure

  1. In the original database, perform a log backup (if still possible).

    More information:

    If you have problems with the original database and can no longer perform log backups, there are other ways to copy the most recent log entries for the original database into the standby database.

    More information: Database Manager CLI Tutorial, Copying Log Volumes with Operating System Commands and Starting a Standby Database as the Active Database

  2. In the standby database, import all the log backups from the original database that have not been imported yet.

    More information:

  3. Start the standby database.

    More information:

  4. Update the system tables.

    More information:

  5. If necessary, restore any damaged indexes.

    More information:

  6. Make a complete data backup of the standby database.

    More information:

Result

You can now use the former standby database as your active database.

To turn the old original database into a new standby database, initialize the old original database and then proceed as described in Standby Database.

More Information

Database Manager CLI Tutorial, Starting a Standby Database as the Active Database