Re: datafiles and tempfiles

Chuck wrote:
>
> "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.

Recreating a tempfile would generally be more efficient than restoring it from backup - much faster to recreate than to restore from tape, for instance. The only reason I can think of to backup a tempfile is to simplify scripting if you aren't using RMAN. In other words, if you split a mirror and take that mirror to tape, it may just be easier/safer to copy the whole miror to tape, including tempfiles, even if you have no intention of ever restoring them. Otherwise there is no reason to back them up, so I'd disagree with your statement that they "should be backed up when doing a cold backup."

Regards,
Sean Received on Mon Jul 01 2002 - 16:35:32 CDT