oracle10g R2 DataGuard read only模式会创建tempfile

最近做DataGuard测试,在doc中关于角色转换的准备工作中有下面的一段话:

Ensure temporary files exist on the standby database that match the temporary

files on the primary database

standby创建好后,temporary tablespace存在,但tempfile不存在

SQL> select name from v$tablespace;

NAME

------------------------------

…

TEMP

…

23 rows selected.

SQL> select name from v$tempfile;

NAME

--------------------------------------------------------------------------------

/u02/oradata/mhdb01/mhdb01/temp01.dbf

ll /u02/oradata/mhdb01/mhdb01/temp01.dbf

ls: /u02/oradata/mhdb01/mhdb01/temp01.dbf: No such file or directory

alter database open read only后再次执行,文件存在,本想添加tempfile

感觉有点奇怪,在alter log里发现了下面的内容

Completed: alter database recover managed standby database cancel

Wed Jun 3 09:57:26 2009

alter database open read only

Wed Jun 3 09:57:27 2009

SMON: enabling cache recovery

Wed Jun 3 09:57:27 2009

Re-creating tempfile /u02/oradata/mhdb01/mhdb01/temp01.dbf

standby上的tempfile不是必须manual添加的

ITPub博客

oracle10g R2 DataGuard read only模式会创建tempfile