I wonder whether I can start capturing changes from specific Oracle SCN using Debezium Connector (LogMiner enabled), the official spec states only two properties that I can tune:
log.mining.scn.gap.detection.gap.size.min - Specifies the minimum gap size. (Default - 1000000)
log.mining.scn.gap.detection.time.interval.max.ms - Specifies the maximum time interval. (Default - 20000)
So that means no SCN as a point from which I can start replication, or am I missing something?
As an example, what I am trying to do is to find a solution when having an Oracle snapshot №1 I can fully load and convert all data to another database using special tools. Whenever I get another, new, updated snapshot №2, the using tool didn't match the requirements for replicating the delta between snapshots 1 and 2, and It is necessary to find another approach. Probably, Debezium as an open source tool can help here.
A workaround that first comes to mind is running Debezium with the initial load, prior to the end of snapshot №1, then restarting the Debezium process already with snapshot №2 as a source and replicating all data through Kafka and Sink Connector to the target database.
Are there any pitfalls that I don't see at this moment?
