Database Administration (MOSC)

MOSC Banner

V$ARCHIVED_LOG is not showing Archivelog SEQUENCE# after instance startup onwards / full history of

edited Jan 25, 2009 1:48AM in Database Administration (MOSC) 7 comments
 Hi guys,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center