Shutdown & Datafiles - Sanity check

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 7 Aug 2003 10:17:40 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70402A2F6@lnewton.leeds.lfs.co.uk>

Hi Anthony,

if your temp tablespace is a proper temporary one with tempfiles as opposed to datafiles, then your date stamp will indeed be 'out of sync'. Mine is still sitting at the date and time the database was created.

Look for the tempfile name(s) in v$tempfile - if they are there then (a) worry not and (b) don't bother backing them up - you don't need to. If the filename appear in v$datafile, then you do need to back them up.

Cheers,
Norm.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Thu Aug 07 2003 - 04:17:40 CDT