This discussion is archived
8 Replies Latest reply: Mar 25, 2013 6:53 PM by user3266490 RSS

Dg : Archive not applied on standby

user3266490 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    Have you tried starting MRP Process on standby database ???
  • 8. Re: Dg : Archive not applied on standby
    user3266490 Newbie
    Currently Being Moderated
    Hi,

    It's working now. started MRP process.

    Thanks & Regards,
    VN

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points