Re: To or not to hot backup the TEMP space

In addition to not backing up the TEMP tablespace (created as CREATE TABLESPACE TEMP TEMPORARY) would you also set it to NOLOGGING ?

Hemant K Chitale

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a8j7lp$ndh$1_at_lust.ihug.co.nz...
> Disagree. If it's dictionary managed temporary tablespace (ie, the
> 'temporary' keyword was tacked on to the end of the regular 'create
> tablespace' command), then the fact that it's dictionary managed is
> irrelevant: there still cannot be anything of permanent interest contained
> within it.
>
> It is true that you won't get your database open without such datafiles,
but
> a quick 'alter database datafile X offline drop' does the business. An
> 'alter database open' followed by a 'drop tablespace temp' and a 'create
> tablespace temp' completes the business.
>
> Given that temporary tablespaces can be huge, it seems pointless madness
to
> back it up, ever, unless you've got all the time in the world in which to
do
> your backups, and all the disk space or tape space you could ever ask for.
>
> Regards
> HJR
> --
> -----------------------------------------------
> Resources for Oracle : http://www.hjrdba.com
> ===============================
>
> "Ted McCabe" <the_om_at_gte.net> wrote in message
> news:tg6r8.3082$WQ4.235_at_nwrddc02.gnilink.net...
> > If it is dictionary managed, it should be. If it is locally managed
> > tempfile it should not.
> > HTH
> > tED
> > "Nabil Courdy" <moab88_at_emirates.net.ae> wrote in message
> > news:ae1f8554.0204040100.41f4b8ec_at_posting.google.com...
> > > Do the datafiles for the TEMP table space have to be backed up in a
hot
> > backup?
> > > Currently, my script is not picking up these data files. (8.1.7 on
> > Solaris)
> > >
> > > Nabil
> > > =====
> >
> >
>
>
Received on Sat Apr 06 2002 - 08:38:31 CST