Did you know you can check the GoldenGate logs from #Postman? Check it out and unleash your creativity with GoldenGate Microservices.
Tag: oraclegoldengate
Part 1- Deploy GoldenGate 23c Free and two Oracle Database 23.3 on Docker in just a few Minutes
Introduction: This Part 1 post will show you how to create a GoldenGate Free 23.3 (Hub) that connects to two Oracle Database Free 23.3 (I am calling them West and East). This is extremely easy if we take advantage of containers as I will describe it below. Part 2 will demonstrate how to automate the creation … Continue reading Part 1- Deploy GoldenGate 23c Free and two Oracle Database 23.3 on Docker in just a few Minutes
Enable ACDR for all tables in a GoldenGate Bi-Directional Replication
An essential consideration when configuring Oracle GoldenGate for bi-directional or multi-directional (active-active) data replication is the potential for data collision, which occurs when identical data is modified in distinct databases involved in the integration. GoldenGate includes an out-of-the-box capability to detect and resolve such conflicts. Automatic Conflict Detection and Resolution (ACDR) is configured at the … Continue reading Enable ACDR for all tables in a GoldenGate Bi-Directional Replication
Oracle Data Pump Filters GoldenGate ACDR Columns from Tables
The ACDR feature of Oracle GoldenGate adds hidden columns to tables to resolve conflicts when the same row is updated by different databases using active replication. GoldenGate can also create a "tombstone table," which records interesting column values for deleted rows. The Oracle Data Pump Import command-line mode TRANSFORM parameter enables you to alter object creation DDL … Continue reading Oracle Data Pump Filters GoldenGate ACDR Columns from Tables
Per-PDB Capture in GoldenGate 23c
GoldenGate Free 23c now supports per-pluggable Database (per-PDB) capture (Only). Oracle GoldenGate 23c (23.3) enables you to grant privileges to users at the PDB level. Root-level access using common user c##ggadmin, is no longer available. https://docs.oracle.com/en/middleware/goldengate/free/23/uggfe/goldengate-free-release-notes.html#GUID-65470EEC-B982-4817-8083-4D058D973125
New GoldenGate Capture and Apply Roles in 23c
Simplification for GoldenGate User privileges in 23c. Check out the new roles in Oracle Database 23c for GoldenGate. #oracle #oraclegoldengate #goldengate
Automatic CDR Enhancements in 23c
Automatic Conflict Detection and Resolution (ACDR) was introduced in Oracle Database 12c Release 2 (and Oracle GoldenGate 12.3.0.1) to automate the conflict detection and resolution configuration in active-active Oracle GoldenGate replication setups. In Oracle Database 21c, Oracle enhanced ACDR to support earliest timestamp based resolution and site priority based resolution. In Oracle Database 23c, Oracle … Continue reading Automatic CDR Enhancements in 23c
OCI GoldenGate Service (GGS) Connection Types
OCI goldenGate has come a long way in the last year or so. Below are the connections it currently supports. Lots of excitement in this area of the product. I can't wait to see what comes next. What do you think? What would you like to see? Drop a comment below. Here are some cool … Continue reading OCI GoldenGate Service (GGS) Connection Types
Migrate GoldenGate Classic to Microservices
Don't be left behind. GoldenGate Migration Utility was created to help you migrate from Classic to Microservices architecture without many manual procedures. Check out the video DEMO available on the GoldenGate Youtube Channel: https://www.youtube.com/watch?v=PQktlsAuJYI&ab_channel=oraclegoldengate
Check for Long Open Transactions with Python
Most of the time, when GoldenGate extract runs without a hitch, and the GoldenGate monitor displays no anomalies or slowness, we are unaware that a prolonged open transaction is holding a lock in the database, which can result in long pipeline latency. This issue can occasionally arise because an application has not properly cleaned up … Continue reading Check for Long Open Transactions with Python
Oracle GoldenGate 2023 Virtual Customer Summit
Our Spring Summit will be a 4hr webinar packed with the latest updates about Oracle GoldenGate and Stream Analytics, featuring customer stories, live demos, and a roadmap for the future of Data Fabric and Data Mesh architectures. We look forward to hosting you at this highly informative event. Zoom Event for EMEA Wednesday March 29, … Continue reading Oracle GoldenGate 2023 Virtual Customer Summit