Re: About TEMPFILE creation

"steven_nospam at Yahoo! Canada" <steven_nospam_at_yahoo.ca> a écrit dans le message de news: 1173468488.925951.124100_at_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
|

If you used real temporary tablespace, the database can open and even run without any temp files until you need some temp space, for a sort for example, then you get an error "ORA-25153: Temporary Tablespace is Empty".

Temporary tablespace are not automatically rebuilt during recover. You have to add the files with "alter tablespace add tempfile ...".

Regards
Michel Cadot Received on Fri Mar 09 2007 - 14:11:27 CST