well tempfiles are not restored or recovered since they are not even backed up if you use RMAN (and they are not supposed to be backup, usesless, if you are backup manually)
if you do alter backup controlfile to trace you can actually see what Oracle does when recovering the database
it simply adds a tempfile so no matter what you do, rename it or delete it, it will still able to get a new tempfileCode:# Recovery is required if any of the datafiles are restored backups, # or if the last shutdown was not normal or immediate. RECOVER DATABASE # Database can now be opened normally. ALTER DATABASE OPEN; # Commands to add tempfiles to temporary tablespaces. # Online tempfiles have complete space information. # Other tempfiles may require adjustment. ALTER TABLESPACE TEMP ADD TEMPFILE '/oracle_2/oradata/dev920/temp01.dbf' REUSE; # End of tempfile additions. #




Reply With Quote