Oracle DBA

1. What is Conflict Detection and Resolution (CDR) in bidirectional replication? Conflict Detection and Resolution (CDR) is a mechanism in Oracle GoldenGate to handle data conflicts that arise in bidirectional (active-active) replication setups, where the same table is being updated at multiple sites simultaneously. 🧠 Why is CDR needed? In active-active replication, changes can occur […]

Basic-Level Interview Questions 1. What is Oracle GoldenGate? Oracle GoldenGate is a real-time data replication and integration solution that enables transactional data to be moved across heterogeneous systems with minimal latency. It supports high-availability, zero-downtime migration, reporting offloading, and active-active database configurations. 2. What are the key components of Oracle GoldenGate architecture? The core components […]