We have setup one-way replication and want to understand is it possible to suspend replication for some time and resume it later and how? And if it's possible will it catch-up with changes that happened while it was suspend.
Any insight or link will be helpful. I scrolled through streams adminstrator guide. I am also thinking of disabling propagation and enabling it later to see what happens but that's just experimental.
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.
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.