Re: datafiles and tempfiles

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 2 Jul 2002 07:26:04 +1000
Message-ID: <afqhff$jkh$1@lust.ihug.co.nz>

Actually, Chuck, temporary tablespaces that are made from tempfiles CANNOT be put into hot backup mode. So no, you are not supposed to back them up, and yes, you are supposed to re-create them from scratch.

Being sparse files, re-creating a huge tempfile on a Unix box takes a matter of a second or so at most.

Regards
HJR "Chuck" <chuckh_at_softhome.net> wrote in message news:afqdda$gbi13$1_at_ID-85580.news.dfncis.de...
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:uhpmfc8tbeckf1_at_corp.supernews.com...
> >
> > "Chuck" <chuckh_at_softhome.net> wrote in message
> > news:afid8p$en847$1_at_ID-85580.news.dfncis.de...
> > > Is there a view already defined that lists both tempfiles and
datafiles?
> > > Something similar to
> > >
> > > select * from dba_data_files
> > > union all
> > > select * from dba_temp_files
> > >
> > >
> > >
> >
> > There is not. They are two different things, aren't they.
> >
>
> Last time I checked they were both files and should be backed up when
doing
> in a cold backup. Unless you want to have to recreate the temp tablespaces
> manually that is.
>
>
Received on Mon Jul 01 2002 - 16:26:04 CDT