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>
- Current log sequence should be 108 (not 107)
- Oldest log Sequence should be 107 (not 108)
- Next log Sequence to archive should be 107 (not 108).
Can anyone please clarify?