Oracle CDC RAC - Redo Thread is inconsistent

Ask the Community
1

In Oracle CDC Streaming, data is collected normally for some time, then new events stop arriving with the following error:

Redo Thread 1 is inconsistent;
failed to find log with sequence 927401

On the Oracle side, Thread 1 / Sequence 927401 does exist and is currently available:

ARCHIVED=YES
DELETED=NO
STATUS=A
DEST_ID=1

LOG_ARCHIVE_DEST_1 is also VALID / LOCAL.

This looks similar to Debezium issue DBZ-1801 related to archive log deduplication in Oracle RAC.

Could you please confirm:

  • Which Debezium Oracle Connector version Foundry is using
  • Whether the DBZ-1801 fix is included or backported
  • Whether this behavior could be related to the same RAC archive-log/thread handling issue

For the same SEQUENCE#, records also exist for other redo threads, and some of them are DELETED=YES / STATUS=D.