[RAC]重建OCR和Votedisk - 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

4475467f22f15efa56.png (121.62 KB, 下载次数: 304)

下载附件

2025-4-6 15:36 上传

检查votedisk盘：

[root@rac1 ~]# cd /u01/app/11.2.0.4/grid/bin/

[root@rac1 bin]# ./crsctl query css votedisk

Unable to communicate with the Cluster Synchronization Services daemon.

1.停止所有节点：

[root@rac1 bin]# ./crsctl stop crs -f

#后续操作以rac1为主节点进行操作

2.dd掉所有的2G磁盘

[root@rac1 bin]# dd if=/dev/zero of=/dev/asmdiskm bs=1024k count=10

10+0 records in

10+0 records out

10485760 bytes (10 MB) copied, 0.0144666 s, 725 MB/s

[root@rac1 bin]# dd if=/dev/zero of=/dev/asmdiskl bs=1024k count=10

10+0 records in

10+0 records out

10485760 bytes (10 MB) copied, 0.0166231 s, 631 MB/s

[root@rac1 bin]# dd if=/dev/zero of=/dev/asmdiskk bs=1024k count=10

10+0 records in

10+0 records out

10485760 bytes (10 MB) copied, 0.0147306 s, 712 MB/s

[root@rac1 bin]# dd if=/dev/zero of=/dev/asmdiskf bs=1024k count=10

10+0 records in

10+0 records out

10485760 bytes (10 MB) copied, 0.0195477 s, 536 MB/s

[root@rac1 bin]# dd if=/dev/zero of=/dev/asmdiskg bs=1024k count=10

10+0 records in

10+0 records out

10485760 bytes (10 MB) copied, 0.015376 s, 682 MB/s

[root@rac1 bin]# dd if=/dev/zero of=/dev/asmdiske bs=1024k count=10

10+0 records in

10+0 records out

10485760 bytes (10 MB) copied, 0.01666 s, 629 MB/s

3.启动rac1的crs

[root@rac1 bin]# ./crsctl start crs -excl -nocrs

3436167f22fce5cac2.png (97.88 KB, 下载次数: 292)

下载附件

2025-4-6 15:39 上传

4.登入asm

检查

[root@rac1 bin]# ll /home/oracle/initasm.ora

-rwxrwxr-x 1 grid oinstall 54 Apr 3 03:51 /home/oracle/initasm.ora

8674067f22ff909f1a.png (81.13 KB, 下载次数: 295)

下载附件

2025-4-6 15:40 上传

[grid@rac1 ~]$ sqlplus / as sysasm

SQL> shutdown immediate;

ORA-15100: invalid or missing diskgroup name

ASM instance shutdown

SQL> startup pfile='/home/oracle/initasm.ora';

ASM instance started

Total System Global Area 1135747072 bytes

Fixed Size 2260728 bytes

Variable Size 1108320520 bytes

ASM Cache 25165824 bytes

ORA-15032: not all alterations performed

ORA-15017: diskgroup "OCR" cannot be mounted

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "OCR"

ORA-15017: diskgroup "OCR2" cannot be mounted

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "OCR2"

ORA-15017: diskgroup "FRA" cannot be mounted

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FRA"

SQL> col path for a30

SQL> select group_number, disk_number, mount_status, header_status, path from v$asm_disk;

no rows selected

修改磁盘头定义：

SQL> shutdown immediate;

SQL> startup mount;

ORA-00099: warning: no parameter file specified for ASM instance

ASM instance started

Total System Global Area 1135747072 bytes

Fixed Size 2260728 bytes

Variable Size 1108320520 bytes

ASM Cache 25165824 bytes

ORA-15032: not all alterations performed

ORA-15017: diskgroup "OCR" cannot be mounted

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "OCR"

ORA-15017: diskgroup "OCR2" cannot be mounted

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "OCR2"

SQL> ALTER SYSTEM SET asm_diskstring='/dev/asm*' ;

System altered.

SQL> shutdown immediate;

