Oracle
CDC source setup for Oracle
Prerequisites
1. Oracle Database Requirements
-- Verify ARCHIVELOG mode is enabled
SELECT LOG_MODE FROM V$DATABASE; -- Must be ARCHIVELOG
-- Enable ARCHIVELOG mode (if not already enabled)
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
-- Enable force logging (recommended)
ALTER DATABASE FORCE LOGGING;
-- Enable supplemental logging
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
-- Enable GoldenGate replication parameter
ALTER SYSTEM SET enable_goldengate_replication = TRUE SCOPE=BOTH;2. GoldenGate Requirements
3. GoldenGate Connection Properties
Property
Description
4. User Permissions
Quick Start
How It Works
Examples
Large Tables with Custom Chunk Size
Time-Bounded Snapshots for Very Large Tables
High-Throughput Workloads
Soft Deletes
Mixed Streams with Per-Stream Overrides
Replay / Backfill from a Point in Time
Replay Formats
Why GoldenGate (Not LogMiner)
GoldenGate Setup Overview
Troubleshooting
"CDC not supported for <type>"
"could not connect to GoldenGate Data Stream"
"GoldenGate Data Stream not found"
"authentication failed for GoldenGate"
Initial snapshot keeps restarting
"could not resolve replay_from position"
Last updated
Was this helpful?