SQL>select group,sequence,archived,status from v$log
GROUP# SEQUENCE# ARCHIVED STATUS
1 193938 YES ACTIVE
2 193939 NO CURRENT
3 193937 YES INACTIVE
9 193936 YES INACTIVE
My Oracle database was in archived mode. And if an online redo log file was in "active" status, It meant that it was being archived. If it was in "inactive" status, it meant that it has already been archived and it can be reused again . Am i right ?
In addition , if my oracle database was in noarchived mode, What's the difference between "active" and "inactive" status of an online redo log file.