When a database is opened with the RESETLOGS option, the log sequence number is reset to 1. Prior to resetting the logs, drain the Connect CDC queue tables so that all pending updates are replicated. After all updates have been replicated, delete the queues using a Connect CDC monitoring and control tool, such as Connect CDC MonCon.
If the queues are not deleted prior to resuming replication, the Change Selector may not be able to locate the archive logs with the new sequence numbers. Deleting the queues causes the Change Selector to start at the current system change number (scn) in the redo logs when replication resumes. An scn is the number assigned to each update in the redo logs, used to determine the order that the updates occurred in the database.