DBA Redo Log Files

select
gl.inst_id,
gl.group#,
gl.members,
gl.status,
gl.first_time,
gl.next_time,
glf.member,
glf.type file_type,
glf.is_recovery_dest_file
from
gv$log gl,
gv$logfile glf
where
gl.inst_id=glf.inst_id and
gl.group#=glf.group#
order by
gl.inst_id,
gl.group#

select gl.inst_id, gl.group#, gl.members, gl.status, gl.first_time, gl.next_time, glf.member, glf.type file_type, glf.is_recovery_dest_file from gv$log gl, gv$logfile glf where gl.inst_id=glf.inst_id and gl.group#=glf.group# order by gl.inst_id, gl.group#