You are able to reset the place from which the log reader last finished reading by deleting the data in the queues, re-enabling capture and restarting the request. This allows you to start from the current time rather than where the log reader last processed.
To reset the starting point, do the following:
-
Stop any active log-based capture.
-
Disable capture for log-based capture request. (This also stops the Oracle Change Selector.)
-
Select the Delete Queues option (only available if you have a Replication request highlighted) in an Connect CDC monitoring and control tool, for example, Connect CDC MonCon.
-
Enable change capture for requests.
-
Start requests.