We're using Oracle 10g Enterprise Edition.
I've created the physical standby database, and I've stated the MRP.
The archivedlog file are received like we can see on v$archived_log:
Code: Select all
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME, APPLIED
FROM V$ARCHIVED_LOG
ORDER BY SEQUENCE#;
SEQUENCE# FIRST_TIM NEXT_TIME APP
---------- --------- --------- ---
15767 27-OCT-11 27-OCT-11 NO
15768 27-OCT-11 27-OCT-11 NO
15769 28-OCT-11 28-OCT-11 NO
15770 28-OCT-11 28-OCT-11 NO
15771 28-OCT-11 28-OCT-11 NO
15772 28-OCT-11 28-OCT-11 NO
15773 28-OCT-11 28-OCT-11 NO
15774 28-OCT-11 28-OCT-11 NO
15775 28-OCT-11 28-OCT-11 NO
15776 29-OCT-11 29-OCT-11 NO
15777 29-OCT-11 29-OCT-11 NO
15778 29-OCT-11 29-OCT-11 NO
15779 29-OCT-11 29-OCT-11 NO
15780 29-OCT-11 29-OCT-11 NO
15781 29-OCT-11 29-OCT-11 NO
15782 29-OCT-11 29-OCT-11 NO
SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied",
2 (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
3 FROM
4 (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN
5 (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN
(SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
6 7 8 WHERE ARCH.THREAD# = APPL.THREAD#
ORDER BY 1; 9
Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
1 15782 15767 16
Several days and no archivedlog file wa applied.
Is there problem here? How can I apply in physical standby?
thank you very much!!!!