RAC Scan与Service资源

一、 Scan资源

查看scan解析的vip地址
nslookup scan_name

查看scan配置信息
srvctl config scan

查看scan vip节点分配/scan状态
srvctl status scan

查看scan监听器配置信息
srvctl config scan_listener

查看scan监听器运行节点/监听状态
srvctl status scan_listener

切换监听及scan ip
/data/prd/grid/12c/bin/srvctl relocate scan_listener -i 1 -n RAC-DB-T01

 

二、 Service资源

添加service资源
srvctl add service -d newdb -s myservice -r rac3 -a rac4 -P BASIC

-d db名
-s 服务名
-r 首选节点列表
-a 备用节点列表
-p TAF策略，对应failover_method属性

启/停service资源
srvctl start|stop service -d racdb -s myservice

启用或禁止某些资源随crs启动
srvctl disable|enable service -d racdb -s myservice -i rac3

查看service资源状态
srvctl status service -d ractest

[grid@RAC-DB-T02 ~]$ srvctl status service -d ractest
Service racsrv is running on nodes: ibg-rac-db-cwt01

查看service资源配置信息
srvctl config service -d ractest

[grid@RAC-DB-T02 ~]$ srvctl config service -d ractest             
Service name: racsrv
Server pool: srvpool1
Cardinality: SINGLETON
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type: 
Failover method: 
TAF failover retries: 
TAF failover delay: 
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition: 
Pluggable database name: 
Maximum lag time: ANY
SQL Translation Profile: 
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Session State Consistency: 
GSM Flags: 0
Service is enabled
Service is individually enabled on nodes: 
Service is individually disabled on nodes: 

相关视图
gv$session
gv$services
dba_services