RAC 管理命令集（1）

一:oracle集群管理

1：启动集群软件

[root@rac1 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

2：停止集群软件

[root@rac1 bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2673: Attempting to stop 'ora.diskmon' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.

如果ohasd 服务已经启动，可以用命令：crsctl start cluster –all

 

二：votedisk 管理

1：查询votedisk

[grid@rac1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 68bd6b7662694fc6bf378eab18e7e095 (/dev/asm-votedisk01) []
2. ONLINE 769907a387a14f8cbf9b8e4157bf6a01 (/dev/asm-votedisk02) []
3. ONLINE 0d9134dbf5df4f18bf42b3330d5185d3 (/dev/asm-votedisk03) []
4. ONLINE 66c3ea13d8794f3abff4a86b122de194 (/dev/asm-votedisk04) []
Located 4 voting disk(s).

2：删除votedisk

[grid@rac1 ~]$ crsctl delete css votedisk /dev/asm-votedisk04
CRS-4611: Successful deletion of voting disk /dev/asm-votedisk04.
[grid@rac1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 68bd6b7662694fc6bf378eab18e7e095 (/dev/asm-votedisk01) []
2. ONLINE 769907a387a14f8cbf9b8e4157bf6a01 (/dev/asm-votedisk02) []
3. ONLINE 0d9134dbf5df4f18bf42b3330d5185d3 (/dev/asm-votedisk03) []
Located 3 voting disk(s).

3：增加votedisk

[grid@rac1 ~]$ crsctl add css votedisk /dev/asm-votedisk04
CRS-4611: Successful deletion of voting disk /dev/asm-votedisk04.
[grid@rac1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 68bd6b7662694fc6bf378eab18e7e095 (/dev/asm-votedisk01) []
2. ONLINE 769907a387a14f8cbf9b8e4157bf6a01 (/dev/asm-votedisk02) []
3. ONLINE 0d9134dbf5df4f18bf42b3330d5185d3 (/dev/asm-votedisk03) []
4. ONLINE 66c3ea13d8794f3abff4a86b122de194 (/dev/asm-votedisk04) []
Located 4 voting disk(s).

4：更换votedisk

[grid@rac1 ~]$ crsctl replace votedisk +data
CRS-4256: Updating the profile
Successful addition of voting disk 530a4aa809214fddbfc15e28867f9284.
Successful deletion of voting disk 68bd6b7662694fc6bf378eab18e7e095.
Successful deletion of voting disk 769907a387a14f8cbf9b8e4157bf6a01.
Successful deletion of voting disk 0d9134dbf5df4f18bf42b3330d5185d3.
Successfully replaced voting disk group with +data.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
[grid@rac1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 530a4aa809214fddbfc15e28867f9284 (/dev/asm-disk02) [DATA]
Located 1 voting disk(s).

三：OCR资源管理

1：检查OCR内容的一致性

[grid@rac2 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2760
Available space (kbytes) : 259360
ID : 896108600
Device/File Name : /dev/asm-ocrdisk01
Device/File integrity check succeeded
Device/File Name : /dev/asm-ocrdisk02
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check bypassed due to non-privileged user

2：OCR配置 ocrconfig

   （1）：查看ocr备份信息

[grid@rac2 ~]$ ocrconfig -showbackup

rac2 2012/06/14 00:29:43 /u01/app/grid/11.2.0/cdata/rac-scan/backup00.ocr

rac2 2012/06/13 20:29:40 /u01/app/grid/11.2.0/cdata/rac-scan/backup01.ocr

rac2 2012/06/13 16:29:37 /u01/app/grid/11.2.0/cdata/rac-scan/backup02.ocr

rac1 2012/06/12 07:39:37 /u01/app/grid/11.2.0/cdata/rac-scan/day.ocr

rac1 2012/06/05 23:28:59 /u01/app/grid/11.2.0/cdata/rac-scan/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
[grid@rac2 ~]$

  （2） 导出导出ocr信息

[root@rac2 bin]# ./ocrconfig -export /tmp/ocr.conf
[root@rac2 bin]# ./ocrconfig -import /tmp/ocr.conf

  （3）：增加ocr盘

[root@rac2 bin]# ./ocrconfig -add +data
[root@rac2 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2760
Available space (kbytes) : 259360
ID : 896108600
Device/File Name : /dev/asm-ocrdisk01
Device/File integrity check succeeded
Device/File Name : /dev/asm-ocrdisk02
Device/File integrity check succeeded
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 succeeded

[root@rac2 bin]#

（4）：删除ocr盘（至少保留一个）

[root@rac2 bin]# ./ocrconfig -delete +data
[root@rac2 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2760
Available space (kbytes) : 259360
ID : 896108600
Device/File Name : /dev/asm-ocrdisk01
Device/File integrity check succeeded
Device/File Name : /dev/asm-ocrdisk02
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

[root@rac2 bin]#

 （5）手动备份ocr

     在手动备份之前 得先设置备份目录

[root@rac2 bin]# ./ocrconfig -backuploc /tmp/
[root@rac2 bin]# ./ocrconfig -manualbackup

rac2 2012/06/14 01:11:30 /tmp/backup_20120614_011130.ocr
[root@rac2 bin]# ./ocrconfig -showbackup

rac2 2012/06/14 00:29:43 /u01/app/grid/11.2.0/cdata/rac-scan/backup00.ocr

rac2 2012/06/13 20:29:40 /u01/app/grid/11.2.0/cdata/rac-scan/backup01.ocr

rac2 2012/06/13 16:29:37 /u01/app/grid/11.2.0/cdata/rac-scan/backup02.ocr

rac1 2012/06/12 07:39:37 /u01/app/grid/11.2.0/cdata/rac-scan/day.ocr

rac1 2012/06/05 23:28:59 /u01/app/grid/11.2.0/cdata/rac-scan/week.ocr

rac2 2012/06/14 01:11:30 /tmp/backup_20120614_011130.ocr
[root@rac2 bin]#

 

四：scan 配置

   1：查看scan 状态，看哪些scan ip 分布在哪些节点上

[root@rac2 bin]# ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac1
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac2
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1
[root@rac2 bin]# ./srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac1
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac2
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
[root@rac2 bin]#

2：删除scan

  删除之前得先停掉所有的scan服务

[grid@rac1 ~]$ srvctl stop scan_listener
[grid@rac1 ~]$ srvctl stop scan
[root@rac1 bin]# ./srvctl remove scan_listener
Remove scan listener? (y/[n]) y
[root@rac1 bin]# ./srvctl remove scan
Remove the scan? (y/[n]) y

3：增加scan

   在增加scan 之前要确保scan name 能被正确的解析出来

[root@rac1 bin]# ./srvctl add scan -n rac-scan
[root@rac1 bin]# ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
SCAN VIP scan2 is enabled
SCAN VIP scan2 is not running
SCAN VIP scan3 is enabled
SCAN VIP scan3 is not running
[root@rac1 bin]# ./srvctl add scan_listener
[root@rac1 bin]# ./srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is not running
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is not running