Oracle 11g RAC小结

概述1.查看数据库所有实例与状态 *注：在oracle或grid下执行均可 2.在特定节点上查看节点应用的状态，可以看到：VIP、NETWORK、GSD、ONS的状态 3.查看ASM实例状态 3.1查看A

1.查看数据库所有实例与状态

unixdev$[/home/grID]srvctl status database -d unixdev                           Instance unixdev11 is running on node unixdevInstance unixdev12 is running on node unixtest

*注：在oracle或grID下执行均可

2.在特定节点上查看节点应用的状态，可以看到：VIP、NETWORK、GSD、ONS的状态

unixdev$[/home/oracle]srvctl status nodeapps -n unixdevVIP unixdev-vip is enabledVIP unixdev-vip is running on node: unixdevNetwork is enabledNetwork is running on node: unixdevGSD is DisabledGSD is not running on node: unixdevONS is enabledONS daemon is running on node: unixdev

3.查看ASM实例状态

unixdev$[/home/grID]srvctl status asm -n unixdev                                ASM is running on unixdevunixdev$[/home/grID]srvctl status asm -n unixtestASM is running on unixtest

3.1查看ASM实例配置信息

unixdev$[/home/grID]srvctl status asm           #查看asm运行在哪些服务器上ASM is running on unixdev,unixtestunixdev$[/home/grID]srvctl config asm -n unixdev        Warning:-n option has been deprecated and will be ignored.ASM home: /grID/11.2.0/grIDASM Listener: ListENERunixdev$[/home/grID]srvctl config asm -n unixtestWarning:-grIDASM Listener: ListENER

4.显示OCR中所有注册的数据库

grID]srvctl config databaseunixdev

4.1查看RAC数据库详细配置

unixdev$[/home/grID]srvctl config database -d unixdevDatabase unique name: unixdevDatabase name: unixdevOracle home: /oracle/app/product/0Oracle user: oracleSpfile: +DATA/unixdev/spfileunixdev.oraDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: autoMATICServer pools: unixdevDatabase instances: unixdev11,unixdev12disk Groups: DATA,ARCMount point paths: Services: Type: RACDatabase is administrator managed

5.关闭RAC数据库

su - grIDsrvctl stop database -d node         #停止所有节点上的实例srvctl status database -d node       #查看实例状态Instance instance1 is not running on node rac1Instance instance2 is not running on node rac2 root          #必须在root下cd $GRID_HOME/bin./crsctl stop cluster       #停止本节点集群服务./crsctl stop cluster -all  #停止所有节点集群服务或[./crsctl stop cluster -n rac1 rac2]

5.1关闭单节点RAC

su - grID srvctl stop database -d node -i node1 #关闭实例su - root
cd $GRID_HOME/bin
./crsctl stop cluster -n node1 #停止节点集群服务

6.开启RAC数据库
默认开机会自动启动，如果需要手动启动，执行：

rootcd $GRID_HOME/bin./crsctl start cluster -all #开启集群服务 grIDsrvctl start database -d node #开启实例

6.1开启单节点RAC

root
cd $GRID_HOME/bincrsctl start cluster -n node1 #开启集群服务 grIDsrvctl start database -d node -i node1 #开启实例

7.ocr检查

[grID@Node1 ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows :         Version                  :          3         Total space (kbytes)     :     262120         Used space (kbytes)      :       2992         Available space (kbytes) :     259128         ID                       :  115473992         Device/file name         :      +DATA                                    Device/file integrity check succeeded                                    Device/file not configured                                    Device/file not configured         Cluster registry integrity check succeeded         Logical corruption check bypassed due to non-privileged user

7.1 查看ocr备份

[grID@Node1 disks]$ ocrconfig -showbackup     #Oracle每4个小时备份一次，保留3个版本node1     2014/07/28 13:31:50                                   00.ocrnode1     09:49     /grID/product/0/cdata/node-cluster/backup01.ocrnode1     05:backup02.ocrnode1     27 48     /grID/product/day.ocrnode1     22 16:29:28     /grID/product/week.ocrPROT-25: Manual backups for the Oracle Cluster Registry are not available

7.2 ocr恢复

grIDocrconfig -restore file_name例如：ocrconfig -restore /grID/product/0/cdata/node-cluster/backup01.ocr

7.3添加ocr镜像

停掉CRS服务使用命令ocrconfig -export导出ocr信息

8.查看表决磁盘

unixdev$[/]crsctl query CSS Votedisk##  STATE    file Universal ID                file name disk group--  -----    -----------------                --------- --------- 1. ONliNE   8c8c1105b3574f13bf8b95d79452e45f (/dev/rdisk/disk18) [OCRVote]Located 1 voting disk(s).

总结

以上是内存溢出为你收集整理的Oracle 11g RAC小结全部内容，希望文章能够帮你解决Oracle 11g RAC小结所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。