GoldenGate How to handle replication with extra columns on source and target tables

Case A – Additional Column on Target Table In this example the JOBS table on the target database oradb2 has an additional IDENTITY COLUMN called ID SQL> conn demo/oracle@oradb1Connected.SQL> desc jobsName Null? Type—————————————– ——– —————————-JOB_ID NOT NULL VARCHAR2(10)JOB_TITLE NOT NULL VARCHAR2(35)MIN_SALARY NUMBER(6)MAX_SALARY NUMBER(6)SQL> conn demo/oracle@oradb2Connected.SQL> alter table jobs add (ID NUMBER GENERATED ALWAYS AS IDENTITY);Table […]

Installation and Configuration of GoldenGate 19c Microservices on RAC

In this note we will cover how to install and configure Oracle Goldengate 19c Microservices on an Oracle 19c RAC environment. We will then configure high availability for GoldenGate Microservices using Grid Infrastructure Agent XAG v10. Finally we will test the high availability by simulating a RAC node failure and verify that the GoldenGate Microservices […]

Oracle GoldenGate on Oracle Cloud Marketplace (Part 1)

Oracle Cloud Marketplace (https://cloudmarketplace.oracle.com) is an online store selling a wide variety of business applications and services which can complement an existing Oracle Cloud implementation. All these applications and services available on the Cloud marketplace are offered by Oracle approved and registered partners and developers. Oracle GoldenGate is one of the many applications available on […]

Oracle GoldenGate 18c New Features

Oracle GoldenGate 18c now provides support for some new features which were introduced in Oracle database 12c – namely support for Identity Columns and In-Database Row Archival. Identity columns enables us to specify that a column should be automatically populated from a system-created sequence which is similar to the AUTO_INCREMENT column in MySQL or IDENTITY […]

Oracle GoldenGate 18c Upgrade

This note outlines the procedure followed to upgrade GoldenGate 12.3 to the latest 18c version ( Note: If we are upgrading from Oracle GoldenGate or earlier, we also need to upgrade the Replicat checkpoint table via the GGSCI command UPGRADE CHECKPOINTTABLE [owner.table] If we are using trigger-based DDL replication support, then additional steps need […]

Oracle GoldenGate 12c Release 3 ( Microservices Architecture

Microservices Architecture is a method or approach to developing applications where an application is deployed as a suite of independently deployed small modular services. Each module supports a specific business goal and uses a simple, light weight  and well-defined interface to communicate with other sets of services. Oracle GoldenGate Microservices Architecture (MA)  is a similar […]

Oracle 12c GoldenGate Implementation Workshop online training

Oracle 12c GoldenGate Implementation Workshop online training is commencing 23rd January.   This 20 hour workshop will comprise topics included in the official Oracle University GoldenGate 12c Essentials, GoldenGate Advanced Configuration and GoldenGate Tuning and Troubleshooting classes.   Use the following links to register for the  online  training classes:  7.00 to 9.00 PM IST Batch […]

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?