Starting the Standby Instance as an Active Instance 

Use

You can always turn the standby instance into a new active instance.

To do this, you back up the log area of the original instance and import this log backup into the standby instance. If a problem with the original instance has made it impossible to execute a final log backup, there are other ways to copy the most recent log entries of the original instance to the standby instance (see: Database Administration Tutorial, Copying the log volumes with Operating System Commands)

Finally, you transfer the standby instance to the ONLINE operational state and load the system tables. If necessary, you can update indexes that are not current (BAD INDEXES) now or at a later date.

You perform a complete data backup and have thereby make it possible to store the new log entries.

See also:

Standby Database

Database Administration Tutorial, Starting a Standby Instance as the Active Instance

Prerequisites

●     You have set up a standby instance.

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

Procedure

Use the Database Manager for the following steps:

...

       1.      Perform a closing log backup in the original instance.

See:

○     Database Manager GUI: Backup Wizard

○     Database Manager CLI: backup_start

       2.      Import all the log backups from the original instance that have not been imported yet into the standby instance.

See:

○     Database Manager GUI: Recovery Wizard

○     Database Manager CLI: recover_start

       3.      Transfer the standby instance to the ONLINE operational state.

See:

○     Database Manager GUI: Starting the Database Instance

○     Database Manager CLI: db_online

       4.      Load the system tables.

See:

○     Database Manager GUI: Updating the System Tables

○     Database Manager CLI: load_systab

       5.      Update all the indexes in the standby instance if necessary (BAD INDEXES).

See:

○     Database Manager GUI: Restoring Indexes After Database Restore

○     Database Manager CLI: sql_recreateindex.

       6.      Create a complete data backup of the standby instance.

See:

○     Database Manager GUI: Backup Wizard

○     Database Manager CLI: backup_start

Result

You can now operate the former standby instance as the active instance and back up the log entries.

To make the old original instance the new standby instance, initialize the old original instance and then proceed as described in Setting Up a Standby Instance.