In Oracle environments where DDL replication (i.e., replicating schema changes automatically) is not enabled, handling a DDL change like adding a column in a replicated environment requires coordination and care. If not done properly, it may lead to data inconsistency or replication failures. In this blog post, we walk through a safe procedure using GoldenGate […]
In mission-critical systems, downtime is not an option. Organizations demand continuous availability — even during platform upgrades. This is where a Zero Downtime Database Upgrade from Oracle 12c to 19c using Oracle GoldenGate becomes a strategic capability. In this post, we walk you through the full process to achieve an upgrade with minimal disruption. Why […]
1. How do you configure a unidirectional replication using GoldenGate? Unidirectional replication moves data from a source database to a target database in one direction only. Here’s the step-by-step configuration process: ✅ Source Side Configuration: ✅ Target Side Configuration: 2. What are the steps involved in setting up Integrated Extract? Integrated Extract is tightly coupled […]
1. How do you monitor GoldenGate processes and performance? Effective monitoring is vital for ensuring data replication health, low latency, and zero data loss. 🔹 Monitoring Tools and Methods: 2. What is the use of the lag and checkpoint commands? These commands help assess data latency and process recovery. 🔹 LAG Command: GGSCI> LAG EXTRACT […]