| Question about CDC [message #650568] |
Wed, 27 April 2016 13:42  |
 |
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  |
John Watson
Messages: 8961
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
