在看oracle rac的书,想问 rac是否支持
2台机器互相备份, (初始设置从a机器(主机器)到b机器(从机器))
当a机器down掉, b机器马上接替b机器自动升级为主机,
待dba报a机器修好后,a机器再连接b机器, 这时a机器自动成为从机器。(能否支持不手动更改ip地址?)
2台机器互相备份, (初始设置从a机器(主机器)到b机器(从机器))
当a机器down掉, b机器马上接替b机器自动升级为主机,
待dba报a机器修好后,a机器再连接b机器, 这时a机器自动成为从机器。(能否支持不手动更改ip地址?)
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
+ heart line ???
)
RAC9I1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = rac9iaw)(PORT = 1521))
(ADDRESS = (PROTOCOL = tcp)(HOST = rac9ibw)(PORT = 1521))
(LOAD_BALANCE = OFF)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVICE_NAME = rac9i.xyf)
(INSTANCE_ROLE = PRIMARY)
(INSTANCE_NAME = rac9i1)
(FAILOVER_MODE =
(BACKUP=RAC9I2)
(TYPE = select)
(METHOD = preconnect)
)
)
)
RAC9I2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = rac9ibw)(PORT = 1521))
(ADDRESS = (PROTOCOL = tcp)(HOST = rac9iaw)(PORT = 1521))
(LOAD_BALANCE = OFF)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVICE_NAME = rac9i.xyf)
(INSTANCE_ROLE = SECONDARY)
(INSTANCE_NAME = rac9i2)
(FAILOVER_MODE =
(BACKUP=RAC9I1)
(TYPE = select)
(METHOD = preconnect)
)
)
)
不管你用哪个连接字符串,都会路由到主实例rac9i1上,当实例rac9i1失败时,才会路由到另一个上,和你的要求类似
其中java中写法更加特殊。具体查一下java程序中写法。