7 Replies Latest reply: Jan 13, 2014 12:19 AM by Anar Godjaev RSS

    Standby MRP0 process- Wait for Log

    User478743-OC

      Hi ,

       

      I have standby Oracle 11.2.0.3 DB on  AIx  server .

       

      After configuring Dataguard Log apply service fails on standby DB ..Following is resulf from my standy and primary DB .

       

      On Primary

      select process, status, sequence#, block# from v$managed_standby;

       

      PROCESS   STATUS        SEQUENCE#     BLOCK#

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

      ARCH      CLOSING              52          1

      ARCH      CLOSING              51          1

      ARCH      WRITING               2      38913

      ARCH      CLOSING              52          1

      LNS       WRITING              54       1003

       

      On Standby

      select process, status, sequence#, block# from v$managed_standby;

       

      PROCESS   STATUS        SEQUENCE#     BLOCK#

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

      ARCH      CONNECTED             0          0

      ARCH      CONNECTED             0          0

      ARCH      CONNECTED             0          0

      ARCH      CONNECTED             0          0

      RFS       RECEIVING                  2       6145

      RFS       IDLE                              54      1025

      RFS       IDLE                              0          0

      MRP0      WAIT_FOR_LOG      2          0

      On primaray Datagaurd status shows below output

       

      select  message from  V$DATAGUARD_STATUS order by TIMESTAMP;

       

      ARCH: Completed archiving thread 1 sequence 53 (1093671-1094088)
      ARCH: Beginning to archive thread 1 sequence 53 (1093671-1094088)
      LNS: Beginning to archive log 3 thread 1 sequence 54

      MESSAGE
      --------------------------------------------------------------------------------
      LNS: Completed archiving log 2 thread 1 sequence 53

       

      On Standby DB

       

      select  message from  V$DATAGUARD_STATUS order by TIMESTAMP;

       

      MESSAGE

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

      RFS[2]: Assigned to RFS process 659510

      RFS[2]: No standby redo logfiles available for thread 1

      RFS[3]: Assigned to RFS process 1110268

      RFS[3]: No standby redo logfiles available for thread 1

      Attempt to start background Managed Standby Recovery process

      MRP0: Background Managed Standby Recovery process started

      Managed Standby Recovery starting Real Time Apply

      Media Recovery Waiting for thread 1 sequence 2 (in transit)

       

       

      Please let me know what needs ti change for start log apply on physical standby .

       

      Thanks .

      Vaishali.

        • 1. Re: Standby MRP0 process- Wait for Log
          Shivananda Rao

          Hello,

           

          What is the error messages you see in the alert logs of both primary and standby databases ?

           

          From Primary, please post:

           

          SQL>select severity,error_code,message from v$dataguard_status where dest_id=2;

           

           

          Also, try to stop and start the Recovery on the standby database.

          SQL>alter database recover managed standby database cancel;

          SQL>alter database recover managed standby database disconnect from session;

           

           

          Regards,

          Shivananda

          • 2. Re: Standby MRP0 process- Wait for Log
            Anar Godjaev

            HI,

             

            1) Can you please paste result query in Primary database:

             

            SELECT status, error

            FROM V$ARCHIVE_DEST_STATUS

            WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';

             

            2) can you please paste result in Secondary Location:

             

            select name, value from v$dataguard_Stats;

             

            Thank you

            • 3. Re: Standby MRP0 process- Wait for Log
              Balazs Papp

              RFS[2]: Assigned to RFS process 659510

              RFS[2]: No standby redo logfiles available for thread 1

              RFS[3]: Assigned to RFS process 1110268

              RFS[3]: No standby redo logfiles available for thread 1

              Without standby redo logs, the database has nowhere to write the current redo, so it will wait for the current redo log to be archived.

              Create the standby redo logs.

              • 4. Re: Standby MRP0 process- Wait for Log
                Baris Yildirim

                Hi,

                Check the arhived log, seq 2, on the standby side. if it doesn't exist, copy and register it.

                 

                 

                 

                Regards

                • 5. Re: Standby MRP0 process- Wait for Log
                  User478743-OC

                  HI Anar,

                   

                  SQL> SQL> SELECT status, error FROM V$ARCHIVE_DEST_STATUS  WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';

                  STATUS    ERROR
                  --------- -----------------------------------------------------------------
                  VALID
                  VALID

                  Also

                   

                  SQL> select name, value from v$dataguard_Stats;


                  NAME
                  --------------------------------
                  VALUE
                  ----------------------------------------------------------------
                  transport lag
                  +00 00:00:00

                  apply lag
                  +00 00:19:03

                  apply finish time

                   

                  NAME
                  --------------------------------
                  VALUE
                  ----------------------------------------------------------------
                  estimated startup time
                  14

                   

                   

                  Thanks .

                  • 6. Re: Standby MRP0 process- Wait for Log
                    User478743-OC

                    Hi Shivananda,

                     

                    Please find below output ..

                     

                    I can tnsping both the database as well as when i try to connect from sqlplus to DB ..it was sucessful from both the side ...

                     

                     

                    SQL> select severity,error_code,message from v$dataguard_status where dest_id=2;

                    SEVERITY      ERROR_CODE
                    ------------- ----------
                    MESSAGE
                    --------------------------------------------------------------------------------
                    Error               1034
                    PING[ARC2]: Heartbeat failed to connect to standby 'IHISDR'. Error is 1034.

                    Error               1034
                    FAL[server, ARC2]: Error 1034 creating remote archivelog file 'IHISDR'

                    Error               1089
                    FAL[server, ARC2]: FAL archival, error 1089 closing archivelog file 'IHISDR'


                    SEVERITY      ERROR_CODE
                    ------------- ----------
                    MESSAGE
                    --------------------------------------------------------------------------------
                    Warning             1089
                    LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (1089)

                    Warning             1089
                    LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned

                    Error               1089
                    Error 1089 for archive log file 1 to 'IHISDR'


                    SEVERITY      ERROR_CODE
                    ------------- ----------
                    MESSAGE
                    --------------------------------------------------------------------------------
                    Error               1089
                    FAL[server, ARC0]: FAL archival, error 1089 closing archivelog file 'IHISDR'


                    7 rows selected.

                    Thanks .

                    • 7. Re: Standby MRP0 process- Wait for Log
                      Anar Godjaev

                      Ok,

                       

                      SQL> select name, value from v$dataguard_Stats;


                      NAME
                      --------------------------------
                      VALUE
                      ----------------------------------------------------------------
                      transport lag
                      +00 00:00:00

                      apply lag
                      +00 00:19:03

                      apply finish time

                       

                      NAME
                      --------------------------------
                      VALUE
                      ----------------------------------------------------------------
                      estimated startup time
                      14

                       

                       

                      >apply lag

                      +00 00:19:03

                       

                      Apply it is working . Can you please check network connection in Primary and Secondary location? In my opinion you problem is network connection.

                       

                      Thank you