Re: datafiles and tempfiles

Where did I ever mention anything about HOT backups in this thread? I thought I made it clear early in this thread that this was a COLD backup we were talking about. I have perhaps two dozen non production databases that I back up cold, some of which use temp files and some of which are on versions where they are not even available. I back them up because it simplifies he recovery script which can then be used across the board without anyone thinking about how to run it, which version it's restoring, which additional commands are necessary to start the database, etc. The script becomes so simple that even an operator with no database knowledge can understand it.

tar xvf - filename
sqlplus internal <<!
starup
!

What could be simpler?

--
Chuck

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:afqhff$jkh$1_at_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.

> >

> >

>

>