Procedure documentationCopying Log Volumes with Operating System Commands and Starting a Standby Instance as the Active Instance Locate this document in the navigation structure

 

If you want to start a standby instance as the active instance, you must first update the standby instance to the most current status of the original 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 makes it impossible to execute a final log backup, but the log volumes of the original instance are still intact, you can use operating system commands to copy their contents to the volumes of the standby instance.

If you automatically import the log backups from the original instance into the standby instance, cancel this operation now (recover_cancel). You transfer the standby instance to the OFFLINE operational state and then copy the log volume of the original instance to the standby instance.

You can now use the standby instance as the active instance either with all the data of the original instance or with the data the original instance contained at some point in time.

Scenario

You have the database instance DEMODB and its standby instance TESTDB. The data volume of DEMODB has stopped working. The log volume of DEMODB is still intact. The log backups from DEMODB are automatically imported into TESTDB. You now want to make TESTDB the active instance with all the data available in DEMODB.

Prerequisites

  • You have set up a standby instance.

  • The standby instance has not yet been in the ONLINE operational state.

  • The log volumes of the original instance are not damaged.

  • The original instance is in the OFFLINE operational state.

Procedure

  1. Call the Database Manager CLI, log on as operator OLEG with the password MONDAY, and connect to the standby instance TESTDB:

    >dbmcli –u OLEG,MONDAY –d TESTDB

    dbmcli on TESTDB>

  2. If you automatically import the log backups from the original instance into the standby instance, cancel this operation now; otherwise continue with step 3:

    dbmcli on TESTDB>recover_cancel

    OK

  3. Transfer the standby instance to the OFFLINE operational state:

    dbmcli on TESTDB>db_offline

    OK

  4. Using operating system commands, copy the files of the log volume from DEMODB to the log volume of TESTDB.

  5. Restart the standby instance:

    dbmcli on TESTDB>db_restart

    OK

Result

The database instance TESTDB contains the complete dataset of DEMODB. It is in the ONLINE operational state and can be used as the active instance.

To ensure system security in case of a failure, we recommend that you now set up DEMODB as the standby instance for TESTDB and update it.

More Information

Setting Up and Updating Standby Instances

Database Manager CLI, recover_cancel, db_restart

Database Administration, Standby Database