Integration of Oracle GoldenGate with Oracle Database 21c and OGG Enhancements

Oracle GoldenGate started getting integrated with Oracle Database from the version OGG 12.1.x. Yes, Integrated Extract and Later Integrated Replicat. This is where they embedded the streams technology with Oracle GoldenGate.

Integrated Extract and Integrated Replicat are tightly coupled with Oracle Database. It means, these processes are integrated with Oracle Database. Hence it has fully loaded features where Classic Extract or Replicat doesn’t have as it is decoupled with Oracle Database. This was the starting phase for Oracle to integrate Oracle GoldenGate with Oracle Database.

If you want to know more about the Integrated Extract and Integrated Replicat Please refer the below links.

https://www.oracle-scn.com/oracle-goldengate-integrated-capture/

https://www.oracle-scn.com/oracle-goldengate-integrated-replicat/

There were also other integration to the Oracle Database like below,

• Oracle GoldenGate Integration with Datapump (Expdp/Impdp)

• Automatic Conflict Detection and Resolution (AUTO CDR)

If you want to know more about Oracle GoldenGate Integration with Datapump (Expdp/Impap), check the below link,

https://www.oracle-scn.com/oracle-goldengate-integration-with-datapump-dboptions-enable_instantiation_filtering/

Recently, Oracle Database 21c got released on cloud and when I was eagerly searching for the features related to Oracle GoldenGate, below is what I found.

• Automatic CDR Enhancements

• Improved Support for Table Replication for Oracle GoldenGate

• LogMiner Views Added to Assist Replication

• Oracle GoldenGate for Oracle and XStream Support for JSON Data Type

1. Automatic CDR Enhancements

Auto CDR was introduced in the version OGG 12.3 and from Oracle Database 12.2. It was a great enhancement provided by Oracle as normal
CDR needs so many parameter configurations which was a bit tedious. Oracle Simplified the configuration of CDR by introducing Auto CDR feature.

• Add parameter MAPINVISIBLECOLUMNS in each replicat parameter file.

• Connect to database and execute the below command,

EXEC dbms_goldengate_adm.add_auto_cdr(‘schema’,’table’)

But by default AUTO CDR resolves the conflict using the highest or latest timestamp. This will not suit for all the applications.

From Oracle Database 21c there is an enhancement of Auto CDR resolving the conflicts using earliest timestamp and site priority.

So with this, Auto CDR supports below,

• Latest Timestamp based resolution

• Earliest Timestamp based resolution

• Site Priority based resolution

For more information, please check the below link,

https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/automatic-cdr-enhancements-264574977.html

2. Improved Support for Table Replication for Oracle GoldenGate

Adding Supplemental Log is one of the pre-requisites for Oracle GoldenGate. We need to mention the tables which needs to be replicated or captured by the Extract process. The parameters are TABLE / TABLEEXCLUDE.

Now, this has been integrated with Oracle Database 21c with a new feature OGG EXTRACT, the LOGICAL_REPLICATION clause for automatic extract of tables.

For more info, please check the below link,

https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/improved-support-for-table-replication-for-oracle-goldengate-256550019.html

3. LogMiner Views Added to Assist Replication

The DBMS_ROLLING package provides us with procedures to perform rolling upgrade related tasks.

From Oracle Database 21c, the package has a new parameter in the DBMS_ROLLING.set_parameter() which is BLOCK_UNSUPPORTED. This parameter blocks the replication of operations UNSUPPORTED by Transient Logical Standby.

For more info, please check the below link,

https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/logminer-views-added-to-assist-replication-382959480.html

4. Oracle GoldenGate for Oracle and XStream Support for JSON Data Type

From Oracle 21c, the OGG supports JSON Data Type. For more info please check below link,

https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/oracle-goldengate-for-oracle-and-xstream-support-for-json-data-type-256120867.html

Eagerly waiting for the next version of Oracle GoldenGate to get released 🙂 Probably, it will be Oracle GoldenGate 21c 🙂 Cheers..!!