Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Checkpoint# vs SCN
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