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

Failed to start LogMiner mining session due to "Required Start SCN" error message

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 3.0.5.Final
    • 3.0.4.Final
    • oracle-connector
    • None

      The connector constructs a mining range based on a start/end system change number. LogMiner will use this range to create a non-inclusive range by going 1 SCN beyond the given range. If this range exceeds the SCN details available in the supplied logs, LogMiner will then fail with this error.

      The solution is to always make sure the upperbound is less-than LAST_REDO_SCN or less-than or equal-to LAST_REDO_SCN-1, a column found in V$THREAD.

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: