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

Allow specifying of Oracle archive log location

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 1.6.0.Final
    • None
    • oracle-connector
    • None

      Our Oracle environment has two archive log locations - one on the FRA and a secondary one on another ASM location. The secondary location is what our DBA team has created specifically for us due to the high rate of archive logs we are creating. The secondary location has a higher retention than the primary location, so we would like to be able to use that location as the only location for us to collect archive logs from. Currently it doesn't seem like it is possible to do this within Debezium.

      On request of Chris Cranford I have attached the V$LOG, V$LOGFILE, V$ARCHIVE_DEST_STATUS, and V$ARCHIVED_LOG output. In the V$ARCHIVE_DEST_STATUS you can see the location we are interested in, namely the /zs03/dbbackup1/PDIM1/FIH_logdest. We would like to be able to only use this location.

        1. vlogfile.csv
          4 kB
        2. vlog.csv
          2 kB
        3. varchived_log.csv
          433 kB
        4. varchive_dest_status.csv
          5 kB

              ccranfor@redhat.com Chris Cranford
              jorn.argelo@mn.nl Jorn Argelo (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: