SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------
1 1 0 104857600 1 YES UNUSED 0
2 1 0 104857600 1 YES UNUSED 0
3 1 1 104857600 1 NO CURRENT 190578 2007-04-22
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- --------------------------------------------------
3 ONLINE D:ORACLEORADATAHUZCREDO03.LOG
2 ONLINE D:ORACLEORADATAHUZCREDO02.LOG
1 ONLINE D:ORACLEORADATAHUZCREDO01.LOG
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/17826/viewspace-912022/ ，如需转载，请注明出处，否则将追究法律责任。
