Re: Shutdown & Datafiles - Sanity check

On Thu, 07 Aug 2003 08:48:46 +0100, Anthony Hogan <ahogan-nospam- @iespana.es> wrote:

> I have a small production database 8.1.7 running on W2K server. I run a
> nightly script to shut the database down and os copy the datafiles. The
> alert file shows no errors for the shutdown or subsequent startup.
> The curious thing is that the os timestamp on the temp datafile is not
> in sync with the rest of the datafiles. DBV shows no errors,
> v$datafile_header.checkpoint_time is correct and a restore to another
> server completes successfully. So... what's going on?
> My understanding is that on shutdown the datafiles should all have the
> same timestamp. Is this the case or am I being unduly concerned?
>
> TIA
> Anthony Hogan
>

Unduly concerned. The O/S timestamp is a matter for the O/S, and who knows what it's doing at any particular moment?! So long as the checkpoint change numbers are all consistent, and dbv reports no errors, the thing is safe.

~QM Received on Thu Aug 07 2003 - 04:32:35 CDT