Ok, just wanted to be sure. That's not it, then. From: Jiang, Lu [mailto:Lu.Jiang@xxxxxxxxxxxx] Sent: Wednesday, January 13, 2010 6:41 PM To: Bobak, Mark; oracle-l@xxxxxxxxxxxxx Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# Had checked the following and returned 'Not Active'. We only do backups at full db level with rman during evenings. From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxx] Sent: Wednesday, January 13, 2010 6:39 PM To: Jiang, Lu; oracle-l@xxxxxxxxxxxxx Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# Database being open and normal mode is fine, but datafiles could still be in backup mode. What do you get from: select * from v$backup where status='ACTIVE'; ?? If that returns any rows, those files are in backup mode. -Mark From: Jiang, Lu [mailto:Lu.Jiang@xxxxxxxxxxxx] Sent: Wednesday, January 13, 2010 5:20 PM To: Bobak, Mark; oracle-l@xxxxxxxxxxxxx Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# No. The database is open and normal mode. From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxx] Sent: Wednesday, January 13, 2010 5:12 PM To: Jiang, Lu; oracle-l@xxxxxxxxxxxxx Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# Is the tablespace in backup mode? From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jiang, Lu Sent: Wednesday, January 13, 2010 3:54 PM To: oracle-l@xxxxxxxxxxxxx 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