VIEW: SYS.GV_$LOGFILE

Source

View Text - Preformatted

select "INST_ID","GROUP#","STATUS","TYPE","MEMBER","IS_RECOVERY_DEST_FILE","CON_ID" from gv$logfile

View Text - HTML Formatted

SELECT "INST_ID"
, "GROUP#"
, "STATUS"
, "TYPE"
, "MEMBER"
, "IS_RECOVERY_DEST_FILE"
, "CON_ID"
FROM GV$LOGFILE