Question about CDC [message #650568] |
Wed, 27 April 2016 13:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/925b61becbfbfa5061b54454a6eaee17?s=64&d=mm&r=g) |
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.
|
|
|
Re: Question about CDC [message #650574 is a reply to message #650568] |
Wed, 27 April 2016 17:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 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.
|
|
|