Oracle RACFailover
详解：http://www.51CTO提醒您，请勿滥发广告!/bbs/thread-31215-1-1.html
How To Configure Server Side TransparentApplication Failover [ID
460982.1]
1．创建TAFService
[oracle@db1 bin]$ ./srvctl add service -d orcl -s server_taf -r
“orcl1,orcl2” -P BASIC
–这里的orcl是database name，orcl1和orcl2 是instance name。
2. 启动server_taf服务
[oracle@db1 bin]$ ./srvctl start service -d orcl -s server_taf
3. 检查service运行情况
[oracle@db1 bin]$ ./srvctl config service -d orcl
Service name: server_taf
Service is enabled
Server pool: orcl_server_taf
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: orcl1,orcl2
Available instances:
4.确认serviceID
SQL> select name,service_id from dba_services where name =
‘server_taf’;
NAMESERVICE_ID
————————————————————————–
server_taf3
5.给service添加参数：
SQL> execute dbms_service.modify_service (service_name =>
‘server_taf’ –
, aq_ha_notifications => true –
, failover_method => dbms_service.failover_method_basic –
, failover_type => dbms_service.failover_type_select –
, failover_retries => 180 –
, failover_delay => 5 –
, clb_goal => dbms_service.clb_goal_long);
6. 确认参数修改：
col name format a15
col failover_method format a11 heading ‘METHOD’
col failover_type format a10 heading ‘TYPE’
col failover_retries format 9999999 heading ‘RETRIES’
col goal format a10
col clb_goal format a8
col AQ_HA_NOTIFICATIONS format a5 heading ‘AQNOT’
SQL> select name, failover_method,failover_type, failover_retries,goal,
clb_goal,aq_ha_notifications from dba_services where service_id = 3;
NAMEMETHODTYPERETRIES GOALCLB_GOAL
AQNOT
————— ———– —————— ———- ——–
—–
server_tafBASICSELECT180 NONELONGYES
SQL>
7. 检查service注册情况：
[oracle@db1 bin]$ lsnrctl services
LSNRCTL for Linux: Version 11.2.0.3.0 -Production on 15-JUL-2012
13:26:43
Copyright (c) 1991, 2011, Oracle.All rights reserved.
Connecting
to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db1)(PORT=1521)))
Services Summary…
Service “+ASM” has 1 instance(s).
Instance “+ASM1”, status READY, has 1 handler(s) for
thisservice…
Handler(s):
“DEDICATED” established:57 refused:0 state:ready
LOCAL SERVER
Service “orcl” has 1 instance(s).
Instance “orcl1”, status READY, has 1 handler(s) for
thisservice…
Handler(s):
“DEDICATED” established:11 refused:0 state:ready
LOCAL SERVER
Service “orclXDB” has 1instance(s).
Instance “orcl1”, status READY, has 1 handler(s) for
thisservice…
Handler(s):
“D000” established:0 refused:0 current:0 max:1022
state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=db1.tianlesoftware.com)(PORT=38731))
Service “server_taf” has 1instance(s).
Instance “orcl1”, status READY, has 1 handler(s) for
thisservice…
Handler(s):
“DEDICATED” established:11 refused:0 state:ready
LOCAL SERVER
The command completed successfully
8. 客户端就可以使用Service-SideTAF了：
在客户端TNS 配置：
orcl =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST= orcl.tianlesoftware.com)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=orcl)
)
)
— orcl.tianlesoftware.com是SCAN IP地址。
9.查看进程状态
[oracle@db1 bin]$ ./crs_stat -t
NameTypeTargetStateHost
————————————————————
ora.DATA.dgora….up.type ONLINEONLINEdb1
ora.FRA.dgora….up.type ONLINEONLINEdb1
ora….ER.lsnr ora….er.type ONLINEONLINEdb1
ora….N1.lsnr ora….er.type ONLINEONLINEdb2
ora….N2.lsnr ora….er.type ONLINEONLINEdb1
ora….N3.lsnr ora….er.type ONLINEONLINEdb1
ora.OCR.dgora….up.type ONLINEONLINEdb1
ora.asmora.asm.typeONLINEONLINEdb1
ora….SM1.asm applicationONLINEONLINEdb1
ora….01.lsnr applicationONLINEONLINEdb1
ora….-01.gsd applicationOFFLINEOFFLINE
ora….-01.ons applicationONLINEONLINEdb1
ora….-01.vip ora….t1.type ONLINEONLINEdb1
ora….SM2.asm applicationONLINEONLINEdb2
ora….02.lsnr applicationONLINEONLINEdb2
ora….-02.gsd applicationOFFLINEOFFLINE
ora….-02.ons applicationONLINEONLINEdb2
ora….-02.vip ora….t1.type ONLINEONLINEdb2
ora.cvuora.cvu.typeONLINEONLINEdb1
ora.gsdora.gsd.typeOFFLINEOFFLINE
ora….network ora….rk.type ONLINEONLINEdb1
ora.oc4jora.oc4j.typeONLINEONLINEdb1
ora.onsora.ons.typeONLINEONLINEdb1
ora.orcl.dbora….se.type ONLINEONLINEdb1
ora….taf.svc ora….ce.type ONLINEONLINEdb1
ora.scan1.vipora….ip.type ONLINEONLINEdb2
ora.scan2.vipora….ip.type ONLINEONLINEdb1
ora.scan3.vipora….ip.type ONLINEONLINEdb1
