Xref: alice comp.databases.oracle.server:60820
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!wn4feed!worldnet.att.net!wnmaster2!not-for-mail
From: "Juan Carlos" <jc_va@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Checkpoint# vs SCN
Date: Sun, 8 Aug 1999 07:19:51 -0700
Organization: AT&T WorldNet Services
Lines: 13
Message-ID: <7ojp5b$qgf$1@bgtnsc02.worldnet.att.net>
X-Trace: bgtnsc02.worldnet.att.net 934111211 27151 12.78.177.123 (8 Aug 1999 11:20:11 GMT)
X-Complaints-To: abuse@worldnet.att.net
NNTP-Posting-Date: 8 Aug 1999 11:20:11 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0

I am studying for the Backup/Recovery OCP test.  Oracle checks the
checkpoint number of all redo, control, and datafiles for consistency.  But
where is this stored, i.e. what v$ view/column?  In v$datafile and
v$datafile_header I see CHECKPOINT_CHANGE#, but this seems to be more of a
SCN versus a checkpoint number.

Is Oracle perhaps a little loose in their terminology, and the SCN at the
last checkpoint is recorded, not a checkpoint number itself, is checked for
consistency across datafiles?  A query shows it is consistent.

Thanks for your help.  I am about 2 weeks away from the test....