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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-262768/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-262768/