Re: About TEMPFILE creation

From: steven_nospam at Yahoo! Canada <steven_nospam_at_yahoo.ca>
Date: 9 Mar 2007 11:28:09 -0800
Message-ID: <1173468488.925951.124100@c51g2000cwc.googlegroups.com>

> 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 Received on Fri Mar 09 2007 - 13:28:09 CST