Re: About TEMPFILE creation

On Mar 9, 11:28 am, "steven_nospam at Yahoo! Canada" <steven_nos..._at_yahoo.ca> wrote:
> > Tempfiles are not backed up by rman nor do you need to back them up as
> > part of a manual backup. Using tempfiles saves backup time and space
> > as well as simplifies recovery as the tempfiles are just reallocated
> > on startup.
>
> > HTH -- Mark D Powell ---
>
> Hi Mark,
>
> Thanks for the advice. One question. You mentioned that in a manual
> backup (which we use) the temp tablespace is not required to be saved
> as part of the backup. However, when you try to restart the database
> during a recovery scenario, won't the database complain that the file
> is missing when you try to STARTUP or ALTER DATABASE OPEN?
>
> I was actually planning to go back and modify our backup scripts to
> perform a SELECT NAME FROM V$TEMPFILE and make sure to back up that
> file, but if it is automatically rebuilt during a recovery startup,
> perhaps I can save the extra space and time on the backup.
>
> Steve

A search on the metalink knowledgebase for temporary tablespaces will bring up some informative old FAQ's, too.

jg

--
@home.com is bogus.
On the IRS asking tax lawyers to help write new regulations:
"It's not the fox guarding the henhouse; it's the fox designing the
henhouse." - Paul Light
"Why don't we just privatize Congress and outsource the development of
our laws?" - Gary Bass