This content has been marked as final. Show 1 reply
1) For manually resolving a gap, which one is the recommended method?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
-By using RMAN incremental backup Or
-By manually copying missing archived files to the standby and register them with Standby
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
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.