Home » Server Options » Streams & AQ » Question about CDC (Change Data Capture)
Question about CDC [message #650568] Wed, 27 April 2016 13:42 Go to next message
Messages: 4
Registered: April 2016
Location: Nashville
Junior Member
When considering using CDC in Asynchronous HotMode, the documentation leaves me unclear about a few things.

First: does the database need to be in archivelog mode? Since Async Hotmode works off the active/online redo log why would the DB need to be in archivelog mode? I would expect that to be necessary for the distributed modes.
(I'm considering using it just to be able to asynchronously process certain table changes locally in the same DB).

Also, does supplemental logging need to be on at the database level?
I would prefer to simply enable supplemental logging at the table level for those few tables I intend to monitor, and I would think this would be enough.

Re: Question about CDC [message #650574 is a reply to message #650568] Wed, 27 April 2016 17:53 Go to previous message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
Archive log mode is required. Otherwise, if CDC capture were not running for a while, it would be impossible to catch up.

You need supplemental logging only on the relevant tables.
Previous Topic: How to dequeue after 30minutes it has been queued?
Next Topic: Ora-03113 in alert log for stream replication
Goto Forum:

Current Time: Wed Apr 24 10:20:23 CDT 2024