DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009

    archive log list output

    I just manually created an Oracle 10g database.

    I placed the database in archive mode and ran archive log list and got the
    following output (see below). I have a few questions.

    1) Why is the oldest online log set to 154, I would expect 0 or 1 since
    this is a brand new database and I just enabled archiving

    2) why is there a difference of 2 and not 1 between oldest online log sequence and next log sequence (154 vs 156, instead of 154 vs 155).

    3) I there anyway to reset these numbers back to zero since I don't have
    any archive logs created.

    SQL> alter database archivelog;

    Database altered.

    SQL> archive log list;
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination /ctron/oracle/pbh10.2.0/arch
    Oldest online log sequence 154
    Next log sequence to archive 156
    Current log sequence 156

  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    I think you are under the impression log sequence number is somehow related to having the database set to archivelog mode; this is incorrect.

    No matter if your database is set to archivelog or noarchivelog mode sequence number is increased by "1" each time a log switch happens.

    You can certainly reset sequence log back to "1" by opening the database with "reset logs" option even when I see no practical reason to do that.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2009
    Thank you for the clarification, now it makes sense

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

By using this site, you agree to the Privacy Policy