select
  l.group#,
  member,
  sequence# LOG_SEQ#,
  bytes/1024/1024 MBYTES,
  archived,
  to_char(first_time,'YYYY-MM-DD HH:MI.SS') SCN_TIME,
  l.status LOG_STATUS,
  nvl(lf.status,'Used') LOG_FILE_STAT
from 
  v$log l,
  v$logfile lf
where l.group# = lf.group#
order by l.group#
