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"