Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as ssfxpg
SQL>
SQL> alter database clear logfile group 3;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 203 104857600 1 NO CURRENT 7177324 2008-3-12 6
2 1 201 104857600 1 NO INACTIVE 6976247 2008-3-11 1
3 1 0 104857600 1 NO UNUSED 7016482 2008-3-11 1
SQL> alter database clear logfile group 2;
Database altered
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 203 104857600 1 NO ACTIVE 7177324 2008-3-12 6
2 1 204 104857600 1 NO CURRENT 7206347 2008-3-12 9
3 1 0 104857600 1 NO UNUSED 7016482 2008-3-11 1
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 203 104857600 1 NO INACTIVE 7177324 2008-3-12 6
2 1 204 104857600 1 NO INACTIVE 7206347 2008-3-12 9
3 1 205 104857600 1 NO CURRENT 7206352 2008-3-12 9
SQL> alter database clear logfile group 1;
Database altered
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 206 104857600 1 NO CURRENT 7206431 2008-3-12 9
2 1 204 104857600 1 NO INACTIVE 7206347 2008-3-12 9
3 1 205 104857600 1 NO ACTIVE 7206352 2008-3-12 9
SQL>
阅读(1769) | 评论(0) | 转发(0) |
