RE: Incremental checkpoints and CHECKPOINT_CHANGE#
- From: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>
- To: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>, "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 13 Jan 2010 18:45:12 -0500
I tried force a check point with 'alter system', this did update the scn
# in datafile header. I don't understand why those check point showing
in the alert log did not update the datafile header.
From: Jiang, Lu
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
Other related posts:
