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

None of log files contains offset SCN (SCN offset is no longer available in the online redo logs)

XMLWordPrintable

      Versions:
      debezium - 1.6 SNAPSHOT
      Oracle - 19c (19.0) on RHEL

       

      This error occurs after a certain idle time for the oracle connector (log.mining.strategy = online_catalog)

      IllgealStateException: None of log files contains offset SCN: 3961693, re-snapshot is reuired

      setLogFilesMining(LogMinerHelper.java:446)

       

      If we do not find this SCN in the logs, then what's the point of throwing an runtime exception and stopping the connector in the setLogFilesForming method ?

      Can you specify any workaround for Oracle 19c?

       

       

        1. screen.png
          1.33 MB
          Sergey Tsimbalov

              ccranfor@redhat.com Chris Cranford
              sergeyts Sergey Tsimbalov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: