作者: 弦乐之花 | 可以转载, 但必须以超链接形式标明文章原始出处和作者信息及版权声明
链接http://shiri512003.itpub.net/post/37713/499385
[@more@]文档提到oracle 10g支持temp文件自动创建,但一直没有真正去关注这个过程,偶然的一次机会发现了这个自动创建的过程。
一次open read only dg的时候,发现异常的慢,于是查看alert日志发现如下信息:
Tue Apr 20 09:52:58 2010
alter database open read only
Tue Apr 20 09:52:59 2010
SMON: enabling cache recovery
Tue Apr 20 09:53:01 2010
Re-creating tempfile /opt/oracle/oradata/test/temp04.dbf
Re-creating tempfile /opt/oracle/oradata/test/temp03.dbf
Re-creating tempfile /opt/oracle/oradata/test/temp02.dbf
Re-creating tempfile /opt/oracle/oradata/test/temp01.dbf
Database Characterset is ZHS16GBK
Tue Apr 20 09:53:57 2010
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 8
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: alter database open read only
从以上信息可以看到,oracle10g是在open 的时候创建tempfile的。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7591490/viewspace-1033021/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7591490/viewspace-1033021/