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