V$ARCHIVED_LOG is not showing Archivelog SEQUENCE# after instance startup onwards / full history of
V$ARCHIVED_LOG is not showing Archivelog SEQUENCE# after instance startup onwards / full history of SEQ# archived. Please see the below Sql queries and output. It suppose to show ALL archivelogs archived or atleast from last instance startup. Please update for this.
<<
select to_char(STARTUP_TIME,'DD-MON-YY HH24:MI:SS') STARTUP_TIME from v$instance;
STARTUP_TIME
--------------------------
19-JUL-08 11:22:04
select SEQUENCE# , COMPLETION_TIME from v$archived_log where SEQUENCE# in ( select min(SEQUENCE#) from v$archived_log) ;
29043 05-JAN-09
29043 05-JAN-09
29043 05-JAN-09
>>