手动修改/home/oracle/initasm.ora

6210467f230ba9d734.png (68.63 KB, 下载次数: 298)

下载附件

2025-4-6 15:43 上传

SQL> startup pfile='/home/oracle/initasm.ora';

ASM instance started

Total System Global Area 1135747072 bytes

Fixed Size 2260728 bytes

Variable Size 1108320520 bytes

ASM Cache 25165824 bytes

ORA-15032: not all alterations performed

ORA-15017: diskgroup "OCR" cannot be mounted

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "OCR"

ORA-15017: diskgroup "OCR2" cannot be mounted

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "OCR2"

SQL> col path for a30

SQL> select group_number, disk_number, mount_status, header_status, path from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU PATH

------------ ----------- ------- ------------ ------------------------------

0 0 CLOSED CANDIDATE /dev/asmdiskl

0 1 CLOSED MEMBER /dev/asmdiskb

0 2 CLOSED CANDIDATE /dev/asmdiskg

0 3 CLOSED MEMBER /dev/asmdiski

0 4 CLOSED CANDIDATE /dev/asmdiskf

0 5 CLOSED MEMBER /dev/asmdiskh

0 6 CLOSED MEMBER /dev/asmdiskc

0 7 CLOSED CANDIDATE /dev/asmdiskk

0 9 CLOSED CANDIDATE /dev/asmdiske

0 10 CLOSED MEMBER /dev/asmdiskj

0 11 CLOSED CANDIDATE /dev/asmdiskm

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU PATH

------------ ----------- ------- ------------ ------------------------------

1 0 CACHED MEMBER /dev/asmdiskd

12 rows selected.

5.创建磁盘组：

OCR:

SQL> create diskgroup OCR normal redundancy disk '/dev/asmdiskf','/dev/asmdiskg','/dev/asmdiske' attribute 'compatible.asm'='11.2.0.4.0','compatible.rdbms'='11.2.0.4.0';

9746367f230e0e2095.png (12.12 KB, 下载次数: 300)

下载附件

2025-4-6 15:44 上传

OCR2:

SQL> create diskgroup OCR2 normal redundancy disk '/dev/asmdiskm','/dev/asmdiskl','/dev/asmdiskk' attribute 'compatible.asm'='11.2.0.4.0','compatible.rdbms'='11.2.0.4.0';

9274667f230edb6aef.png (11.43 KB, 下载次数: 286)

下载附件

2025-4-6 15:44 上传

6.创建参数文件:

SQL> create spfile='+OCR' from pfile='/home/oracle/initasm.ora';

File created.

SQL> create spfile='+OCR2' from pfile='/home/oracle/initasm.ora';

File created.

7.恢复crs ocr文件：

[root@rac1 bin]# ./ocrconfig -restore /u01/app/11.2.0.4/grid/cdata/rac-cluster/backup_20250331_225104.ocr

8.恢复votedisk

[root@rac1 bin]# ./crsctl replace votedisk '+OCR'

1107567f23101e603d.png (35.75 KB, 下载次数: 299)

下载附件

2025-4-6 15:45 上传

9.检查votedisk，ocr盘状态

[root@rac1 bin]# ./ocrcheck

8444867f231156d805.png (351.79 KB, 下载次数: 296)

下载附件

2025-4-6 15:45 上传

[root@rac1 bin]# ./crsctl query css votedisk

6792667f231266293b.png (158.78 KB, 下载次数: 300)

下载附件

2025-4-6 15:45 上传

10.停止crs，以正常方式启动所有节点

[root@rac1 bin]# ./crsctl stop crs

[root@rac1 bin]# ./crsctl start crs #在所有节点上进行

如果出现以下状况，请参考相关文档进行修复：[RAC]crs服务修复：清除缓存法

[root@rac2 bin]# ./crsctl check cluster -all

rac1:

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

rac2:

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4529: Cluster Synchronization Services is online

CRS-4534: Cannot communicate with Event Manager

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)