Oracle 11g RAC Summary

1. View all instances and states of the database

Unixdev$[/home/grid]srvctl Status Database-d unixdev                           Instance unixdev11 is running on node unixdevinstance unixd EV12 is running on node unixtest

* Note: Execution under Oracle or grid is possible

2. View the status of the node app on a specific node, you can see: Status of 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 are running on NODE:UNIXDEVGSD are DISABLEDGSD is isn't running on node: Unixdevons is enabledons daemon are running on Node:unixdev

3. View ASM Instance Status

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 Viewing ASM instance configuration information

unixdev$[/home/grid]srvctl status asm           #查看asm运行在哪些服务器上ASM is running on unixdev,unixtestunixdev$[/home/ Grid]srvctl Config asm-n unixdev        Warning:-/grid/11.2.  0/gridasm listener:listenerunixdev$[/home/grid]srvctl config asm-n unixtestwarning:-  /grid/11.2. 0/gridasm Listener:listener

4. Display all registered databases in OCR

unixdev$[/home/grid]srvctl config Databaseunixdev

4.1 Viewing the RAC database details configuration

Unixdev$[/home/grid]srvctl Config database-/oracle/app/product/11.2. 0  +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. Close the RAC Database

su --d node         -d node       #查看实例状态Instance Instance1 is not running on node rac1instance Instance2 is not running on node Rac2su - root          #必须在root下cd $grid _home/bin. /crsctl stop cluster       #停止本节点集群服务. /crsctl Stop cluster-all  #停止所有节点集群服务或 [. /crsctl stop cluster-n Rac1 RAC2]

5.1 Closing a single-node RAC

su -d node-i node1  #关闭实例 su -n node1           #停止节点集群服务

6. Turn on the RAC database
The default boot will start automatically, if you need to start manually, execute:

su - rootcd $grid _home/bin. /crsctl Start cluster-all            #开启集群服务 su -d node          #开启实例

6.1 Opening a single-node RAC

su --n node1          #开启集群服务 su -d node-i node1 #开启实例

7.OCR Inspection

[[Email protected] ~]$ ocrcheckstatus of Oracle Cluster Registry is as follows:version:3Total Space (Kbytes):262120used Space (Kbytes):2992Available Space (Kbytes):259128ID:115473992Device/file Name: +DATA Device/File Integrity Check succeeded Device/File Not Configured Device/File Not Configured Device/File Not Configured Device/File Not Configured Cluster registry integrity check succeeded Logical corruption check bypassed due t o Non-privileged User

7.1 Viewing an OCR backup

[Email protected] disks]$ Ocrconfig-showbackup #Oracle每4个小时备份一次, keep 3 versions Node1 the/ -/ -  -: to: -                                   xx. Ocrnode1 the/ -/ -  the: to: the/grid/product/11.2.0/cdata/node-cluster/Backup01.ocrnode1 the/ -/ -  to: to: the/grid/product/11.2.0/cdata/node-cluster/Backup02.ocrnode1 the/ -/ -  to: to: -/grid/product/11.2.0/cdata/node-cluster/Day.ocrnode1 the/ -/ A  -: in: -/grid/product/11.2.0/cdata/node-cluster/Week.ocrprot- -: Manual Backups forThe Oracle Cluster Registry is not available

7.2 OCR Recovery

su ---restore/grid/product/11.2. 0/CDATA/NODE-CLUSTER/BACKUP01.OCR

7.3 Adding an OCR image

-export Exporting OCR Information

8. View the voting disk

unixdev$[/]crsctl Query css votedisk##  State    file Universal Id                file Name Disk Group-  ----- c11/>-----------------                1. ONLINE   8c8c1105b3574f13bf8b95d79452e45f (/dev/rdisk/1 voting disk (s).

Oracle 11g RAC Summary