col member format a40
select v$logfile.member,v$logfile.group#, v$log.status, bytes
from v$logfile, v$log
where v$logfile.group# = v$log.group#;


SQL> @LABS/redologfile

MEMBER                                      GROUP# STATUS                BYTES
---------------------------------------- ---------- ---------------- ----------
/home/human/oradata/HUMAN/redo01.log              1 CURRENT          104857600
/home/human/oradata/HUMAN/redo01b.rdo            1 CURRENT          104857600
/home/human/oradata/HUMAN/redo02.log              2 INACTIVE          104857600
/home/human/oradata/HUMAN/log02b.rdo              2 INACTIVE          104857600