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

Getting java.sql.SQLException: ORA-01291: missing logfile while running with archive log only

    XMLWordPrintable

Details

    Description

      Hi team

      We are using debezium server 1.8 version, which is connecting to oracle database(12C enterprise). we are following bellow sequence 

      1) Debezium is installed on top of GCP- compute engine machine - e2standard4 
      2) Debezium is able to establish the connectivity with oracle db (10.6.63.198)

      3) but considering "source.log.mining.archive.log.only.mode=true" property - to read archive logs only, we are getting ORA-01291: missing logfile issues.

      4) While running with "source.log.mining.archive.log.only.mode=true" property we are able to get backfill data, but once it starts for streaming , it throws the ORA-01291: missing logfile errors.

       

      observations:

      1) If we run with redo+archive i.e  "source.log.mining.archive.log.only.mode=false" property, our debezium CDC pipeline working fine.

      2) Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126133316324', endScn => '126133324126', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '126133316324', endScn => '126133324126', OPTIONS => DBMS_LOGMNR.DICT_FROM_REDO_LOGS + DBMS_LOGMNR.DDL_DICT_TRACKING  + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile
      ORA-06512: at "SYS.DBMS_LOGMNR", line 58
      ORA-06512: at line 1 

      As per above error we can see it reads SCN from DICT_FROM_REDO_LOGS (redo log), which is not correct as we are trying to read data from archive logs.

       please help us to resolve issue 

       

      please find the following configuration details 

      connector.class = io.debezium.connector.oracle.OracleConnector
      database.history.file.filename = tempiposct2v16/FileDatabaseHistory.dat
      database.user = DBZUSER
      database.dbname = AMCTPRD
      key.converter.value = json
      database.server.name = AMCTPRD
      database.port = 1521
      value.converter.value = json
      offset.flush.interval.ms = 0
      tombstones.on.delete = false
      offset.storage.file.filename = tempiposct2v16/offsets.dat
      decimal.handling.mode = double
      database.hostname = 10.6.63.198
      name = pubsub
      log.mining.archive.log.only.mode = true
      database.oracle.version = 12+
      table.include.list = TOS_USR.CTRDTLS_O,TOS_USR.CTROTHDTLS
      value.converter.key = json
      database.history = io.debezium.relational.history.FileDatabaseHistory
      snapshot.mode = schema_only
      key.converter.key = json

       

       

      Attachments

        1. application.properties
          2 kB
        2. debezium_latest_release.PNG
          debezium_latest_release.PNG
          50 kB
        3. Debezium-LogFiles_log_pty_im.log
          131 kB
        4. Debezium-LogFiles_log_voyctrdtls_o.log
          89 kB
        5. Debezium-LogFiles_log_voyctrdtls-withschemaonly.log
          78 kB
        6. image-2022-04-14-11-54-30-292.png
          image-2022-04-14-11-54-30-292.png
          67 kB
        7. image-2022-04-14-16-25-10-198.png
          image-2022-04-14-16-25-10-198.png
          97 kB
        8. image-2022-04-18-18-55-56-041.png
          image-2022-04-18-18-55-56-041.png
          68 kB
        9. image-2022-04-18-19-09-06-278.png
          image-2022-04-18-19-09-06-278.png
          174 kB
        10. trace.log
          38 kB
        11. trace1.log
          18.79 MB
        12. trace-1.log
          38 kB
        13. trace-2.log
          12.40 MB

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            sudarshandusaneuk@hotmail.com sudarshan dusane (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: