重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛»首页 › 数据库 › Oracle › [RAC]重建OCR和Votedisk

最新公告：

帐号无法登录解决办法，必看!（2023-04-14）

返回列表

查看: 251|回复: 0

[讨论] [RAC]重建OCR和Votedisk

[复制链接]

Inkcup

Inkcup 当前离线

积分: 510

电梯直达

楼主

发表于前天 15:50 | 只看该作者回帖奖励

|倒序浏览 |阅读模式

实验环境：
Oracle Linux7.9
Oracle db&gi 11.2.0.4
两个节点：rac1，rac2

检查网络连接：

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

下载附件

前天 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, 下载次数: 46)

下载附件

前天 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, 下载次数: 46)

下载附件

前天 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, 下载次数: 47)

下载附件

前天 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, 下载次数: 49)

下载附件

前天 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, 下载次数: 49)

下载附件

前天 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'