Database Software

Hi,

The MRP process status says wait_for_gap but no gaps found in v$archive_gap.

On Physical Standby Database:

Version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

SQL> select process,status,THREAD#,SEQUENCE# from v$managed_standby;

PROCESS STATUS THREAD# SEQUENCE#
--------- ------------ ---------- ----------
ARCH CLOSING 2 3509
ARCH CLOSING 1 3295
RFS IDLE 0 0
RFS IDLE 1 3296
MRP0 WAIT_FOR_GAP 1 2064
RFS IDLE 4 5359
RFS IDLE 0 0

SQL> select * from v$archive_gap;

no rows selected

SQL> select THREAD#,SEQUENCE#,APPLIED from v$archived_log where THREAD#=1 and SEQUENCE#=2064;

THREAD# SEQUENCE# APP
---------- ---------- ---
1 2064 YES
1 2064 YES

I see that MRP is stuck at Thread 1 sequence 2064, but that is not found in v$archive_gap and also I see it has already been applied in v$archived_log. Any ideas why does it still says wait_for_gap? Please help.

Thanks in Advance!

RK