Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

archive log list output question

skumar dbaJan 13 2026 — edited Jan 13 2026

I am using Oracle pre-built VM for Oracle 26ai (single instance). Below is the output from v$log and ‘archive log list’.

archive log list output seems to be not in sync with the v$log output.

`GROUP#    THREAD#  SEQUENCE#    MEMBERS ARC STATUS`  

---------- ---------- ---------- ---------- --- ----------------
1 1 106 2 YES INACTIVE
2 1 107 2 YES INACTIVE
3 1 108 2 NO CURRENT

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 108
Next log sequence to archive 108
Current log sequence 107
SQL>

  1. Current log sequence should be 108 (not 107)
  2. Oldest log Sequence should be 107 (not 108)
  3. Next log Sequence to archive should be 107 (not 108).

Can anyone please clarify?

Comments
Post Details
Added on Jan 13 2026
4 comments
188 views