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
jyeager
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.

Thanks.

Report message to a moderator

- 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: 8976
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.

Report message to a moderator

Previous Topic: How to dequeue after 30minutes it has been queued?
Next Topic: Ora-03113 in alert log for stream replication
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 03 15:43:04 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.