Database Software

I have few doubts regarding the dataguard in 11g.i tried but unable to solve this issue.

my primary database is orcl
standby 1 is orcl1
standby 2 is orcl2

In standby 1 instance orcl1 the instance uses real time apply and all the archives were synced.
Since real time apply is used i dont find any archives received from the primary database.


In the standby2 orcl2 instance why my archives were not applied.How do i confirm that whether
the instance previously used redo apply or real time apply since no mrp process is active.

i am able to see the physical existence of the archived received from the primary database.
The archives physically exists but they are not getting applied.How can i find the cause and fix this.

The last applied archive is 7485.But the archived were physically existing



primary
-------


SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production


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

MAX(SEQUENCE#)
--------------
8580

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

standby 2 (Issue exits) -- Archives getting transferred but not getting applied here
----------

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED


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

MAX(SEQUENCE#)
--------------
8580

SQL> select max(sequence#),applied from v$archived_log group by applied;

MAX(SEQUENCE#) APP
-------------- ---
8580 NO

SQL> show parameter standby_file_management

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO



SQL> select PROCESS,PID,STATUS,SEQUENCE# from v$managed_standby;

PROCESS PID STATUS SEQUENCE#
--------- ---------- ------------ ----------
ARCH 5727 CLOSING 8052
ARCH 5729 CLOSING 8053
ARCH 5731 CLOSING 8054
ARCH 5733 CLOSING 8055
ARCH 5735 CLOSING 8215
RFS 20724 IDLE 0
RFS 20732 IDLE 0
RFS 20736 IDLE 0
RFS 10261 IDLE 8581

SQL> select message from v$dataguard_status;


MESSAGE
--------------------------------------------------------------------------------
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode


SQL> Select PROCESS,CLIENT_PROCESS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby where process = 'MRP0' or client_process='LGWR';

PROCESS CLIENT_P THREAD# SEQUENCE# BLOCK#
--------- -------- ---------- ---------- ----------
RFS LGWR 1 8581 13268


SQL> SELECT ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ# FROM V$ARCHIVE_DEST_STATUS;

ARCHIVED_THREAD# ARCHIVED_SEQ# APPLIED_THREAD# APPLIED_SEQ#
---------------- ------------- --------------- ------------
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
1 8215 0 0
1 8579 1 7485

11 rows selected.

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

MAX(SEQUENCE#)
--------------
7485

SQL> select RECOVERY_MODE from v$archive_dest_status;

RECOVERY_MODE
-----------------------
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE

11 rows selected.






standby 1 ------------>No problem in applying the archives (no physical transfer of archives from primary here )
----------

SQL> select protection_mode, protection_level from v$database;

PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

SQL> SELECT ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ# FROM V$ARCHIVE_DEST_STATUS;

ARCHIVED_THREAD# ARCHIVED_SEQ# APPLIED_THREAD# APPLIED_SEQ#
---------------- ------------- --------------- ------------
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
1 8580 0 0
1 8579 1 8579

11 rows selected.

SQL> Select PROCESS,CLIENT_PROCESS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby where process = 'MRP0' or client_process='LGWR';

PROCESS CLIENT_P THREAD# SEQUENCE# BLOCK#
--------- -------- ---------- ---------- ----------
RFS LGWR 1 8581 14467
MRP0 N/A 1 8581 14465

SQL> select PROCESS,PID,STATUS,SEQUENCE# from v$managed_standby;

PROCESS PID STATUS SEQUENCE#
--------- ---------- ------------ ----------
ARCH 5806 CLOSING 8580
ARCH 5808 CLOSING 8578
ARCH 5810 CLOSING 8573
ARCH 5812 CLOSING 8576
ARCH 5814 CLOSING 8579
RFS 6959 IDLE 8581
RFS 6977 IDLE 0
MRP0 6580 APPLYING_LOG 8581

8 rows selected.

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

MAX(SEQUENCE#)
--------------
8580



SQL> select RECOVERY_MODE from v$archive_dest_status;

RECOVERY_MODE
-----------------------
IDLE
MANAGED REAL TIME APPLY
IDLE
MANAGED REAL TIME APPLY
MANAGED REAL TIME APPLY
MANAGED REAL TIME APPLY
MANAGED REAL TIME APPLY
MANAGED REAL TIME APPLY
MANAGED REAL TIME APPLY
MANAGED REAL TIME APPLY
IDLE

11 rows selected.