Replaying Oracle CDC from specified SCN

[Nicholas Yu]

Hi Team,

Wanted to know if it is at all possible to configure debezium to replay events from a specified SCN.

We've had issues which has resulted in a gap of data and looking for options to resolve.

Thanks,

Nick

[Chris Cranford]

Hi Nicholas -

You can stop the connector and specifically set the offset "scn" and "commit_scn" values accordingly and restart the connector to try and read from a specific offset; however, this requires that all archive logs that include that SCN reference and that come chronologically after that SCN are still available on the Oracle database.  If those archive logs have been purged or deleted, then this process won't work as the logs are critical in re-reading older data.

Each connector's offset structures are different, so keep in mind that the FAQ [1] describes this process from the point of view of MySQL; however the overall process and commands needed are the same.

Thanks,
Chris

[1]: https://debezium.io/documentation/faq/#how_to_change_the_offsets_of_the_source_database

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/665706c3-e8cf-4267-88a5-61790cb6916fn%40googlegroups.com.