High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

MRP0 - wait_for_log

Hello everyone,

Maybe someone of you have experienced the same problem I am. I've configured Data guard from a RAC database (2 nodes) to Standalone Database with an active duplicate enabling Real-time apply.

The problem is as follows:

1.- "MRP0 - wait_for_log" detected in Standby database, logs are not applied anymore:

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS

--------- ------------ ---------- ---------- ---------- ----------

ARCH      CLOSING               1      19935     364544       1795

ARCH      CLOSING               1      19933     364544       1414

ARCH      CONNECTED             0          0          0          0

ARCH      CLOSING               1      19934     364544       1277

RFS       IDLE                  1      19936     268946          8

RFS       IDLE                  0          0          0          0

MRP0      WAIT_FOR_LOG          2       5052          0          0

MAX(SEQUENCE#)THREAD#

-------------- ----------

     19916      1
      5051      2

- In alert of Standby:

"Media Recovery Waiting for thread 1 sequence 19917 (in transit)"

"Media Recovery Waiting for thread 2 sequence 5052"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center