Oracle Debezium – Incremental Snapshot without CDC

[Олександр Тупчієнко]

Hi,

I’m using the Oracle Debezium source connector and I have a question:

Is it possible to run an incremental snapshot without continuing CDC afterwards?
Or is stopping or deleting the connector the only way to achieve this?

Thanks,

[Chris Cranford]

Hi -

Unfortunately there is not. Both adhoc blocking snapshot as well as incremental snapshots will resume streaming after the snapshot concludes. If you want to retake a snapshot but not perform CDC after the snapshot, then perhaps using a connector with `snapshot.mode` set to `initial_only` would be the better option, as this will read all the current historical data for all configured tables and exit afterward.

Thanks,
-cc

--
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 visit https://groups.google.com/d/msgid/debezium/ef98d9f8-d3b6-4450-a47a-e67811f58fd1n%40googlegroups.com.

[Олександр Тупчієнко]

  Thanks for the clarification, this is very helpful.

  One follow-up question: when running an incremental snapshot, can it be considered that the snapshot is taken against a single, well-defined SCN (as a logical consistency point)?    

середа, 17 грудня 2025 р. о 03:15:43 UTC+2 Chris Cranford пише:

[Chris Cranford]

Hi -

No, that would be either the initial or adhoc blocking snapshot that operates this way. Incremental snapshots are chunk-based that operates across multiple chunks each with its own start/open close window positions. I'd suggest taking a look at the design document (DDD-3) [1] for technical details on the process.

Thanks,
-cc

[1]: https://github.com/debezium/debezium-design-documents/blob/main/DDD-3.md

To view this discussion visit https://groups.google.com/d/msgid/debezium/1e820a5f-85d6-49bf-92c5-b6cbd21e10b4n%40googlegroups.com.