select group#,l.sequence#,archived,l.status running, lf.status os_status,member from v$log l join v$logfile lf using(group#) order by group#;
NOTES:
- The STATUS column of v$logfile (os_status) is NOT refreshed in real-time. Information is updated on log switch.
