Replicating Cache Tables in TimesTen Classic

To achieve high availability in TimesTen Classic, configure an active standby pair replication scheme for cache tables in a read-only cache group or an AWT cache group.

An active standby pair that replicates cache tables from one of these cache group types can automatically change the role of a TimesTen Classic database as part of failover and recovery with minimal chance of data loss. Cache groups themselves provide resilience from Oracle database outages, further strengthening system availability. An active standby pair replication scheme provides for high availability of a TimesTen Classic database.

Note:

This section describes one scenario in including cache groups within an active standby pair replication scheme. See Administering an Active Standby Pair With Cache Groups in Oracle TimesTen In-Memory Database Replication Guide for more scenarios for including AWT and read-only cache groups in an active standby pair replication scheme.

Oracle Real Application Clusters (Oracle RAC) provides for high availability of an Oracle database. See Using Cache in an Oracle RAC Environment.

Perform the following tasks to configure an active standby pair for TimesTen Classic databases that cache Oracle Database tables:

• Create and Configure the Active Database

• Create and Configure the Standby Database

• Create and Configure the Read-Only Subscriber Database