Re: Shutdown & Datafiles - Sanity check

Hi Norman,
Thanks for replying. My comments are embedded below.

Anthony Hogan

Norman Dunbar wrote:
>
> 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.

  The tablespace uses datafiles (create tablespace temp temporary). The date stamp is updated at random times despite daily shutdowns. The current date stamp is 04/08 9:56 whereas the date stamp of the rest of the datafiles (including an app temp tablespace) is 06/08 23:00 (last night's shutdown)
>
> 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 - 05:43:39 CDT