DataGuard问题集2 -- MRP0一直显示WAIT_FOR_GAP

DataGuard问题集2
– MRP0一直显示WAIT_FOR_GAP

现象：
MRP0一直显示WAIT_FOR_GAP的状态。

有了上次的教训，这次看到MRP0一直是WAIT_FOR_GAP的状态，先看看StandbyREDO是否正确构建了，答案是完全没问题。

接下来确认各种信息：
Standby端的结果：

SQL> select process,status from gv$managed_standby where process like 'MRP%';

PROCESS    STATUS
--------------------------- ------------------------------------
MRP0    WAIT_FOR_GAP★★


SQL> SELECT PROCESS,CLIENT_PROCESS C_PROCESS,STATUS,THREAD#,SEQUENCE#,BLOCK#,BLOCKS FROM GV$MANAGED_S

PROCESS    C_PROCESS  STATUS    THREAD#  SEQUENCE#   BLOCK#     BLOCKS
---------- ---------- ---------- ---------- ---------- ---------- ----------
ARCH   ARCH       CLOSING  2  2009 1  23
DGRD   N/A      ALLOCATED  0     0 0   0
・・・
RFS   LGWR       IDLE  2  2010   745932   1
MRP0   N/A      WAIT_FOR_G  2  2002 0   0★★

===＞MRP0在等待应用Thread２Seq 2002.

SQL> select inst_id,t