This content has been marked as final. Show 6 replies
And your Oracle version is?
In the currently supported versions you can suspend streams at any time you wish: Just disable/enable capture. When you re-enable Streams will resume shipping the logs right where it left off.
Thanks for quick reply.
We are on 11g Rel 2.
So just use below..right?
Edited by: user12028662 on Jan 11, 2012 1:01 PM
START_CAPTURE and STOP_CAPTURE would be where I'd be inclined to go.
So changes between stop capture and start capture, won't those be lost in destination?
Sorry to bug you, but I want to be clear.
I recommend you read the docs on this package.
"This package provides interfaces to start, stop, and configure a capture process or a synchronous capture. This package includes subprograms for preparing database objects for instantiation."
Streams is a Journalyzed replication built of Advanced Queuing for the guarantee of transport and the archive logs system as the journal. Stop the capture and when you restart it, streams will restart from exactly where it was.