Re: datafiles and tempfiles

"Chuck" <chuckh_at_softhome.net> wrote in message news:afutk0$hij99$1_at_ID-85580.news.dfncis.de...
> Where did I ever mention anything about HOT backups in this thread?

You didn't. You asked a question about which view tempfiles were listed in, which was answered... and the thread then moved on to related matters.

>I
> thought I made it clear early in this thread that this was a COLD backup
we
> were talking about.

Er, no. You said, and I quote, "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."

That is a statement of general principle, not obviously specifics related to your situation.

>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?

I think the concern of others in this thread is that if you want a private chat about your specific situation which has no more relevance to other posters than my sister's cooking, use email. If you use a public forum, expect to get answers to your questions (which you did) and then some fuzzy stuff around the issue in general, for the benefit of all.

And *in general* it is extremely bad practice to get into the habit of backing up online redo logs. And *in general* the backup of tempfiles is not recommended, nor possible.

I'm glad you have a solution that works for you. It wouldn't be suitable for, oh, about 70% of Oracle users.

Regards
HJR
> --
> 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.
> > >
> > >
> >
> >
>
>
Received on Wed Jul 03 2002 - 14:32:24 CDT