GoldenGate DML replication on 12c Oracle database on Windows platform using 22.214.171.124.1 version of Goldengate.
GoldenGate Initial load replication on 12c Oracle database on Windows platform using 126.96.36.199.1 version of Goldengate.
DML Replication - Error Handling
Implements a simple error handling for 1 table. For any DML error, record gets updated into the error table having same fields as source, plus few more fields to trap the exception conditions like ErrorNo, ErrorMessage, Operation Type etc.
DML Replication, Part 2 - Involved Error Handling
Implements a little involved error handling for n tables. Exception table that would capture the DML exceptions is generic and owned by the GoldenGate owner on the replicat side.
Configuring DDL Replication
DDL replication is much simpler in 12c compare to what existed in 11g. Let's find out.
DML Replication with Sequences
Sequences can be replicated even if DDL replication is disabled. Sequences values can be tricky to replicat as they are cached on the targer - be it single instance or RAC.
DML Replication flavors - Classic / Coordinated / Integrated
Replicat in 12c can be implemented in 3 ways. What existed in 11g database is termed as classic replicat. 12c comes with 2 more possibilities - Coordinated or Integrated.
Interesting findings while working with the wonderful product.
2 way replication - I
This makes Goldengate stand apart. Let's build active active replication topology with a simple table and build slowly on that covering various aspects of 2 way replication, where both databases are open for read/write.
2 way replication - II
Conflict Detection and Resolution(CDR) for simultaneous updates on the same record on 2 systems.
2 way replication - III
Conflict Detection and Resolution(CDR) for simultaneous inserts, updates and deletes.
Summing it all up
2 way replication with Sequence and DDL support with error handling.