Transparent Application Continuity with Oracle Active Data Guard - Demo

This video demonstrates Transparent Application Continuity with Oracle Active Data Guard.

To use Transparent Application Continuity, the applications must use the recommended connection string for high availability.
The connection string must point to a service that has Transparent Application Continuity enabled.

We can see that the session is connected to the DB_UNIQUE_NAME cdgsima_lhr1pq.
We start a transaction in that session using an insert statement but we do not commit.

In another terminal, we execute a Data Guard Switchover to the physical standby database cdgsima_lhr1bm.

While the switchover is executing, we commit in the other session.
The driver detects that disconnection happened and reconnects to the new primary database.
As soon as it reconnects, Transparent Application Continuity restores the session and transaction states.
The pending commit succeeds although the session has been disconnected with an in-flight transaction.

----------------------------------------------
Copyright © 2022, Oracle and/or its affiliates.