dataguard mrp0 process error

Posted by Roshan on Sep 18, 2017; 8:33am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/dataguard-mrp0-process-error-tp3508.html

Hi Erman,

environment details: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
Red Hat Linux

on my standby database, I see there is no archive gap.
SQL> select * from v$ARCHIVE_GAP;

no rows selected

However, the mrp0 process is in 'wait for log state'

   THREAD# PROCESS          PID STATUS       CLIENT_P
---------- --------- ---------- ------------ --------
CLIENT_PID                                SEQUENCE#     BLOCK# ACTIVE_AGENTS
---------------------------------------- ---------- ---------- -------------
KNOWN_AGENTS
------------
         1 MRP0           23139 WAIT_FOR_LOG N/A
N/A                                          165329          0             9


I have already register the log and restarted mrp0. Can you please advise why archive logs are not being applied?

Regards,

Roshan

Thanks