我们在遇到物理Standby的主库和重库之间存在归档日志的GAP时可以安下面的步骤来完成。alert log中的信息如下：
Fetching gap sequence for thread 1, gap sequence 9360-9371
Trying FAL server: PROD
==>standby site
==>查看alert log的出错信息。
Fetching gap sequence for thread 1, gap sequence 9360-9371
Trying FAL server: PROD
==>primary site
==>恢复需要的archivelog,通常有GAP时在主库上对应该的archivelog已经不存了，需要做恢复
rman
connect target /
connect catalog rman/password@CATDB
run {
allocate channel t1 device type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=szvsx009,
NSR_CLIENT=szvsv112,
NSR_DEBUG_FILE=/tmp/ifxarc.out)';
restore archivelog from logseq 9360 until logseq 9371;
release channel t1;
}
==>移动恢复出来的归档日志到物理从库的对应该的archivelog目录中
mv /oradata/prod/arch1/* /oradata/stby/arch1/
==>standby site.
==>应用对应该的GAP掉的归档日志然后恢复到自动恢复的状态。
SQL> conn / as sysdba
SQL> alter database recover managed standby database cancel;
SQL> recover automatic standby database;
cancel
SQL> alter database recover managed standby database disconnect from session;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29987/viewspace-996328/ ，如需转载，请注明出处，否则将追究法律责任。
