oracle 10g R2 恢復完資料庫後自動新增臨時表空間資料檔案

我們知道在Oracle10gR2以前的版本中，如果使用RMAN恢復資料庫，臨時表空間的臨時檔案是不會自動恢復的。
我們在恢復完成之後有時忘記新增臨時檔案，這樣導致在應用中出錯時才能發現。

透過rman 恢復在alert日誌中可以發現以下痕跡

Wed May 07 11:57:59 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=18, OS id=3652
Wed May 07 11:57:59 2008
SMON: enabling cache recovery
Wed May 07 11:58:00 2008
Successfully onlined Undo Tablespace 1.
Wed May 07 11:58:00 2008
SMON: enabling tx recovery
Wed May 07 11:58:00 2008
Re-creating tempfile D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAFILE\O1_MF_TEMP_4221RHM1_.TMP as D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAFILE\O1_MF_TEMP_422B68PG_.TMP
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1644
Wed May 07 11:58:06 2008
Completed: alter database open
Wed May 07 11:58:08 2008
db_recovery_file_dest_size of 2048 MB is 7.69% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.