Oldest Online Log Sequence
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Oldest Online Log Sequence

  1. #1
    Join Date
    Jun 2002
    Posts
    64
    Hi All,

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

    Cheers

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Check v$log_history

    Cheers

    Angel

  3. #3
    Join Date
    Jun 2002
    Posts
    64
    V$log_history shows all log sequence nos. Form these, how do I find which one is ' the oldest online log sequence'.



  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    What do you mean about "the oldest", the last online log or the first?

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    SVRMGR> archive log list;
    Sanjay

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Code:
    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

  7. #7
    Join Date
    Jun 2002
    Posts
    64
    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


  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    select min(sequence#) from v$log

    ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width