SQL>select log.group# ,log.sequence#,logf.member# from v$log log,v$logfile
logf where log.group=logf.group;
GROUP# SEQUENCE# MEMBER#
------- ---------- -----------------
1 101 /u01/oradata/orcl/redo001_1.log
1 101 /u01/oradata/orcl/redo001_2.log
2 102 /u01/oradata/orcl/redo002_1.log
2 102 /u01/oradata/orcl/redo002_2.log
3 103 /u01/oradata/orcl/redo003_1.log
3 103 /u01/oradata/orcl/redo003_2.log
|