Linux环境下oracle9i的Data guard配置
2007-05-10 12:18:33 来源:WEB开发网核心提示: 4. 配置主节点(primary主机上)的tnsnames.ora文件primary=(description=(address=(protocol=tcp)(port=1521)(host=1.1.1.1))(connect_data=(SID=oracle)))standby=(des
4. 配置主节点(primary主机上)的tnsnames.ora文件
primary=(description=
(address=
(protocol=tcp)
(port=1521)
(host=1.1.1.1))
(connect_data=
(SID=oracle)))
standby=(description=
(address=
(protocol=tcp)
(port=1521)
(host=1.1.1.2))
(connect_data=
(SID=oracle)))
同样,在副节点(standby) 的tnsnames.ora文件。
5. 在副节点(standby)上配置listener.ora文件, 添加监听服务standby_listener,在相应的节里添加有关的内容:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = oracle)
(GLOBAL_DBNAME = oracle)
(ORACLE_HOME = /home/oracle/oradata)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
)
)
在主副库上启动lsnrctl,
-bash-2.05b$ lsnrctl
LSNRCTL>start # 启动监听服务
6.在主备节点用tnsping测试网络连通性
在primary机上
-bash-2.05b$ tnsping primary
-bash-2.05b$ tnsping standby
在standby机上
-bash-2.05b$ tnsping primary
-bash-2.05b$ tnsping standby
7. 启动副数据库
sql> startup nomount;
SQL> alter database mount standby database;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
赞助商链接