Configuring the Primary and Standby Oracle Databases

When you create and configure Active Data Guard with primary and standby Oracle databases, ensure that the configuration includes specific configuration that supports the TimesTen cache environment.

  1. Configure both the primary and standby Oracle databases to use Flashback queries. See Configuring Recovery Settings in the Oracle Database 2 Day DBA guide.

  2. The Data Guard configuration must be managed by the Data Guard Broker so that the TimesTen daemon processes and application clients respond faster to failover and switchover events. See the Data Guard Broker guide.

  3. Create two supporting database services on both the primary and standby Oracle databases in the Oracle Cluster. One database service points to the primary Oracle Database and the other points to the physical standby Oracle Database. You can create these either through role based services or through system triggers.

    See the following sections for details.