Incremental checkpoints and CHECKPOINT_CHANGE#

Does anyone know why checkpoint scn does not write to datafile header in the following scenario?  

Parameter log_checkpoint_timeout = 1200  

• Incremental checkpoints show in alert.log:

Wed Jan 13 13:47:43 2010

Incremental checkpoint up to RBA [0x79e.1cacf6.0], current log tail at RBA [0x79e.1cb16a.0]

Wed Jan 13 14:07:43 2010

Incremental checkpoint up to RBA [0x79e.1cc865.0], current log tail at RBA [0x79e.1ccd64.0]

Wed Jan 13 14:27:47 2010

Incremental checkpoint up to RBA [0x79e.1ceb74.0], current log tail at RBA [0x79e.1d0193.0]

Wed Jan 13 14:47:47 2010

Incremental checkpoint up to RBA [0x79e.1d101b.0], current log tail at RBA [0x79e.1d12e2.0]  

• CHECKPOINT_CHANGE# has not been updated in v$datafile_header view, it stays with yesterdays check point info:

SQL> select distinct CHECKPOINT_CHANGE#, CHECKPOINT_TIME from v$datafile_header;  

CHECKPOINT_CHANGE# CHECKPOINT_TIME

• --------------------

         580705781 12-JAN-10   Thanks,

Lu

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 13 2010 - 14:54:14 CST