/*
Get online Redo Log files.
*/
SELECT GROUP#, MEMBER
FROM   sys.v$logfile;