RAC题目
Thomas Zhang的3节点RAC题目
SERVICE12
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbname)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
SERVICE3
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip3)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbname)
)
)
SERVICEA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SERVICE12)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(BACKUP = SERVICE3)
)
)
)
http://www.itpub.net/762397.html
Thomas Zhang在yangtingkun blog上出的RAC题目
需求：一个RAC，三个节点node1,node2,node2。
两台app server A和B
要求：1）正常情况下，server A通过node1和node2访问数据库，server B通过node3访问数据。
server A通过node1和node2时要load balance
2）当node1异常，server A上的应用通过node2访问
当node2异常，server A上的应用通过node1访问
3）当node1,node2同时异常，server A上的应用通过node3全部接管
4）当node3异常，server B上的应用通过node1/node2接管并Load Balance.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7916042/viewspace-912621/ ，如需转载，请注明出处，否则将追究法律责任。
