11gRAC_SERVCER-SIDE_FAILOVER

RAC中实现FAILOVER的方式有三种，
Client-Side_Failover
TAF
Server-Side_Failover

好嘛，关于Failover另开文章再说。

Oracle10g版本中ASM、Service都可以通过dbca管理（简直不要太方便）
11g中另开GI（Grid Infastructure）软件，管理ASM
Service通过srvctl指令创建和管理。（10g中也可以通过该指令创建和管理Service，但是没有11g中的完善）

############测试步骤如下###########

点击(此处)折叠或打开

1. 1.创建一个service
   
2. srvctl add service -d orcl -s s1 -r orcl1 -a orcl2 -e session -m basic -w 10 -z 50
   
3. ---数据库名orcl,service名s1,优选实例orcl1,备选实例orcl2,模式为session,basic,遇到故障每隔10s重新连接,重试50次
   
5. 2.启动service
   
6. srvctl start service -d orcl -s s1
   
8. 3.在实例中查看service
   
9. select SERVICE_ID,NAME,FAILOVER_METHOD,FAILOVER_TYPE,FAILOVER_RETRIES,FAILOVER_DELAY from dba_services where name ='s1';
   
10. SERVICE_ID NAME FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY
    
11. ---------- ------ --------------- --------------- ---------------- --------------
    
12. 
    
13.          3 s1 BASIC SESSION 50 10
    
15. 4.查看监听
    
16. lsnrctl stat
    
17. 
    
18. LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-NOV-2015 15:33:31
    
19. Copyright (c) 1991, 2011, Oracle. All rights reserved.
    
20. 
    
21. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    
22. STATUS of the LISTENER
    
23. ------------------------
    
24. 
    
25. Alias LISTENER
    
26. Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
    
27. Start Date 28-NOV-2015 15:05:12
    
28. Uptime 0 days 0 hr. 28 min. 18 sec
    
29. Trace Level off
    
30. Security ON: Local OS Authentication
    
31. SNMP OFF
    
32. Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
    
33. Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml
    
34. Listening Endpoints Summary...
    
35.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
    
36.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.23.100)(PORT=1521)))
    
37.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.23.10)(PORT=1521)))
    
38. Services Summary...
    
39. Service "+ASM" has 1 instance(s).
    
40.   Instance "+ASM1", status READY, has 1 handler(s) for this service...
    
41. Service "orcl" has 1 instance(s).
    
42.   Instance "orcl1", status READY, has 1 handler(s) for this service...
    
43. Service "orclXDB" has 1 instance(s).
    
44.   Instance "orcl1", status READY, has 1 handler(s) for this service...
    
45. Service "s1" has 1 instance(s).        ##########service s1优选实例1##########
    
46.   Instance "orcl1", status READY, has 1 handler(s) for this service...
    
47. The command completed successfully
    
49. 5.两个节点参数查看
    
50. ------节点1
    
51. 
    
52. SQL> show parameter name
    
53. NAME TYPE VALUE
    
54. ------------------------------------ ----------- ------------------------------
    
55. 
    
56. db_file_name_convert string
    
57. db_name string orcl
    
58. db_unique_name string orcl
    
59. global_names boolean FALSE
    
60. instance_name string orcl1
    
61. lock_name_space string
    
62. log_file_name_convert string
    
63. processor_group_name string
    
64. service_names string s1
    
65. ------节点2
    
66. 
    
67. SQL> show parameter name
    
68. NAME TYPE VALUE
    
69. ------------------------------------ ----------- ------------------------------
    
70. 
    
71. db_file_name_convert string
    
72. db_name string orcl
    
73. db_unique_name string orcl
    
74. global_names boolean FALSE
    
75. instance_name string orcl2
    
76. lock_name_space string
    
77. log_file_name_convert string
    
78. processor_group_name string
    
79. service_names string orcl
    
81. 6.tnsnames文件中对service的使用
    
82. [oracle@rac2 admin]$ more tnsnames.ora
    
83. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1
    
84. /network/admin/tnsnames.ora
    
85. # Generated by Oracle configuration tools.
    
86. ORCL_s =
    
87.   (DESCRIPTION =
    
88.     (ADDRESS = (PROTOCOL = TCP)(HOST = scan.example.com)(PORT = 1521))
    
89.     (CONNECT_DATA =
    
90.       (SERVER = DEDICATED)
    
91.       (SERVICE_NAME = s1)
    
92.     )
    
93.   )
    
95. 7.failover测试
    
96. [oracle@rac2 admin]$ sqlplus scott/oracle@orcl_s
    
97. SQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 28 15:38:48 2015
    
98. Copyright (c) 1982, 2011, Oracle. All rights reserved.
    
99. 
    
100. Connected to:
     
101. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
     
102. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
     
103. Data Mining and Real Application Testing options
     
104. SQL> select instance_name from v$instance;    ##########这里对scott授了dba权限##########
     
105. INSTANCE_NAME
     
106. ----------------
     
107. 
     
108. orcl1
     
109. SQL> select * from dba_objects;
     
110. .........
     
111. -----------select语句执行中-----------
     
112. 
     
113. 在其他终端shutdown abort实例1
     
114. SQL> shutdown abort;
     
115. ORACLE instance shut down.
     
116. -----------select语句执行中-----------
     
117. 
     
118. .........
     
119. ------------------------------
     
120. 
     
121. 18-SEP-11 18-SEP-11 2011-09-18:17:39:06 VALID N N N 1
     
122. 
     
123. ERROR:
     
124. ORA-25401: can not continue fetches    ##########因为参数设置为session而非select##########
     
125. 
     
126. 12780 rows selected.
     
127. SQL> select instance_name from v$instance;
128. 
     INSTANCE_NAME
     ----------------
     orcl2

     成功failover到节点2。
     另外需要注意：  
     SYSDBA Sessions Do Not Failover with SRVCTL TAF Configured。
     不能使用SYSDBA

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29781254/viewspace-1854033/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29781254/viewspace-1854033/