Disaster Recovery for TimesTen Classic through Cache

In TimesTen Classic, cache supports Oracle Data Guard, as well as providing its own high availability through active standby pair replication of cache tables for read-only and AWT cache groups.

You can use the following methods to set up a disaster recovery site:

• Replicating an AWT cache group with a subscriber propagating to an Oracle database.

  You can recover from a complete site failure by creating a special disaster recovery read-only subscriber as part of the active standby pair replication scheme. The standby database sends updates to cache group tables on the read-only subscriber. This special subscriber is located at a remote disaster recovery site and can propagate updates to a second Oracle database, also located at the disaster recovery site. The disaster recovery subscriber can take over as the active in a new active standby pair at the disaster recovery site if the primary site suffers a complete failure. Any applications may then connect to the disaster recovery site and continue operating, with minimal interruption of service.

  See Using a Disaster Recovery Subscriber in an Active Standby Pair in the Oracle TimesTen In-Memory Database Replication Guide.

• Using cache with either synchronous or asynchronous Data Guard.

  Oracle Data Guard provides the management, monitoring, and automation software infrastructure to create and maintain one or more synchronized standby Oracle databases to protect data from failures, disasters, errors, and corruptions. If the primary Oracle database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby Oracle database to the primary role, thus minimizing downtime and preventing any data loss.

  • Asynchronous Data Guard support: You can cache tables from an Oracle Active Data Guard with the asynchronous redo transport mode into read-only cache groups. The read-only cache groups are replicated within an active standby pair replication scheme. The Active Data Guard configuration includes a primary Oracle database that communicates over an asynchronous transport to a single physical standby Oracle database.

  • Synchronous Data Guard support: Cache works with synchronous physical standby failover and switchover and logical standby switchover. During a transient upgrade, a physical standby Oracle database is transformed into a logical standby Oracle database.

  See Using Cache with Data Guard in the Oracle TimesTen In-Memory Database Cache Guide.