有一个问题可能大家都忽略了

shiri512003

可以参考piner高可用oracle中dg章节应用透明切换部分

blue_prince

加个(failover = on )

比如：


test =
  (DESCRIPTION =
    (failover = on )
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.19.8.16)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.23.18.16)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
      (SERVER = DEDICATED)
    )
  )

Karsus

原帖由 玉面飞龙 于 2010-2-1 18:06 发表


orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl.vip.ebay.com)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)


Register orcl.vip.ebay.com with database host IP in DNS.

After database failover to standby, have SA modify DNS from orcl.vip.ebay.com to new IP.

Client just need to wait a few minutes.

五“宅”一生

如果有domain的话也好弄。可以多个IP bind到一个domain name里面。
我们这里弄过这种，不过不是data guard.

inthirties2

在tnsname里配置多个数据源，就可以呀。