内容摘要：复制SQL>selectgroup#,status,memberfromv$logfile; GROUP#STATUSMEMBER -------

复制SQL> select group#,数据status,member from v$logfile;   GROUP# STATUS  MEMBER   ---------- ------- ----------------------------------------------------------------------   3         F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG   2         F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG   1         F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG   1         F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01_ADD.LOG   2         F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02_ADD.LOG   3         F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03_ADD.LOG  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.