oracle 检查点原理,深入理解检查点（checkpoint）的工作机制

Beginning log switch checkpoint up to RBA [0x1760f.2.10], SCN: 8486535249241

Thread 1 advanced to log sequence 95759

Current log# 8 seq# 95759 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo08.log

Thu Mar 17 10:29:24 2011

Completed checkpoint up toRBA [0x1760f.2.10], SCN: 8486535249241

Thu Mar 17 10:32:37 2011

Beginning log switch checkpoint up toRBA [0x17610.2.10], SCN: 8486536488869

Thread 1 advanced to log sequence 95760

Current log# 9 seq# 95760 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo09.log

Thu Mar 17 10:33:37 2011

Beginning log switch checkpoint up toRBA [0x17611.2.10], SCN: 8486536865326

Thread 1 advanced to log sequence 95761

Current log# 10 seq# 95761 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo10.log

Thu Mar 17 10:33:57 2011

Beginning log switch checkpoint up toRBA [0x17612.2.10], SCN: 8486536868604

Thread 1 advanced to log sequence 95762

Current log# 11 seq# 95762 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo11.log

Beginning log switch checkpoint up toRBA [0x17613.2.10], SCN: 8486536870570

Thread 1 advanced to log sequence 95763

Current log# 12 seq# 95763 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo12.log

Thu Mar 17 10:34:43 2011

Beginning log switch checkpoint up toRBA [0x17614.2.10], SCN: 8486537091802

Thread 1 advanced to log sequence 95764

Current log# 4 seq# 95764 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo04.log

Beginning log switch checkpoint up toRBA [0x17615.2.10], SCN: 8486537092511

Thread 1 advanced to log sequence 95765

Current log# 1 seq# 95765 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo01.log

Thu Mar 17 10:34:58 2011

Beginning log switch checkpoint up toRBA [0x17616.2.10], SCN: 8486537098178

Thread 1 advanced to log sequence 95766

Current log# 2 seq# 95766 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo02.log

Beginning log switch checkpoint up toRBA [0x17617.2.10], SCN: 8486537098724

Thread 1 advanced to log sequence 95767

Current log# 3 seq# 95767 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo03.log

Beginning log switch checkpoint up toRBA [0x17618.2.10], SCN: 8486537099018

Thread 1 advanced to log sequence 95768

Current log# 5 seq# 95768 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo05.log

Thu Mar 17 10:35:21 2011

Beginning log switch checkpoint up toRBA [0x17619.2.10], SCN: 8486537111235

Thread 1 advanced to log sequence 95769

Current log# 6 seq# 95769 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo06.log

Beginning log switch checkpoint up toRBA [0x1761a.2.10], SCN: 8486537111653

Thread 1 advanced to log sequence 95770

Current log# 7 seq# 95770 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo07.log

Thread 1 cannot allocate new log, sequence 95771

Checkpoint not complete

Current log# 7 seq# 95770 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo07.log

Thu Mar 17 10:35:26 2011

Beginning log switch checkpoint up to RBA [0x1761a.2.10], SCN: 8486537111653

Thread 1 advanced to log sequence 95770

Current log# 7 seq# 95770 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo07.log

Thread 1 cannot allocate new log, sequence 95771

Checkpoint not complete

Current log# 7 seq# 95770 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo07.log

Thu Mar 17 10:35:26 2011

Completed checkpoint up to RBA [0x17610.2.10], SCN: 8486536488869

Thu Mar 17 10:35:26 2011

Beginning log switch checkpoint up to RBA [0x1761b.2.10], SCN: 8486537113134

Thread 1 advanced to log sequence 95771

Current log# 8 seq# 95771 mem# 0: /paic/bj/lbs/redo/oradata/lubj0/redo08.log

Thu Mar 17 10:37:55 2011

WARNING: inbound connection timed out (ORA-3136)

Thu Mar 17 10:38:42 2011

Completed checkpoint up to RBA [0x17611.2.10], SCN: 8486536865326

Thu Mar 17 10:39:03 2011

Completed checkpoint up to RBA [0x17612.2.10], SCN: 8486536868604

Completed checkpoint up to RBA [0x17613.2.10], SCN: 8486536870570

Thu Mar 17 10:39:15 2011

Incremental checkpoint up to RBA [0x17613.2068.0], current log tail at RBA [0x1761b.6ae1c.0]

Thu Mar 17 10:39:48 2011

Completed checkpoint up to RBA [0x17614.2.10], SCN: 8486537091802

Completed checkpoint up to RBA [0x17615.2.10], SCN: 8486537092511

Thu Mar 17 10:40:03 2011

Completed checkpoint up to RBA [0x17617.2.10], SCN: 8486537098724

Completed checkpoint up to RBA [0x17616.2.10], SCN: 8486537098178

Completed checkpoint up to RBA [0x17618.2.10], SCN: 8486537099018

Thu Mar 17 10:40:27 2011

Completed checkpoint up to RBA [0x1761a.2.10], SCN: 8486537111653

Completed checkpoint up to RBA [0x17619.2.10], SCN: 8486537111235

Completed checkpoint up to RBA [0x1761b.2.10], SCN: 8486537113134