Managing an Active Standby Pair
with TimesTen In-Memory Database and Clusterware

This tutorial will make use of the pre-defined DSN repdb1_1122 shipped with TimesTen 11.2.2. The hostnames of the two machines in the examples are ttcwnode1 and ttcwnode2. The active database is in ttcwnode1 and the standby database is in ttcwnode2.

The following tasks are the most common management tasks once the active standby pair has been created by ttCWAdmin:

1. Check the cluster agents' status

  1. Check the TimesTen cluster agents by executing the ttCWAdmin -status command on any one of the hosts. For example, on ttcwnode1:

    ttCWAdmin -status -dsn repdb1_1122

    ttCWAdmin -status after start


2. Stop the Active Standby Pair

  1. Stop the Active Standby Pair by executing the ttCWAdmin -stop command on any one of the hosts. For example, on ttcwnode1:

    ttCWAdmin -stop -dsn repdb1_1122

    ttCWAdmin -stop


  2. Check the cluster status after doing ttCWAdmin -stop. For example, on ttcwnode2:

    ttcwadmin -status -dsn repdb1_1122

    ttCWAdmin -status after stop


3. Drop the Active Standby Pair

  1. Drop the Active Standby Pair by executing the ttCWAdmin -drop command on any one of the hosts. For example, on ttcwnode1:

    ttcwadmin -drop -dsn repdb1_1122

    ttCWAdmin -drop


  2. Check the cluster status after doing ttCWAdmin -drop. For example, on ttcwnode2:

    ttcwadmin -status -dsn repdb1_1122

    ttCWAdmin -status after drop


4. Shutdown the cluster agents

  1. Shutdown the cluster agents by executing the ttCWAdmin -shutdown command on any one of the hosts. For example, on ttcwnode1:

    ttcwadmin -shutdown

    ttCWAdmin -shutdown


  2. Check the cluster status after doing ttCWAdmin -shutdown. For example, on ttcwnode2:

    ttcwadmin -status -dsn repdb1_1122

    ttCWAdmin -status after shutdown

    The ttCWAdmin -status command succeeds as it is querying Oracle Clusterware, which is still running.