Get redo log member info - oracle database script

col member
FOR a56
SET pagesize 299
SET lines 299
SELECT l.group#, l.thread#, f.member,
                            l.archived,
                            l.status,
                            (bytes/1024/1024) "Size (MB)"
FROM v$log l,
     v$logfile f
WHERE f.group# = l.group# order by 1,2 /