Cache in TimesTen Works with Synchronous Data Guard
Cache in TimesTen works with synchronous physical standby failover and switchover and logical standby switchover as long as the object IDs for cached Oracle Database tables remain the same on the primary and standby Oracle databases.
Object IDs can change if the table is dropped and re-created, altered, or a truncated flashback operation or online segment shrink is performed.
During a transient upgrade, a physical standby Oracle database is transformed into a logical standby Oracle database. For the time that the standby Oracle database is logical, the user must ensure that the object IDs of the cached Oracle Database tables do not change. Specifically, tables that are cached should not be dropped and re-created, truncated, altered, flashed back or have an online segment shrunk.
The following sections describe how to configure the Oracle and TimesTen databases.