|
|
Re: Archived applied status showing NO in v$archived_log [message #599284 is a reply to message #599257] |
Wed, 23 October 2013 08:28 |
|
Hi,Please find My MRP status and log_history
MRP status:
SQL> select process, thread#, sequence#, status from v$managed_standby where process='MRP0';
PROCESS THREAD# SEQUENCE# STATUS
--------- ---------- ---------- ------------
MRP0 1 67196 WAIT_FOR_GAP
Archived_Log:
SQL> select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;
no rows selected
SQL>
Log_history status:
SQL> select thread#,max(sequence#) from v$log_history group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 67581
2 39511
3 40117
SQL>
All are in standby database as per me log_history showing sequence are up to date but my MRP still waiting for old log.
Regards,
Anil
|
|
|
|
|
|
|