oracle10g之standby tempfile自動建立

作者: 絃樂之花 | 可以轉載, 但必須以超連結形式標明文章原始出處和作者資訊及版權宣告

連結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的。