相关的理论说明,参考如下Blog:
Oracle RACFailover 详解
http://blog.csdn.net/tianlesoftware/article/details/5340788
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>executedbms_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. 确认参数修改:
colnameformata15
colfailover_methodformata11heading'METHOD'
colfailover_typeformata10heading'TYPE'
colfailover_retriesformat9999999heading'RETRIES'
colgoalformata10
colclb_goalformata8
colAQ_HA_NOTIFICATIONSformata5heading'AQNOT'
SQL> select name, failover_method,failover_type, failover_retries,goal, clb_goal,aq_ha_notifications from dba_services where service_id = 3;
NAME METHOD TYPE RETRIES GOAL CLB_GOAL AQNOT
--------------- ----------- ------------------ ---------- -------- -----
server_taf BASIC SELECT 180 NONE LONGYES
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 <machine: db1, pid: 2167>
(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
Name Type Target StateHost
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINEdb1
ora.FRA.dg ora....up.type ONLINE ONLINEdb1
ora....ER.lsnr ora....er.type ONLINE ONLINEdb1
ora....N1.lsnr ora....er.type ONLINE ONLINEdb2
ora....N2.lsnr ora....er.type ONLINE ONLINEdb1
ora....N3.lsnr ora....er.type ONLINE ONLINEdb1
ora.OCR.dg ora....up.type ONLINE ONLINEdb1
ora.asm ora.asm.type ONLINEONLINE db1
ora....SM1.asm application ONLINEONLINE db1
ora....01.lsnr application ONLINEONLINE db1
ora....-01.gsd application OFFLINEOFFLINE
ora....-01.ons application ONLINEONLINE db1
ora....-01.vip ora....t1.type ONLINE ONLINEdb1
ora....SM2.asm application ONLINEONLINE db2
ora....02.lsnr application ONLINEONLINE db2
ora....-02.gsd application OFFLINEOFFLINE
ora....-02.ons application ONLINEONLINE db2
ora....-02.vip ora....t1.type ONLINE ONLINEdb2
ora.cvu ora.cvu.type ONLINEONLINE db1
ora.gsd ora.gsd.type OFFLINEOFFLINE
ora....network ora....rk.type ONLINE ONLINEdb1
ora.oc4j ora.oc4j.type ONLINEONLINE db1
ora.ons ora.ons.type ONLINEONLINE db1
ora.orcl.db ora....se.type ONLINE ONLINEdb1
ora....taf.svc ora....ce.type ONLINE ONLINEdb1
ora.scan1.vip ora....ip.type ONLINE ONLINEdb2
ora.scan2.vip ora....ip.type ONLINE ONLINEdb1
ora.scan3.vip ora....ip.type ONLINE ONLINEdb1
-------------------------------------------------------------------------------------------------------
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
Skype: tianlesoftware
QQ: tianlesoftware@gmail.com
Email: tianlesoftware@gmail.com
Blog: http://www.tianlesoftware.com
Weibo: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
Linkedin: http://cn.linkedin.com/in/tianlesoftware
-------加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请----
DBA1 群:62697716(满); DBA2 群:62697977(满)DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群:83829929 DBA5群: 142216823
DBA6 群:158654907 DBA7 群:172855474 DBA总群:104207940
分享到:
相关推荐
rhel 6中搭建oracle 11gr2 rac环境。
oracle11gR2-Rac-for-linux安装手册
【Oracle-RAC】Linux--Oracle-11g-R2-RAC-安装配置详细过程V3.0(图文并茂)
Oracle 11gR2 RAC + ASM on AIX-6.1安装指导手册
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复 注:文档打开密码见压缩包注释
Oracle11GR2 RAC for AIX安装配置实战经验
《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》从硬件和软件两个维度系统且全面地讲解了Oracle 11g R2 RAC的架构、工作原理、管理及维护的系统理论和方法,以及性能优化的技巧和最佳实践...
第1章 认识Oracle RAC 1.1 RAC产生的背景 1.2 RAC体系结构 1.2.1整体结构 1.2.2物理层次结构 1.2.3逻辑层次结构 1.3 RAC的特点 1.3.1双机并行 1.3.2高可用性 1.3.3易伸缩性 1.3.4低成本 1.3.5高吞吐量 ...
构建最高可用Oracle数据库系统 Oracle 11gR2 RAC管理、维护与性能优化.part1.rar
oracle linux 6.4上安装部署 oracle RAC 11G R2,oracle linux上安装oracle是最简便的。
某客户需要将一套Oracle 10gR2 双节点RAC 生产数据库升级至Oracle 11gR2 RAC,所以便有了本系列实战的教程。 为更贴切还原生产过程中的实际操作,本系列教程一个分两大部分: 第一部分已发 一步一步在Linux上部署...
deploying-oracle-11gr2-rac-on-rhel6.pdf
Linux--Oracle-11g-R2-RAC-安装配置详细过程V3.0(图文并茂).zipLinux--Oracle-11g-R2-RAC-安装配置详细过程V3.0(图文并茂).zipLinux--Oracle-11g-R2-RAC-安装配置详细过程V3.0(图文并茂).zip
浦东机场货运站核心数据库升级至Oracle RAC 11gR2。操作系统采用RedHat Enterprice Linux 6.3 x64,操作系统平台为x86-64。 Oracle网格管理器和数据库安装版本为11.2.0.3.,并且升级GI和DB至PSU 6,数据共享存储采用...
Oracle 11g RAC--安装参考手册
Linux环境部署Oracle 11gR2 RAC数据库
本文详细介绍如何讲oracle rac的数据库数据进行迁移备份,配有图文,适合做做实验在再去实践
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复
oracle 11g r2 rac setup and show
构建最高可用Oracle数据库系统 Oracle 11gR2 RAC管理、维护与性能优化.part2