1 Reply Latest reply: Mar 23, 2013 12:55 AM by CKPT RSS

    Manually Gap Detection & Resolution

    986452
      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
          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.