-rw-r----- 1 oracle oinstall 20979712 Nov 15 09:23 drsys01.dbf
-rw-r----- 1 oracle oinstall 26222592 Nov 15 09:23 indx01.dbf
-rw-r----- 1 oracle oinstall 20979712 Nov 15 09:23 odm01.dbf
-rw-r----- 1 oracle oinstall 0 Nov 15 11:12 redo01.log
-rw-r----- 1 oracle oinstall 2097664 Nov 15 05:48 redo02.log
-rw-r----- 1 oracle oinstall 2097664 Nov 15 08:52 redo03.log
-rw-r----- 1 oracle oinstall 387981312 Nov 15 10:57 system01.dbf
-rw-r----- 1 oracle oinstall 52436992 Nov 15 09:23 system02.dbf
-rw-r----- 1 oracle oinstall 42999808 Nov 1 14:16 temp01.dbf
-rw-r----- 1 oracle oinstall 10493952 Nov 15 09:23 tools01.dbf
-rw-r----- 1 oracle oinstall 52436992 Nov 15 11:11 undotbs2.dbf
-rw-r----- 1 oracle oinstall 26222592 Nov 15 09:23 users01.dbf
-rw-r----- 1 oracle oinstall 47194112 Nov 15 09:23 xdb01.dbf
[oracle@ts01 TSMISC02]$
回到SESSION2：
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
1 1 62 2097152 1 NO CURRENT
658443 15-NOV-05
2 1 60 2097152 1 YES INACTIVE
641419 15-NOV-05
3 1 61 2097152 1 YES INACTIVE
649920 15-NOV-05
IXDBA.NET技术社区
SQL> set linesize 132
SQL> l
1* select * from v$log
SQL> /
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- -- 1 1 62 2097152 1 NO CURRENT 658443 15-NOV-05
2 1 60 2097152 1 YES INACTIVE 641419 15-NOV-05
