RE: Incremental checkpoints and CHECKPOINT_CHANGE#
Date: Wed, 13 Jan 2010 17:12:08 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F36C59566_at_AAPQMAILBX02V.proque.st>
Is the tablespace in backup mode?
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jiang, Lu
Sent: Wednesday, January 13, 2010 3:54 PM
To: oracle-l_at_freelists.org
Subject: Incremental checkpoints and CHECKPOINT_CHANGE#
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 13 2010 - 16:12:08 CST