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 -> Shutdown & Datafiles - Sanity check

Shutdown & Datafiles - Sanity check

From: Anthony Hogan <ahogan-nospam-_at_iespana.es>
Date: Thu, 07 Aug 2003 08:48:46 +0100
Message-ID: <3F32045E.FC8C8A88@iespana.es>


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 Received on Thu Aug 07 2003 - 02:48:46 CDT

Original text of this message

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