ADG主库上归档丢失恢复备库测试

模拟了下在主库上丢失归档导致备库出现gap，无需重建恢复备库的情况
1制造gap
主库
ALTER system SET log_archive_dest_state_2 = ‘defer’;
一些dml操作
alter system switch logfile;

备库此时的mrp是等待log状态
SQL> select process,client_process,sequence#,status from v$managed_standby;

PROCESS CLIENT_PROCESS SEQUENCE# STATUS

---

ARCH ARCH 0 CONNECTED
ARCH ARCH 0 CONNECTED
ARCH ARCH 0 CONNECTED
ARCH ARCH 22 CLOSING
RFS UNKNOWN 0 IDLE
RFS ARCH 0 IDLE
MRP0 N/A 23 WAIT_FOR_LOG

SQL> select * from v$archive_gap;

no rows selected
现在的这种情况oracle不认为是gap，所以没记录

主库上查看当前sequence
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data/arch
Oldest online log sequence 25
Next log sequence to archive 27
Current log sequence 27

从库查看应用的归档
SQL> select sequence#, applied from v$ar