Incremental checkpoints and CHECKPOINT_CHANGE#

From: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 13 Jan 2010 15:54:14 -0500

Hi DBA Gurus,

 

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

Follow-Ups:

RE: Incremental checkpoints and CHECKPOINT_CHANGE#
From: Bobak, Mark

Incremental checkpoints and CHECKPOINT_CHANGE#

Other related posts: