Re: Incremental checkpoints and CHECKPOINT_CHANGE#
- From: Fuyuncat <fuyuncat@xxxxxxxxx>
- To: Lu.Jiang@xxxxxxxxxxxx
- Date: Thu, 14 Jan 2010 10:22:48 +0800
Did you set log_checkpoints_to_alert as TRUE?
2010/1/14 Jiang, Lu <Lu.Jiang@xxxxxxxxxxxx>
> 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
>
--
Sr. DBA Fuyuncat
www.HelloDBA.com
Other related posts:
