SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
4354601
SQL> alter system switch logfile; (第一次切换日志就触发了checkpoint，但是这是一个非常lazy的过程，你可以等待，看看是否出发了checkpoint；或者再做一次切换，强制第一次的切换完成checkpoint)
System altered.
SQL> alter system switch logfile;
System altered.
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
4367504
checkpoint 对日志切换没有影响：
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 4 10485760 1 YES INACTIVE
4354601 18-JUN-04
2 1 5 10485760 1 YES INACTIVE
4367480 18-JUN-04
3 1 6 10485760 1 NO CURRENT
4367504 18-JUN-04
SQL> alter system checkpoint;
System altered.
SQL> r
1* alter system checkpoint
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 4 10485760 1 YES INACTIVE
4354601 18-JUN-04
2 1 5 10485760 1 YES INACTIVE
4367480 18-JUN-04
3 1 6 10485760 1 NO CURRENT
4367504 18-JUN-04
日志并没有切换，也没有归档
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/51862/viewspace-180552/ ，如需转载，请注明出处，否则将追究法律责任。
