8 Replies Latest reply: Mar 25, 2013 8:53 PM by user3266490 RSS

    Dg : Archive not applied on standby

    user3266490
      Hi,

      We recently configured data guard in test machine.Archives not applied in physical standby.
      Where i need to start investigation?

      Primary


      SQL> select THREAD#,max(sequence#) from v$archived_log where applied='YES' group by thread#;

      THREAD# MAX(SEQUENCE#)
      ---------- --------------
      1 301

      SQL> select thread#,max(sequence#) current_seq from gv$log group by thread# order by 1;

      THREAD# CURRENT_SEQ
      ---------- -----------
      1 334



      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      log_archive_dest_2 string service=PP0410DG, LGWR ASYNC N
      OAFFIRM delay=0 OPTIONAL max_f
      ailure=0 max_connections=1 r
      eopen=300 db_unique_name="PP04
      10DG" register net_timeout=180
      valid_for=(online_logfile,pr
      imary_role)

      Standby

      SQL> select thread#,max(sequence#) current_seq from gv$log group by thread# order by 1;

      THREAD# CURRENT_SEQ
      ---------- -----------
      1 333

      SQL> select THREAD#,max(sequence#) from v$archived_log where applied='YES' group by thread#;

      THREAD# MAX(SEQUENCE#)
      ---------- --------------
      1 301

      Thanks & Regards,
      VN
        • 1. Re: Dg : Archive not applied on standby
          Sunny kichloo
          Share the output of below query on standby database

          SQL>select process,status from v$managed_standby;

          Also if MRP process is not running start it

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


          Better close your thread here and move it to do this part of forum

          {forum:id=849}
          • 2. Re: Dg : Archive not applied on standby
            Chanchal Wankhade
            Hi,

            Post your output of the below queries.
            on Primary-------
            
            select max(sequence#) from v$archived_log;
            on Standby
            
            select name,process from v$managed_standby;
            
            select max(sequence#) from v$log_history;
            • 3. Re: Dg : Archive not applied on standby
              user3266490
              Hi,

              Thanks for your reply.
              Please see below info.

              Primary

              SQL> select max(sequence#) from v$archived_log;

              MAX(SEQUENCE#)
              --------------
              334

              SQL> /

              MAX(SEQUENCE#)
              --------------
              335



              Standby


              SQL> SQL> select max(sequence#) from v$log_history;

              MAX(SEQUENCE#)
              --------------
              301

              I didn't find any cloumn "NAME " in v$managed_Standby.
              SQL> select process,status from v$managed_standby;


              PROCESS STATUS
              --------- ------------
              ARCH CLOSING
              ARCH CLOSING
              ARCH CONNECTED
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              ARCH CLOSING
              RFS IDLE
              RFS IDLE
              RFS RECEIVING
              RFS RECEIVING
              RFS IDLE
              RFS IDLE
              RFS IDLE
              RFS IDLE
              RFS IDLE
              RFS IDLE
              RFS IDLE
              RFS RECEIVING
              RFS IDLE
              RFS IDLE

              29 rows selected.

              SQL> select open_mode from v$database;

              OPEN_MODE
              --------------------
              READ ONLY

              Thanks & Regards,
              VN

              Edited by: user3266490 on Mar 25, 2013 1:07 PM
              • 4. Re: Dg : Archive not applied on standby
                Sunny kichloo
                Try to start MRP as suggested by me.It will help as MRP is not running.
                      user3266490      
                       Newbie
                       
                Handle:      user3266490  
                Status Level:      Newbie (25)
                Registered:      Nov 26, 2008
                Total Posts:      1,420
                Total Questions:      828 (669 unresolved) 
                Always try to close your thread.
                • 5. Re: Dg : Archive not applied on standby
                  Chanchal Wankhade
                  Hi,

                  Now got the error.

                  Your MRP process is not running so you would need to start it.

                  The services required on the primary database are:

                  Log Writer Process (LGWR) - Collects redo information and updates the online redo logs. It can also create local archived redo logs and transmit online redo to standby databases.
                  Archiver Process (ARCn) - One or more archiver processes make copies of online redo logs either locally or remotely for standby databases.
                  Fetch Archive Log (FAL) Server - Services requests for archive redo logs from FAL clients running on multiple standby databases. Multiple FAL servers can be run on a primary database, one for each FAL request. .
                  The services required on the standby database are:

                  Fetch Archive Log (FAL) Client - Pulls archived redo log files from the primary site. Initiates transfer of archived redo logs when it detects a gap sequence.
                  Remote File Server (RFS) - Receives archived and/or standby redo logs from the primary database.
                  Archiver (ARCn) Processes - Archives the standby redo logs applied by the managed recovery process (MRP).
                  Managed Recovery Process (MRP) - Applies archive redo log information to the standby database.


                  on standby database execute the below query.
                  alter database recover managed standby database disconnect from session;
                  Please find below link for more information.
                  http://www.oracle-base.com/articles/9i/data-guard.php
                  • 6. Re: Dg : Archive not applied on standby
                    user3266490
                    Hi,

                    Thanks for your reply.

                    When executed the below query select thread#,max(sequence#) current_seq from gv$log group by thread# order by 1; on primary and standby .It shows *334,333 respectively*.

                    When executed the bleow query select THREAD#,max(sequence#) from v$archived_log where applied='YES' group by thread#;
                    on primary and standby .It shows *301,301 respectively.*

                    Now the db is in read only mode.
                    I am confused with values (334,333 and 301,301).

                    Thanks & Regards,
                    VN
                    • 7. Re: Dg : Archive not applied on standby
                      Sunny kichloo
                      Have you tried starting MRP Process on standby database ???
                      • 8. Re: Dg : Archive not applied on standby
                        user3266490
                        Hi,

                        It's working now. started MRP process.

                        Thanks & Regards,
                        VN