ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 17D7AF6F75DE1CC4E0630100007F9173 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# Y US DBA Redo Log Files Enginatics