Re: Trivia question - file date.

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<S8JE9.84196$g9.236955_at_newsfeeds.bigpond.com>...
> Yes. You put it into hot backup mode and leave it there.

I guess I wasn't clear enough that was what I meant by no backup/restore in progress".

>
> Regards
> HJR
>
> "Joel Garry" <joel-garry_at_home.com> wrote in message
> news:91884734.0211251437.2adfd4ec_at_posting.google.com...
> > Todays trivia question:
> >
> > If you don't use read-only tablespaces, and you bounce your database
> > weekly, can you have a legitimate Oracle database file dated 6 months
> > old?
> >
> > (assuming 8.1.7 on unix, normal operations with no backup/restore in
> > progress, no funny business with "touch," Oracle handling the files,
> > not including stuff like installed files and logs.)
> >
> >
> > .
> >
> >
> > .
> >
> >
> > .
> >
> >
> > .
> >
> >
> > .
> >
> >
> > .
> >
> >
> > .
> >
> >
> > .
> >
> >
> > Nearly shot myself in the foot with this one. About six months ago,
> > someone added a second temporary sort file. Every once in a while,
> > especially on a system I haven't been on in a while, I "clean out the
> > garage," including looking for unused large files with a command like
> > (depending on your ls and your data file locations):
> >
> > ls -Rl /oracle |sort -nrk5|more
> >
> > which normally pops up the data files first, then forgotten exports
> > and load files and undropped data files and such. Since Oracle often
> > touches the data files (except read-only), thereby updating the file
> > system date, old dates stand out like a sore thumb.
> >
> > So I see a file among the data files with a 6 month old date. select
> > * from v$dbfile; not there. Oh wait, select tablespace_name,
> > contents from dba_tablespaces; almost missed the locally managed temp
> > file. Well, the temp file has a recent date, so the old one isn't
> > used, right? Oh wait, select * from dba_temp_files;
> >
> > Yow! Almost missed that! Seems having _2_ 2G locally managed temp
> > files has allowed the second one never to be used, Oracle never
> > updating the date. But just waiting for someone to make
> > assumptions...
> >
> > Other answers welcomed.
> >
> > jg
> > --
> > @home is bogus
> > http://www.garry.to

jg

--
@home is bogus.