redo log list

--------------------------------------------------------------------------------

SELECT GROUP#, STATUS, TYPE, MEMBER, IS_RECOVERY_DEST_FILE
  FROM GV$LOGFILE
 ORDER BY GROUP#, MEMBER;

--------------------------------------------------------------------------------

SELECT *
  FROM V$LOG
 ORDER BY GROUP#;

--------------------------------------------------------------------------------

SELECT A.GROUP#, A.MEMBER, B.STATUS, B.BYTES/1024/1024 AS MBytes
  FROM V$LOGFILE A, V$LOG B WHERE A.GROUP# = B.GROUP#
 ORDER BY A.GROUP#, A.MEMBER;

--------------------------------------------------------------------------------

SELECT *
  FROM V$LOG_HISTORY
 ORDER BY SEQUENCE# DESC;

--------------------------------------------------------------------------------