Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Checkpoint# vs SCN

Checkpoint# vs SCN

From: Juan Carlos <jc_va_at_hotmail.com>
Date: Sun, 8 Aug 1999 07:19:51 -0700
Message-ID: <7ojp5b$qgf$1@bgtnsc02.worldnet.att.net>


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.... Received on Sun Aug 08 1999 - 09:19:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US