Making the Standby Database the Active Database

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

In the original database, perform a log backup (if still possible).
More information:
- Database Studio, Backing up Log Entries
- Database Administration in CCMS, Scheduling Log Backups
In the standby database, import all the log backups from the original database that have not been imported yet.
More information:
- Database Studio, Restoring Databases
Start the standby database.
More information:
- Database Studio, Starting or Stopping Databases
Update the system tables.
More information:
- Database Studio, Updating System Tables
If necessary, recreate any damaged indexes.
More information:
- Database Studio, Recreating Damaged Indexes
- Database Manager CLI, sql_recreateindex
Make a complete data backup of the standby database.
More information:

Database Studio, Backing Up Data

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.