一.巡检RAC数据库
1.1列出数据库
[grid@node1 ~]$ srvctl config databaseracdb[grid@node1 ~]$
1.2列出数据库的实例
[grid@node1 ~]$ srvctl status database -d racdbInstance racdb1 is running on node node1Instance racdb2 is running on node node2
1.3数据库的配置
[grid@node1 ~]$ srvctl config database -d racdb -aDatabase unique name: racdbDatabase name: racdbOracle home: /u01/app/oracle/11.2.0/dbhome_1Oracle user: oracleSpfile: +DATA/racdb/spfileracdb.oraDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: racdbDatabase instances: racdb1,racdb2Disk Groups: DATAServices: Database is enabledDatabase is administrator managed[grid@node1 ~]$
二.巡检Grid
2.1集群名称
[grid@node1 ~]$ cemutlo -nscan-cluster[grid@node1 ~]$
2.2检查集群栈状态
[grid@node1 ~]$ crsctl check cluster -all**************************************************************node1:CRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online**************************************************************node2:CRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online**************************************************************[grid@node1 ~]$
2.3 集群的资源
[grid@node1 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE ONLINE node1 ONLINE ONLINE node2 ora.LISTENER.lsnr ONLINE ONLINE node1 ONLINE ONLINE node2 ora.asm ONLINE ONLINE node1 Started ONLINE ONLINE node2 Started ora.eons ONLINE ONLINE node1 ONLINE ONLINE node2 ora.gsd OFFLINE OFFLINE node1 OFFLINE OFFLINE node2 ora.net1.network ONLINE ONLINE node1 ONLINE ONLINE node2 ora.ons ONLINE ONLINE node1 ONLINE ONLINE node2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE node2 ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE node1 ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE node1 ora.node1.vip 1 ONLINE ONLINE node1 ora.node2.vip 1 ONLINE ONLINE node2 ora.oc4j 1 OFFLINE OFFLINE ora.racdb.db 1 ONLINE ONLINE node1 Open 2 ONLINE OFFLINE ora.scan1.vip 1 ONLINE ONLINE node2 ora.scan2.vip 1 ONLINE ONLINE node1 ora.scan3.vip 1 ONLINE ONLINE node1 [grid@node1 ~]$
主机node1的更加详细的资源
[grid@node1 ~]$ crsctl status res -t -init--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm 1 ONLINE ONLINE node1 Started ora.crsd 1 ONLINE ONLINE node1 ora.cssd 1 ONLINE ONLINE node1 ora.cssdmonitor 1 ONLINE ONLINE node1 ora.ctssd 1 ONLINE ONLINE node1 ACTIVE:0 ora.diskmon 1 ONLINE ONLINE node1 ora.evmd 1 ONLINE ONLINE node1 ora.gipcd 1 ONLINE ONLINE node1 ora.gpnpd 1 ONLINE ONLINE node1 ora.mdnsd 1 ONLINE ONLINE node1 [grid@node1 ~]$
主机node2的更加详细的资源
[grid@node2 ~]$ crsctl status res -t -init--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm 1 ONLINE ONLINE node2 Started ora.crsd 1 ONLINE ONLINE node2 ora.cssd 1 ONLINE ONLINE node2 ora.cssdmonitor 1 ONLINE ONLINE node2 ora.ctssd 1 ONLINE ONLINE node2 ACTIVE:-11700 ora.diskmon 1 ONLINE ONLINE node2 ora.evmd 1 ONLINE ONLINE node2 ora.gipcd 1 ONLINE ONLINE node2 ora.gpnpd 1 ONLINE ONLINE node2 ora.mdnsd 1 ONLINE ONLINE node2 [grid@node2 ~]$
2.4检查节点应用
[grid@node1 ~]$ srvctl status nodeappsVIP node1-vip is enabledVIP node1-vip is running on node: node1VIP node2-vip is enabledVIP node2-vip is running on node: node2Network is enabledNetwork is running on node: node1Network is running on node: node2GSD is disabledGSD is not running on node: node1GSD is not running on node: node2ONS is enabledONS daemon is running on node: node1ONS daemon is running on node: node2eONS is enabledeONS daemon is running on node: node1eONS daemon is running on node: node2[grid@node1 ~]$
2.5 检查SCAN
检查scan-ip地址的配置[grid@node1 ~]$ srvctl config scanSCAN name: scan-cluster.com, Network: 1/192.168.0.0/255.255.255.0/eth0SCAN VIP name: scan1, IP: /scan-cluster/192.168.0.24SCAN VIP name: scan2, IP: /scan-cluster/192.168.0.25SCAN VIP name: scan3, IP: /scan-cluster/192.168.0.26[grid@node1 ~]$ 检查scan-ip地址的实际分布及状态[grid@node1 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node node2SCAN VIP scan2 is enabledSCAN VIP scan2 is running on node node1SCAN VIP scan3 is enabledSCAN VIP scan3 is running on node node1[grid@node1 ~]$ 检查scan监听配置[grid@node1 ~]$ srvctl config scan_listenerSCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521[grid@node1 ~]$ 检查scan监听状态[grid@node1 ~]$ srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is running on node node2SCAN Listener LISTENER_SCAN2 is enabledSCAN listener LISTENER_SCAN2 is running on node node1SCAN Listener LISTENER_SCAN3 is enabledSCAN listener LISTENER_SCAN3 is running on node node1[grid@node1 ~]$
2.6 检查VIP和监听
检查VIP的配置情况[grid@node1 ~]$ srvctl config vip -n node1VIP exists.:node1VIP exists.: /node1-vip/192.168.0.21/255.255.255.0/eth0[grid@node1 ~]$ srvctl config vip -n node2VIP exists.:node2VIP exists.: /node2-vip/192.168.0.31/255.255.255.0/eth0[grid@node1 ~]$检查VIP的状态[grid@node1 ~]$ srvctl status nodeapps或[grid@node1 ~]$ srvctl status vip -n node1VIP node1-vip is enabledVIP node1-vip is running on node: node1[grid@node1 ~]$ srvctl status vip -n node2VIP node2-vip is enabledVIP node2-vip is running on node: node2[grid@node1 ~]$ 检查本地监听配置：[grid@node1 ~]$ srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome:/u01/app/11.2.0/grid on node(s) node2,node1End points: TCP:1521检查本地监听状态：[grid@node1 ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): node1,node2[grid@node1 ~]$
2.7 检查ASM
检查ASM状态[grid@node1 ~]$ srvctl status asm -aASM is running on node1,node2ASM is enabled.检查ASM配置[grid@node1 ~]$ srvctl config asm -aASM home: /u01/app/11.2.0/gridASM listener: LISTENERASM is enabled.[grid@node1 ~]$ 检查磁盘组[grid@node1 ~]$ srvctl status diskgroup -g DATADisk Group DATA is running on node1,node2[grid@node1 ~]$ 查看ASM磁盘[root@node1 bin]# oracleasm listdisksVOL1VOL2[root@node1 bin]#查看物理磁盘与asm 磁盘对应关系[root@node1 bin]# oracleasm querydisk -v -p VOL1Disk "VOL1" is a valid ASM disk/dev/sdb1: LABEL="VOL1" TYPE="oracleasm" [root@node1 bin]#
2.8检查集群节点间的时钟同步
检查节点node1的时间同步[grid@node1 ~]$ cluvfy comp clocksync -verbose.......Verification of Clock Synchronization across the cluster nodes was successful. [grid@node1 ~]$
检查节点node2的时间同步[grid@node2 ~]$ cluvfy comp clocksync -verbose.............. CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...Reference Time Offset Limit: 1000.0 msecsCheck: Reference Time Offset Node Name Time Offset Status ------------ ------------------------ ------------------------ node2 -89900.0 failed Result: PRVF-9661 : Time offset is NOT within the specified limits on the following nodes: "[node2]" PRVF-9652 : Cluster Time Synchronization Services check failedVerification of Clock Synchronization across the cluster nodes was unsuccessful on all the specified nodes. [grid@node2 ~]$
注：节点2的服务器时间出现问题
至此，对Grid的巡检基本上就算完成了