This discussion is archived
1 Reply Latest reply: Mar 22, 2013 10:15 PM by 986452 RSS

Manually Gap Detection & Resolution

986452 Newbie
Currently Being Moderated
Hello,

1) For manually resolving a gap, which one is the recommended method?
-By using RMAN incremental backup Or
-By manually copying missing archived files to the standby and register them with Standby

2) For Gap Detection and Resolution, does Oracle use both Automatic Gap Resolution & Fal Gap Resolution simultaneously or one after the other?

Thanks
  • 1. Re: Manually Gap Detection & Resolution
    CKPT Guru
    Currently Being Moderated
    1) For manually resolving a gap, which one is the recommended method?
    -By using RMAN incremental backup Or
    -By manually copying missing archived files to the standby and register them with Standby
    If you have archives on primary then still i strongly recommend to troubleshoot and resolve the issue, If suppose the archives are transported and those archives are
    deleted on standby from OS then again catalog those archives with standby. So that you can start recovery.

    You can go for incremental rollforward, if in case you do not have any archives on primary or standby and no backups of archives available, But you have some more manual steps, you can check in detail from below link
    http://www.oracle-ckpt.com/rman-incremental-backups-to-roll-forward-a-physical-standby-database-2/
    2) For Gap Detection and Resolution, does Oracle use both Automatic Gap Resolution & Fal Gap Resolution simultaneously or one after the other?
    it will do automatically, initially detection will happen so that it analyze what the High and Low sequence/SCN need to recovery of course you can check from v$archive_gap, Based on that it will fetch the archives from the primary to resolve the GAP.

    HTH.

Legend

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