4 Replies Latest reply: May 27, 2014 9:16 AM by BPeaslandDBA RSS

    MRP stuck in waiting_for_log condition

    SM.A

      Hello Every one,

      Environment :

      Db: 11gr2 64bit, Version: 11.2.0.1.0.

      OS: OEL 5.5

      Prod: testdr  (2 Node RAC)

      DR :testdb (2 Node RAC)

       

      The problem that I have is that MRP is stuck in waiting_for_log condition. Here is the result of the following query.

       

      On the Standby:

      select process, thread#, sequence#, status from v$managed_standby where process='MRP0';

      PROCESS               THREAD#           SEQUENCE# STATUS
      --------- ------------------- ------------------- ------------
      MRP0                        2                  88 WAIT_FOR_LOG

       

          SELECT sequence#, first_time, next_time, applied
          FROM   v$archived_log
          ORDER BY sequence#;

       

                       82 05-25-2014 21:24:13 05-25-2014 22:19:55 YES
                       82 05-25-2014 16:52:34 05-25-2014 16:58:12 YES
      ....
                       87 05-26-2014 13:05:54 05-26-2014 13:10:38 YES
                       88 05-25-2014 17:08:53 05-25-2014 17:11:21 YES
                       89 05-25-2014 17:11:21 05-25-2014 17:23:17 YES
      ....
                      112 05-26-2014 13:10:16 05-26-2014 13:10:21 YES
                      113 05-26-2014 13:10:21 05-26-2014 13:10:30 YES
                      114 05-26-2014 13:10:30 05-26-2014 13:13:34 NO

       

      At first, it was stuck at (waiting for log_sequence # 81) and unfortunately I had deleted all of the logs at the primary server so I took an incremental backup and did a recovery on the standby till the recent log (sequence# 112).

       

      After the recovery, MRP worked fine only for the first log and applied it correctly (Log Sequence # 113). Then after another manual switch log operation, it stopped applying. I checked it again and found out that now it is waiting for the log sequence #88.

       

      I can take incremental backup from the primary and reapply it on the secondary but will it solve this problem as it did not help before.

       

      Any help will be highly appreciated.

       

      Regards!