*.workarea_size_policy='auto'
*.lock_name_space=standby
*.standby_file_management='auto'
*.standby_archive_dest='e:\oracle\oradata\stdarch'
*.log_parallelism=1
在备用数据库一端创建一个新的实例.如下操作:
c:\>oradim –new –sid standby –startmode auto
在主数据配置listener.ora,tnsnames.ora和sqlnet.ora文件.配置完之后分别如下:
listener =
(description_list =
(description_list =
(description =
(address = (protocol = tcp)(host = 10.100.0.122)(port = 1521))
)
)
(description_list =
(description =
(address = (protocol = ipc)(key = extproc1))
)
)
)
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = e:\oracle\ora92)
