Oracle GoldenGate enables bidirectional data movement between two or more databases that actively support an application, with no geographic distance constraints.

The active-active solution allows data updates and changes ("write" activity) to occur on two or more active databases supporting live applications. Oracle GoldenGate synchronizes the two active databases by replicating the data between each at a logical level and allows load distribution to improve system performance. In the case of an outage of one system, there is no downtime for the end user because the other active system continues with operations.

Considering that Oracle GoldenGate is an asynchronous solution, conflict management is required to ensure data accuracy in the event that the same row is changed in two or more databases at (or about) the same time. Oracle GoldenGate provides capabilities to detect and resolve conflicts. A variety of active-active scenarios can be supported – depending on the desired implementations. Oracle GoldenGate provides these active-active solutions for both High Availability as well as Zero-Downtime upgrades and migration projects.

For a sample automation script to set up an active active data replication, see Bidirectional Replication Using Active-Active Configuration.

Also see Design Different Topologies with Oracle GoldenGate 23ai to set up a test environment and use these automation scripts.