When trying to setup a fresh connection with a fresh snapshot to Oracle with Debezium 1.6 Final I am facing the issue that the logminer session fails to start. Which makes sense because the log switch did not occur. I was expecting to see the message as added in
DBZ-3665 but instead I am getting the following error:
I have tested with disabling the archive only mode and then it starts fine. Let it run overnight, then enabling archive mode again will fail because the SCN in the offsets is from the time when the snapshot was completed. This SCN is too old for us to resume working from:
(Look at the timestamps above to see the time between them)
Here is our config:
It's also worth noting that if I start the snapshot in archive mode only, the snapshot will complete but Debezium considers the initial error (ORA-01291) a soft error, restarts the connector and does the snapshot again. It will end up snapshotting forever. This may be a separate issue but I figured to add here as well. Only with archive only mode off will the snapshot succeed and the streaming start.