This content has been marked as final. Show 3 replies
I hesitate to answer your question because you are not doing a good job of keeping the forum clean :
Total Questions: 13 (13 unresolved)
Please consider closing some of you old answered questions and rewarding those who helped you.
No action necessary.
Do you really have a thread 2? ( Redo thread number )
Use the DBA_LOGSTDBY_LOG View if you don't have a thread 2 then the sequence# is meaningless.
select applied_scn,latest_scn from v$logstdby_progress;
Logical Standby questions are difficult, not a lot of them out there I'm thinking.
COLUMN DICT_BEGIN FORMAT A10; SELECT FILE_NAME, SEQUENCE#, FIRST_CHANGE#, NEXT_CHANGE#, TIMESTAMP, DICT_BEGIN, DICT_END, THREAD# AS THR# FROM DBA_LOGSTDBY_LOG ORDER BY SEQUENCE#;
"Waiting On Gap State" ( However I still believe you don't have a 2nd thread# )
Edited by: mseberg on Apr 26, 2012 5:13 PM
There is thread 2. See query below. The sequence of CURRENT just doesnt move forward...
SQL> SELECT THREAD#, L.SEQUENCE#, L.FIRST_TIME,
(CASE WHEN L.NEXT_CHANGE# < P.READ_SCN THEN 'YES' WHEN L.FIRST_CHANGE# < P.APPLIED_SCN THEN 'CURRENT' ELSE 'NO' END) APPLIED FROM DBA_LOGSTDBY_LOG L, DBA_LOGSTDBY_PROGRESS P ORDER BY THREAD#, SEQUENCE#;
THREAD# SEQUENCE# FIRST_TIM APPLIED
---------- ---------- --------- -------
1 2738 25-APR-12 CURRENT
1 2739 25-APR-12 NO
1 2740 25-APR-12 NO
1 2741 25-APR-12 NO
1 2742 25-APR-12 NO
1 2743 25-APR-12 NO
1 2744 25-APR-12 NO
1 2745 26-APR-12 NO
1 2746 26-APR-12 NO
1 2747 26-APR-12 NO
1 2748 26-APR-12 NO
2 2661 25-APR-12 YES
2 2662 26-APR-12 NO
2 2663 26-APR-12 NO
2 2664 26-APR-12 NO
2 2665 26-APR-12 NO
2 2666 26-APR-12 NO
2 2667 26-APR-12 NO
2 2668 26-APR-12 NO
You are correct. ( I would have bet against that and lost! ).
Thank you for cleaning up your old questions too.
OK, in this case the alert log(s) are you best friend. There should be something or something else which gives a strong clue to the issue in one of both of them.
You should be able to find the last statement SQL Apply tried to apply using :
You see if any activity is occurring by
SELECT XIDUSN, XIDSLT, XIDSQN, STATUS, STATUS_CODE FROM DBA_LOGSTDBY_EVENTS WHERE EVENT_TIME = (SELECT MAX(EVENT_TIME) FROM DBA_LOGSTDBY_EVENTS);
The SCN should change if SQL Apply is working.
SELECT APPLIED_SCN, APPLIED_TIME, READ_SCN, READ_TIME, NEWEST_SCN, NEWEST_TIME FROM DBA_LOGSTDBY_PROGRESS;
Hopefully I have no typos in the above as it is very late here.
SELECT TYPE, HIGH_SCN, STATUS FROM V$LOGSTDBY;
Edited by: mseberg on Apr 26, 2012 8:59 PM