测试RAC的功能
1、查看RAC服务状态 node1-> crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type ONLINE ONLINE node1 ora.FLASH.dg ora....up.type ONLINE ONLINE node1 ora.GRIDDG.dg ora....up.type ONLINE ONLINE node1 ora....ER.lsnr ora....er.type ONLINE ONLINE node1 ora....N1.lsnr ora....er.type ONLINE ONLINE node1 ora.asm ora.asm.type ONLINE ONLINE node1 ora.cvu ora.cvu.type ONLINE ONLINE node1 ora.devdb.db ora....se.type ONLINE OFFLINE ora.gsd ora.gsd.type OFFLINE OFFLINE ora....network ora....rk.type ONLINE ONLINE node1 ora....SM1.asm application ONLINE ONLINE node1 ora....E1.lsnr application ONLINE ONLINE node1 ora.node1.gsd application OFFLINE OFFLINE ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip ora....t1.type ONLINE ONLINE node1 ora....SM2.asm application ONLINE ONLINE node2 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.gsd application OFFLINE OFFLINE ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip ora....t1.type ONLINE ONLINE node2 ora.oc4j ora.oc4j.type ONLINE ONLINE node1 ora.ons ora.ons.type ONLINE ONLINE node1 ora....ry.acfs ora....fs.type ONLINE ONLINE node1 ora.scan1.vip ora....ip.type ONLINE ONLINE node1 2、检查CRS的状态 1）查看本地节点CRS状态 node1-> 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 node2-> 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 2）查看集群CRS状态 node1-> crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online 3）查看evm事件管理器状态 node1-> crsctl check evm CRS-4533: Event Manager is online3、查看RAC集群里节点的配置信息 node1-> olsnodes node1 node2 node1-> olsnodes -n -i -s --- -n列出节点编号 -i列出虚拟ip -s列出状态 node1 1 node1-vip Active node2 2 node2-vip Active 4、查看RAC集群中软件版本信息 1）查看集群软件使用版本信息 node1-> crsctl query crs activeversion Oracle Clusterware active version on the cluster is [11.2.0.4.0] 2）查看集群软件发行版本信息 node1-> crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [11.2.0.4.0] 3）查看集群软件安装版本信息 node1-> crsctl query crs softwareversion Oracle Clusterware version on node [node1] is [11.2.0.4.0] 5、查看集群软件表决磁盘信息 node1-> crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 2a0486c2db354fbfbf5d5d3b6b2af4fd (ORCL:VOL1) [GRIDDG] Located 1 voting disk(s). 6、查看系统DNS相关配置信息 node1-> crsctl query dns -servers CRS-10018: the following configuration was found on the system: CRS-10019: There are 1 domains in search order. They are: localdomain CRS-10022: There are 1 name servers. They are: 172.16.0.191 CRS-10020: number of retry attempts for name lookup is: 4 CRS-10021: timeout for each name lookup is: 5 以上信息来源于： node1-> cat /etc/resolv.conf search localdomain nameserver 172.16.0.191 7、查看集群SCAN VIP信息 node1-> srvctl config scan SCAN name: scan-cluster.localdomain， Network: 1/172.16.0.0/255.255.240.0/eth0 SCAN VIP name: scan1， IP: /scan-cluster.localdomain/172.16.0.203 node1-> srvctl config scan_listener SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 8、查看OCR信息 [root@node1 bin]# ./ocrcheck -local Status of Oracle Local Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 2676 Available space (kbytes) : 259444 ID : 1155296004 Device/File Name : /u01/app/11.2.0/grid/cdata/node1.olr Device/File integrity check succeeded Local registry integrity check succeeded Logical corruption check succeeded 9、查看OCR集群软件备份信息 node1-> ocrconfig -showbackup node1 2015/04/20 15:58:34 /u01/app/11.2.0/grid/cdata/scan-cluster/backup00.ocr node1 2015/04/20 15:58:34 /u01/app/11.2.0/grid/cdata/scan-cluster/day.ocr node1 2015/04/20 15:58:34 /u01/app/11.2.0/grid/cdata/scan-cluster/week.ocr PROT-25: Manual backups for the Oracle Cluster Registry are not available 10、启、停集群数据库 1）停止RAC数据库 node1-> srvctl stop database -d devdb 2）停止集群服务 [root@node1 ~]# cd /u01/app/11.2.0/grid/bin [root@node1 bin]# ./crsctl stop cluster -all 3）启动集群服务 [root@node1 bin]# pwd /u01/app/11.2.0/grid/bin [root@node1 bin]# ./crsctl start cluster -all 4）启动RAC数据库 node1-> srvctl start database -d devdb
