Dropping an Active Standby Pair Configuration

To remove an existing active standby pair configuration, you must stop the replication agents and drop the active standby pair replication scheme on each database.

This tutorial uses the pre-defined DSNs repdb1_1122 and repdb2_1122 shipped with TimesTen 11.2.2. The hostnames of the two machines are tthost1 and tthost2. repdb2_1122 is the current active database on tthost2, and repdb1_1122 on tthost1 is the standby database.

1. Stop the Replication Agent

  1. On tthost1, use ttIsql to connect to repdb1_1122 as the replication administrator adm.


    connect "dsn=repdb1_1122;uid=adm";

  2. Use the built-in procedure ttRepStop to stop the replication agent.

    call ttrepstop;

  3. Repeat the above steps for repdb2_1122 on tthost2.

2. Remove the Active Standby Scheme

  1. On tthost1, connect to the repdb1_1122 database and remove the active standby pair schema by using the DROP ACTIVE STANDBY PAIR statement. Use the ttIsql command repschemes to verify that the replication scheme has been removed.

    drop active standby pair;

  2. Repeat the above step for repdb2_1122 on tthost2.

3. Destroy the Standby Database

  1. Log in to tthost1 as the instance administrator. Use the ttDestroy utility to remove the redundant standby database repdb1_1122.

    ttdestroy repdb1_1122

For more information on Altering replication and Dropping a replication scheme refer to the documentation here