Merged upstreamFeatureMerged Aug 13, 2026
Add SCN specific startup for Oracle CDC
Added Apache SeaTunnel Oracle CDC support for starting incremental capture from a user-provided SCN using startup.mode=specific and startup.specific-offset.scn.
apache/seatunnel · #11171
Problem
Oracle CDC lacked a first-class way to resume from a known Oracle SCN. The generic file/position specific-offset model did not match Oracle's redo-log offset shape, leaving users without a connector-owned SCN startup contract.
Approach
Added an Oracle-specific SCN option, mapped the configured SCN into the existing RedoLogOffset model, validated invalid combinations early, preserved checkpoint/restore behavior, and updated English and Chinese Oracle CDC docs.
Impact and scope
- Enables Oracle CDC jobs to start incremental reading from an explicit valid SCN, a practical recovery and operations need for CDC pipelines.
- Keeps Oracle-specific startup semantics inside the Oracle connector while reusing SeaTunnel's shared StartupConfig.specificOffset(Map) and RedoLogOffsetFactory path.
- Fails fast for missing, non-positive, wrong-mode, or file/position combinations instead of silently falling back to another startup behavior.
Validation
- Added focused unit coverage for required SCN config, positive-SCN validation, RedoLogOffset mapping, split-state restore, wrong-mode rejection, and file/position rejection.
- Verified the Oracle CDC package from a clean reactor: 20 modules built successfully and all 15 Oracle tests passed.
- Ran Spotless checks and merged after maintainer approval confirmed the SCN startup contract was wired end to end with green CI.