Setting Up an Active Standby Pair With No Cache Groups

There are certain procedures you can run to set up an active standby pair.

See Configuring an Active Standby Pair With One Subscriber for an example.

Note:

If you intend to replicate read-only cache groups or asynchronous writethrough (AWT) cache groups, see Administering an Active Standby Pair With Cache Groups.

Before you create a database, see the information in these sections:

• Configuring the Network

• Connection Attributes for Replicated Databases

• Managing the Transaction Log on a Replicated Database

1. Create a database. See Managing TimesTen Databases in Oracle TimesTen In-Memory Database Operations Guide.

2. Create the replication scheme using the CREATE ACTIVE STANDBY PAIR statement. See Defining an Active Standby Pair Replication Scheme.

3. Call ttRepStateSet('ACTIVE') on the active database.

4. Start the replication agent. See Starting and Stopping the Replication Agents.

5. Create a user on the active database and grant the ADMIN privilege to the user.

6. Duplicate the active database to the standby database. See Duplicating a Database.

7. Start the replication agent on the standby database. See Starting and Stopping the Replication Agents.

8. Wait for the standby database to enter the STANDBY state. Use the ttRepStateGet built-in procedure to check the state of the standby database.

9. Duplicate all of the subscribers from the standby database. See Duplicating a Master Database to a Subscriber.

10. Set up the replication agent policy and start the replication agent on each of the subscriber databases. See Starting and Stopping the Replication Agents.