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#;
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;