Re: Trivia question - file date.

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 27 Nov 2002 21:47:49 +1000
Message-ID: <Sa1F9.84803$g9.239659@newsfeeds.bigpond.com>

Hi Norman, Joel and all cricket loving DBAs ;)

Remember that the purpose of a checkpoint is to have a point from which to commence instance recoveries. However, if you had an instance failure, what precisely within a temp file would be worth recovering. Not a lot. Therefore if Oracle is not going to concern itself with recovering a temp file, then there's really no point in checkpointing it either.

Now if only all files in an Oracle database were temp files, the Backup and Recovery manual would be so much easier to follow ;)

Cheers

Richard

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702FADB81_at_lnewton.leeds.lfs.co.uk...
> Morning Joel,
>
> It does indeed look like I made the same mistake you almost made :o)
>
> I wasn't aware that temp files were involved - I keep my temp files
> separate from the data files, so when I checkpoint after dropping a
> tablespace, I only look at the data files. I'd never noticed that the
> temp files don't change their dates on a checkpoint - I'll have to make
> a note of that.
>
> Cheers,
> Norman.
>
> -------------------------------------
> 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 Wed Nov 27 2002 - 05:47:49 CST