v$logfile

This view can be queried to find the filenames, group numbers and states of redo log files. For example, to find all files of group 2, use 

select member 
from v$logfile 
where group# = 2 

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 STATUS                                             VARCHAR2(7)
 TYPE                                               VARCHAR2(7)
 MEMBER                                             VARCHAR2(513)

 

Home