This discussion is archived
5 Replies Latest reply: May 22, 2012 8:08 PM by BHenriquez RSS

Gaps on dataguard

BHenriquez Newbie
Currently Being Moderated
Hi,

I want to know how can determine gaps on dataguard and cause of this gaps.

Thanks for help :)
  • 1. Re: Gaps on dataguard
    mail.madhankumar Newbie
    Currently Being Moderated
    Hi,
    you can find the archive log gap using v$archive_gap. gap between low sequence and high sequence. this gap will happen because of space issue,network issue etc.. if one archive log file is not applied from prod..that file is deleted in prod itself..remaining archive logs available in standby ... it won't apply in standby db... that gap u can find it using that view.. for that u can reconfigure again otherwise find scn from standby. based on that scn take incremental backup from prod.. and controlfile..and apply on standby and start with new controlfile...standby will sync without prod downtime..
  • 2. Re: Gaps on dataguard
    damorgan Oracle ACE Director
    Currently Being Moderated
    In addition you can use the dynamic performance views here:
    http://www.morganslibrary.org/reference/dyn_perf_view.html
    under Data Guard.
  • 3. Re: Gaps on dataguard
    mseberg Guru
    Currently Being Moderated
    What I do is use this summary query :

    http://www.visi.com/~mseberg/monitor_data_guard_transport.html

    Change DEST_ID=2 as needed.

    Both alert logs are a great source of the causes.

    -- Network outage
    -- Archive issue on Primary
    -- Transport issues
    -- Disk problem on primary

    Best Regards

    mseberg
  • 4. Re: Gaps on dataguard
    CKPT Guru
    Currently Being Moderated
    Hi,

    GAP's can occurred with many reasons

    1) archive log corruption
    2) unable to transfer as size is big and network speed is low
    3) any configuration of dataguard issue
    4) archives are deleted from OS level, or forcefully deleted?
    5) or the standby is behind from many days.

    If gap is more then perform incremental rollforward , check this link http://www.oracle-ckpt.com/rman-incremental-backups-to-roll-forward-a-physical-standby-database-2/
  • 5. Re: Gaps on dataguard
    BHenriquez Newbie
    Currently Being Moderated
    Thanks for you help :D

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points