We are running a Kafka implementation with the main goal of streaming data from Oracle using the Debezium connector. We have already configured it and made it run successfully for a while. However, we are currently encountering the following error every 2 hours:

Online REDO LOG files or archive log files do not contain the offset scn.

Our DBA has configured the redo logs to be moved by size rather than at specific time intervals, which is causing challenges in fine-tuning and killing the operation.

Is there a configuration in Debezium that can address this scenario? If not, what would be a good strategy to avoid impacting both Oracle and Kafka?

Thanks in advance.