WEB开发网
开发学院数据库Oracle Linux环境下oracle9i的Data guard配置 阅读

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;

上一页  2 3 4 5 6 7 8 9 10  下一页

Tags:Linux 环境 oraclei

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接