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

Enable Oracle connector to execute INITIAL_ONLY snapshot.mode

    XMLWordPrintable

Details

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

    Description

      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. 

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: