Hi all,
Little problem on a production database.
My dataguard setup has all the required log files, but for some reason it stopped applying log.
My MRP process seems to be working correctly, but gets stuck applying a particular log file.
INST_ID PROCESS STATUS CLIENT_P THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
---------- --------- ------------ -------- ---------- ---------- ---------- ---------- ----------
2 MRP0 APPLYING_LOG N/A 1 84780 305057 1028249 0
It's a 3 node RAC, so just to be sure I shut down all 3 instances before starting just one and restarting the apply process.
I have no errors in my standby alert log. It just seems to start applying and stop.
This setup has been working for months with no problem but once in a while it stops applying.
Usually I just restart the apply process and everything is fine, but this time it won't apply.
Any ideas?