7.如何管理RAC集群中的各种资源
在rac集群中定义了若干种资源,当clusterware和数据库服务器被启动时,这些资源将被激活。这些资源的定义被存放在OCR文件中,其中有一些资源表现为操作系统中的进程。例如:
VIP、SCAN、ASM进程、磁盘组等资源,当数据库软件安装后,数据库被创建之后,便产生了数据库、数据库实例、数据库监听器等资源。
OLSNODES工具
节点虚拟IP地址
[grid@r1 grid]$ olsnodes -i
r1 r1-vip
r2 r2-vip
节点状态信息
[grid@r1 grid]$ olsnodes -s
r1 Active
r2 Active
节点名称节点号
[root@racn1 bin]# ./olsnodes -n
racn1 1
racn2 2
打印本地私有内连网络地址
[root@racn1 bin]# ./olsnodes -l -p
racn1 192.168.187.128,192.168.44.128
[root@racn1 bin]#
Clusterware 的名称
[root@racn1 bin]# ./olsnodes -c
rac-cluster
[root@racn1 bin]#
查看本地节点信息
[root@racn1 bin]# ./olsnodes -n -i -s -t -l -p
racn1 1 192.168.187.128,192.168.44.128 racn1-vip Active Unpinne
d
CRSCTL工具
crsctl 是clusterware 的重要管理工具,主要用于高可用性服务层的资源管理,能够查看、启用、禁用、启动、停止、增加、删除和修改高可用服务层资源。
禁用CRS自动启动
[root@racn1 bin]# ./crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@racn1 bin]#
启用crs自动启动
[root@racn1 bin]# ./crsctl enable crs
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@racn1 bin]#
说明:除了CRS可以启用/禁用外,其他资源也可以启用和禁用,禁用之后的资源将不会随着ohasd的启动而自动启动
检查高可用性服务层资源状态
[root@racn1 bin]# ./crsctl status res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE racn1 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE racn1
ora.crf
1 ONLINE ONLINE racn1
ora.crsd
1 ONLINE ONLINE racn1
ora.cssd
1 ONLINE ONLINE racn1
ora.cssdmonitor
1 ONLINE ONLINE racn1
ora.ctssd
1 ONLINE ONLINE racn1 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE racn1
ora.gipcd
1 ONLINE ONLINE racn1
ora.gpnpd
1 ONLINE ONLINE racn1
ora.mdnsd
1 ONLINE ONLINE racn1
[root@racn1 bin]#
检查所有节点CRS组件的状态
[root@racn1 bin]# ./crsctl check cluster //查看本地CRS组件状态
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@racn1 bin]# ./crsctl check cluster -all
**************************************************************
racn1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
racn2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
查看CRS的状态,包括:ohas,css,evm,crs的状态
[root@racn1 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@racn1 bin]#
管理具体的某个资源
例如,ora.crsd 是offline。
[root@racn1 bin]# ./crsctl start res ora.crsd -init
CRS-5702: Resource 'ora.crsd' is already running on 'racn1'
CRS-4000: Command Start failed, or completed with errors.
[root@racn1 bin]#
强制停止clusterware服务
[root@racn1 bin]# ./crsctl stop crs -f