看输出:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ -------------------- ------------- --------------
1 1 2 52428800 1 YES ACTIVE 479308 24-6? -09
2 1 3 52428800 1 NO CURRENT 479371 24-6? -09
3 1 1 52428800 1 YES INACTIVE 477894 24-6? -09
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ -------------------- ------------- --------------
1 1 2 52428800 1 YES ACTIVE 479308 24-6? -09
2 1 3 52428800 1 YES ACTIVE 479371 24-6? -09
3 1 4 52428800 1 NO CURRENT 479461 24-6? -09
SQL> alter system checkpoint;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ -------------------- ------------- --------------
1 1 2 52428800 1 YES INACTIVE 479308 24-6? -09
2 1 3 52428800 1 YES INACTIVE 479371 24-6? -09
3 1 4 52428800 1 NO CURRENT 479461 24-6? -09
不是说日志切换的时候会触发检查点吗,为什么切换日志的效果和手动执行检查点的效果不一样呢?真纳闷啊。
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ -------------------- ------------- --------------
1 1 5 52428800 1 NO CURRENT 479583 24-6? -09
2 1 3 52428800 1 YES INACTIVE 479371 24-6? -09
3 1 4 52428800 1 YES ACTIVE 479461 24-6? -09
SQL> alter system checkpoint;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ -------------------- ------------- --------------
1 1 5 52428800 1 NO CURRENT 479583 24-6? -09
2 1 3 52428800 1 YES INACTIVE 479371 24-6? -09
3 1 4 52428800 1 YES INACTIVE 479461 24-6? -09
请各位解答一下,谢谢了。