2 Replies Latest reply: Jan 20, 2013 6:53 AM by Osama_Mustafa RSS

    Standy database MRP0 is not applying logs

    902332
      Hi all,

      i am using oracle 11.1.0.7.0 database on linux

      standby database is receving archives but not applying to to standby.

      CTED 0 0 0 0
      ARCH ARCH CONNECTED 0 0 0 0

      PROCESS CLIENT_P STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
      --------- -------- ------------ ---------- ---------- ---------- ----------
      ARCH ARCH CONNECTED 0 0 0 0
      ARCH ARCH CONNECTED 0 0 0 0
      ARCH ARCH CONNECTED 0 0 0 0
      ARCH ARCH CONNECTED 0 0 0 0
      ARCH ARCH CONNECTED 0 0 0 0
      ARCH ARCH CONNECTED 0 0 0 0
      ARCH ARCH CONNECTED 0 0 0 0
      ARCH ARCH CONNECTED 0 0 0 0
      RFS LGWR RECEIVING 1 66141 33298 2
      RFS UNKNOWN IDLE 0 0 0 0
      MRP0 N/A WAIT_FOR_GAP 1 66003 0 0

      PROCESS CLIENT_P STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
      --------- -------- ------------ ---------- ---------- ---------- ----------
      RFS UNKNOWN IDLE 0 0 0 0

      34 rows selected.


      please help to fix this

      thank you