Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4499

Enable Oracle connector to execute INITIAL_ONLY snapshot.mode

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 1.9.0.Alpha1
    • 1.8.0.Final
    • oracle-connector
    • None

      Debezium engine does not allow running Oracle connector in INITIAL_ONLY snapshot mode as yet. 
      I'd like the connector to run initial consistent snapshot of the DB and exit without initiating or waiting for streaming changes similar to other connectors (mysql, postgresSQL, SQL server etc) support for INITIAL_ONLY mode.

      I have started working on the below changes as per my understanding of INITIAL_ONLY snapshot mode from other connectors:

      1) Add a new Snapshot mode (INITIAL_ONLY) in OracleConnectorConfig.SnapshotMode with includeData= true and shouldSnapshotOnSchemaError=false

      2) In LogMinerStreamingChangeEventSource.execute method check if the connectorConfig.getSnapshotMode() == INITIAL_ONLY, then return to stop streaming.

      3) flush the logWriter with currentScn to update redoLogs on server and log streamingMetrics.

      Please suggest if above steps would suffice the changes needed to run Oracle connector in INITIAL_ONLY mode. 

              Unassigned Unassigned
              poonam.meghnani Poonam Meghnani (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: