Oracle GoldenGate effectively supports active-active DDL replication between two systems. To achieve bidirectional replication in an active-active setup, it is important to configure the Oracle GoldenGate processes correctly, here are some recommendations:

  • All Data Definition Language (DDL) operations must use fully qualified object names.
  • DDL changes should be made from a single server at a time to ensure system integrity. It is important to note that GoldenGate does not provide conflict detection or resolution for DDL changes.
  • The replicats should use DDLOPTIONS UPDATEMETADATA. 
  • DDLOPTIONS EXCLUDETAG 00 should be utilized in Extract. Tag 00 serves as the default for the replicat. If DBOPTIONS SETTAG is specified in the replicats, then the tag value should be changed accordingly.
  • Changes to DDL on system-generated object names must be carefully coordinated, as the names on other database servers may differ. This rule applies to all DDL replication situations, not just active-active setups.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.