Oldest Online Log Sequence

[najmalp]

Hi All,

How to find out the oldest online log sequence from the data dictionary?

Cheers

[aarroyob]

Check v$log_history

Cheers

Angel

[najmalp]

V$log_history shows all log sequence nos. Form these, how do I find which one is ' the oldest online log sequence'.

[aarroyob]

What do you mean about "the oldest", the last online log or the first?

[SANJAY_G]

SVRMGR> archive log list;

Sanjay

[pando]

sys@DSIM>select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------------
         1          1        977  104857600          2 NO  INACTIVE              78845784 2002 JUL 23 01:45:21
         2          1        978  104857600          2 NO  INACTIVE              78848480 2002 JUL 23 01:53:38
         3          1        979  104857600          2 NO  ACTIVE                78851046 2002 JUL 23 02:02:01
         4          1        980  104857600          2 NO  CURRENT               78854780 2002 JUL 23 12:00:59

my oldest online sequence is 980

[najmalp]

Hi,

Here is what ARCHIVE LOG LIST gives.

SVRMGR> archive log list
Database log mode Archive Mode
Automatic archival Disabled
Archive destination /nbd07/oracle/product/8.1.5/dbs/arch

Oldest online log sequence 13
Next log sequence to archive 16
Current log sequence 16


The Oldest online log sequence shows here is 13. The question
is, how can we identify this no. from those v$views


Cheers

[pando]

select min(sequence#) from v$log

?