Received: (qmail 28965 invoked from network); 13 Jan 2010 17:57:21 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 13 Jan 2010 17:57:08 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 27D30CC7FFB; Wed, 13 Jan 2010 18:56:42 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12Zs2g-RARXh; Wed, 13 Jan 2010 18:56:41 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A0BC0CC7CF0; Wed, 13 Jan 2010 18:56:01 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 13 Jan 2010 18:55:20 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A029CC7CDE for ; Wed, 13 Jan 2010 18:55:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id BiPyn4xaDB+e for ; Wed, 13 Jan 2010 18:55:20 -0500 (EST) Received: from nlb-securemail.umassmed.edu (edunivtw01.ad.umassmed.edu [146.189.195.116]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D7C31CC7CB3 for ; Wed, 13 Jan 2010 18:55:19 -0500 (EST) Received: from [146.189.194.27] by nlb-securemail.umassmed.edu with ESMTP (SMTP Relay); Wed, 13 Jan 2010 18:55:12 -0500 X-Server-Uuid: D1A27D3C-4100-4955-B400-0F8801E7DACA Received: from EDUNIVMAIL10.ad.umassmed.edu ([146.189.192.150]) by mail.umassmed.edu with Microsoft SMTPSVC(6.0.3790.3959); Wed, 13 Jan 2010 18:54:37 -0500 Received: from edmtpmail01.ad.umassmed.edu ([146.189.136.35]) by EDUNIVMAIL10.ad.umassmed.edu with Microsoft SMTPSVC(6.0.3790.3959); Wed, 13 Jan 2010 18:54:37 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# Date: Wed, 13 Jan 2010 18:45:12 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Incremental checkpoints and CHECKPOINT_CHANGE# References: <6AFC12B9BFCDEA45B7274C534738067F36C59566@AAPQMAILBX02V.proque.st> <6AFC12B9BFCDEA45B7274C534738067F36C59654@AAPQMAILBX02V.proque.st> From: "Jiang, Lu" To: "Jiang, Lu" , "Bobak, Mark" , oracle-l@freelists.org X-OriginalArrivalTime: 13 Jan 2010 23:54:37.0290 (UTC) FILETIME=[C3731CA0:01CA94AB] X-WSS-ID: 675082D53P42594326-07-01 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CA94AA.739B1CE0" X-archive-position: 24555 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Lu.Jiang@umassmed.edu Precedence: normal Reply-to: Lu.Jiang@umassmed.edu List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l ------_=_NextPart_001_01CA94AA.739B1CE0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable 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. =20 From: Jiang, Lu=20 Sent: Wednesday, January 13, 2010 6:41 PM To: 'Bobak, Mark'; oracle-l@freelists.org Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# =20 Had checked the following and returned 'Not Active'. We only do backups at full db level with rman during evenings. =20 From: Bobak, Mark [mailto:Mark.Bobak@proquest.com]=20 Sent: Wednesday, January 13, 2010 6:39 PM To: Jiang, Lu; oracle-l@freelists.org Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# =20 Database being open and normal mode is fine, but datafiles could still be in backup mode. =20 What do you get from: select * from v$backup where status=3D'ACTIVE'; ?? =20 If that returns any rows, those files are in backup mode. =20 -Mark =20 From: Jiang, Lu [mailto:Lu.Jiang@umassmed.edu]=20 Sent: Wednesday, January 13, 2010 5:20 PM To: Bobak, Mark; oracle-l@freelists.org Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# =20 No. The database is open and normal mode. =20 From: Bobak, Mark [mailto:Mark.Bobak@proquest.com]=20 Sent: Wednesday, January 13, 2010 5:12 PM To: Jiang, Lu; oracle-l@freelists.org Subject: RE: Incremental checkpoints and CHECKPOINT_CHANGE# =20 Is the tablespace in backup mode? =20 From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jiang, Lu Sent: Wednesday, January 13, 2010 3:54 PM To: oracle-l@freelists.org Subject: Incremental checkpoints and CHECKPOINT_CHANGE# =20 Hi DBA Gurus, =20 Does anyone know why checkpoint scn does not write to datafile header in the following scenario? =20 Parameter log_checkpoint_timeout =3D 1200 =20 -- Incremental checkpoints show in alert.log: =20 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] =20 -- CHECKPOINT_CHANGE# has not been updated in v$datafile_header view, it stays with yesterdays check point info: =20 SQL> select distinct CHECKPOINT_CHANGE#, CHECKPOINT_TIME from v$datafile_header; =20 CHECKPOINT_CHANGE# CHECKPOINT_TIME ------------------ -------------------- 580705781 12-JAN-10 =20 Thanks, Lu ------_=_NextPart_001_01CA94AA.739B1CE0 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable

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@freelists.org
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@proquest.com]
Sent: Wednesday, January 13, 2010 6:39 PM
To: Jiang, Lu; oracle-l@freelists.org
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=3D’ACTIVE’;

??

 

If that returns any = rows, those files are in backup mode.

 

-Mark

 

From:= Jiang, Lu [mailto:Lu.Jiang@umassmed.edu]
Sent: Wednesday, January 13, 2010 5:20 PM
To: Bobak, Mark; oracle-l@freelists.org
Subject: RE: Incremental checkpoints and = CHECKPOINT_CHANGE#

 

No. The database is = open and normal mode.

 

From:= Bobak, = Mark [mailto:Mark.Bobak@proquest.com]
Sent: Wednesday, January 13, 2010 5:12 PM
To: Jiang, Lu; oracle-l@freelists.org
Subject: RE: Incremental checkpoints and = CHECKPOINT_CHANGE#

 

Is the tablespace in = backup mode?

 

From:= oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Jiang, Lu
Sent: Wednesday, January 13, 2010 3:54 PM
To: oracle-l@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  =3D 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

------_=_NextPart_001_01CA94AA.739B1CE0-- -- http://www.freelists.org/webpage/oracle-l