主库查看是否有GAP

SELECT STATUS,GAP_STATUS FROM V$ARCHIVE_DEST_STATUS WHERE DEST_ID=2;

备库查看

SELECT * FROM V$ARCHIVE_GAP;

一、可以将归档拷贝到备库的情况

1.abort

备库在没recover cancel的情况下，备库：startup mount

alter database register logfile '/home/oracle/arch1.log'

补全gap

alter database open;

如有问题，下面的执行

alter database recover managed standby database cancel;

alter database recover managed standby database using current logfile disconnect;

备库如果recover cancel了，直接startup

补全gap

alter database recover managed standby database using current logfile disconnect;

2.备库shutdown immediate，copy日志

startup 

alter database register logfile '/u01/app/oracle/fast_recovery_area/PJ_XMC/archivelog/2021_01_04/o1_mf_1_32_hz4cdz6h_.arc';

recover managed standby database using current logfile disconnect;

二、备库gap，不能拷贝归档 文档 ID 1537316.1

If a Gap cannot be resolved with any of the previous Methods, the Gap is quite large and may take a long Time to resolve or the Gap cannot be resolved because the missing ArchiveLogs do not exist on any Database any more, you can still roll forward a Physical Standby Database using an incremental Backup from SCN. This Feature is available since Oracle 10.2.0. The Idea is to record the latest SCN applied to the Standby Database, then create an incremental Backup from that SCN on Primary Database using RMAN together with a Backup of the current Controlfile (as Standby Controlfile).

startup mount

recover managed standby database cancel;

select current_scn from v$database;

主备份控制文件

alter database create standby controlfile as '/home/oracle/standby.ctl';

BACKUP INCREMENTAL FROM SCN 4235170 database format '/home/oracle/stangapincre_%d_%T_%s_%p.bkp';

 scp stan* 192.168.12.66:/home/oracle/

备库

shutdown abort

startup nomount

RMAN> restore standby controlfile from '/home/oracle/standby.ctl';

RMAN> alter database mount;

RMAN> catalog start with '/home/oracle/xmc' noprompt;

RMAN> recover database noredo;

注意如果文件路径不同(就算不同也，不一定需要），可用如下语句注册

RMAN>catalog start with '+DATA/datafile/';

SQL> alter database open;

recover managed standby database using current logfile disconnect;