Search notes:

v$logfile

This view can be queried to find the filenames, group numbers, log type (online or standby) and states of redo log files.
For example, to find all files of log group 2, use
select
  member
from
  v$logfile
where
  group# = 2

See also

Compare with v$log
Oracle Dynamic Performance Views

Index