Tag: GoldenGate
Using Oracle’s Lock-Free Reservable Columns with GoldenGate
Oracle's lock-free reservations, introduced in version 23c, address the issue of concurrent transaction blocking when updating specific columns. This functionality allows multiple transactions to modify the same row without traditional locking mechanisms. Here's a breakdown of how it works: Reservable Columns: You designate specific numeric columns within a table as "reservable." These columns are typically used … Continue reading Using Oracle’s Lock-Free Reservable Columns with GoldenGate
GoldenGate Replicat? Which one should I use?
Oracle GoldenGate Replicat is a software program that plays a crucial role in data replication within the Oracle GoldenGate data integration platform. It's responsible for applying changes captured from a source database to a target database, ensuring data consistency between the two database systems. Replicat is also responsible to deliver transaction to Big Data systems with … Continue reading GoldenGate Replicat? Which one should I use?
What? GoldenGate Logs with Postman?
Did you know you can check the GoldenGate logs from #Postman? Check it out and unleash your creativity with GoldenGate Microservices.
Part 2 – Build GoldenGate Bi-Direction Replication in few minutes on Docker
Now that we have completed Part 1 to set up the Container infrastructure, it's time to create the GoldenGate replication. The script below will auto-create everything we need to enable a Bi-directional replication for the West and East databases (created in Part 1). If you have not completed Part 1, please go back and look at … Continue reading Part 2 – Build GoldenGate Bi-Direction Replication in few minutes on Docker
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
How about that gg_heartbeat_history table?
Heartbeat tables are used to monitor the lag throughout the data replication cycle. Automatic heartbeats are sent periodically from each source database into the replication streams. These heartbeat records are inserted or updated into the heartbeat table at the target databases. By comparing the timestamps of these heartbeat records, the current and historical lags in … Continue reading How about that gg_heartbeat_history table?
GoldenGate Microservices Benefits over Classic Architecture
Every once in a while, I've gotten a question about what are the main advantages of Microservices Architecture over Classic Architecture. In this article, I am trying to summarize the most relevant point at a high level. If you would like more details in any area, please feel free to reach out. The Oracle GoldenGate Microservices product … Continue reading GoldenGate Microservices Benefits over Classic Architecture
No PK with GoldenGate?
When Oracle GoldenGate encounters tables without a primary key (PK) for data replication, it has different approaches depending on the situation: 1. Using Unique Indexes: If a unique index exists on the table, GoldenGate can use those columns to identify rows for updates and deletes. This is the preferred approach as it avoids full table scans on … Continue reading No PK with GoldenGate?
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
Find the Archived log from a SCN
From time to time you might need to find out where a particular transaction is in the redo logs. Most of the time if you want to look for an old transaction you will need to look into the archived logs history. This script will give you a good understanding of where the SCN for … Continue reading Find the Archived log from a SCN
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
alexlima.com 