Change Data Capture – Oracle CDC
CDC : is database functionality that helps in capturing incremental changes to Oracle Database.
Terminology in CDC
Publisher: is database user that publishes captured changed data
Subscriber: is database user that consumes changed data
Change Tables: Changes in database are written to change tables
Subscriber Views: are database views against change tables for subscribers.
Note* -> One publisher can support multiple subscribers
CDC Implementation Methods
A) Synchronous CDC – In this method changes are captured synchronously from source database into change tables. This method uses internal database triggers.
B) Asynchronous Autolog CDC– This method requires staging database separate from source database. Redo logs are transferred from source database to staging database using redo transport service (You can also manually transfer redo and register them to staging database) and changes are captured at staging database. There are two modes available
i) Autolog online CDC ii) Autolog archived CDC
– Source and Target database should be on same operating system and on same database version.
– SYS password on source and target database must be same.
– Source & Staging database should run in archive mode
C) Asynchronous Hotlog CDC – In this method, online redo log file is used to capture changes and changes are captured at source database itself. Separate process mines redo logs and captures changes in change tables.
D) Asynchronous Distributed Hotlog CDC– This method require staging database. Changes capture is performed by separate process on source database and then propagated to staging database and written to change tables (in staging database). For this method underlying infrastructure is provided by Oracle Streams.
– Source & Staging database should run in archive mode
Related Documentation
More on CDC and implementation with E-Business Suite (Oracle Applications) coming soon…