asm如何更换ocr新磁盘组
测试如下,安装grid选择的四块100g的磁盘组命名为+DATA
创建了三块1g的用于ocr
创建磁盘组命令省略
切换root用户执行如下
[root@rac1 bin]# ./ocrconfig -add +OCR PROT-30: The Oracle Cluster Registry location to be added is not usable PROC-50: The Oracle Cluster Registry location to be added is inaccessible on nodes rac1. [grid@rac1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 409596 407555 0 407555 0 Y DATA/ ASMCMD> exit [grid@rac1 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 25 10:41:57 2021 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> alter diskgroup ARCH mount; Diskgroup altered. SQL> l 1* alter diskgroup ARCH mount SQL> c/ARCH/OCR 1* alter diskgroup OCR mount SQL> / Diskgroup altered. SQL> EXIT Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options [grid@rac1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 409596 409497 0 409497 0 N ARCH/ MOUNTED EXTERN N 512 4096 1048576 409596 407555 0 407555 0 Y DATA/ MOUNTED NORMAL N 512 4096 1048576 3069 2790 1023 883 0 N OCR/ ASMCMD> exit [grid@rac1 ~]$
root账户执行提示错误,asmcmd执行查看磁盘组没有mount ,于是进入slqplus 中对磁盘组进行上线处理
切换root继续执行
[root@rac1 bin]# ./ocrconfig -add +OCR PROT-30: The Oracle Cluster Registry location to be added is not usable PROC-8: Cannot perform cluster registry operation because one of the parameters is invalid. ORA-15056: additional error message ORA-17502: ksfdcre:4 Failed to create file +OCR.255.1 ORA-15221: ASM operation requires compatible.asm of 11.1.0.0.0 or higher ORA-06512: at line 4 [root@rac1 bin]#
提示新的错误,DATA磁盘组时我安装grid时候创建的,OCR,ARCH 时安装后使用sql命令创建的
后来查资料时asm 兼容版本不一致,于是有下列操作步骤
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 25 10:43:52 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> set lines 200
SQL> select name,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup
2
SQL> /
NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
DATA 11.2.0.0.0 10.1.0.0.0
OCR 11.2.0.0.0 10.1.0.0.0
ARCH 11.2.0.0.0 10.1.0.0.0
SQL> alter diskgroup OCR set attribute 'compatible.asm'='11.2';
Diskgroup altered.
SQL> L
1* alter diskgroup OCR set attribute 'compatible.asm'='11.2'
SQL> C/OCR/ARCH
1* alter diskgroup ARCH set attribute 'compatible.asm'='11.2'
SQL> /
Diskgroup altered.
SQL> select name,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup
2 /
NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
DATA 11.2.0.0.0 10.1.0.0.0
OCR 11.2.0.0.0 10.1.0.0.0
ARCH 11.2.0.0.0 10.1.0.0.0
SQL> ho ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2948
Available space (kbytes) : 259172
ID : 40263290
Device/File Name : +DATA
Device/File integrity check succeeded
Device/File Name : +OCR
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
SQL>
切换root账户执行
[root@rac1 bin]# ./ocrconfig -add +OCR
[root@rac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2948
Available space (kbytes) : 259172
ID : 40263290
Device/File Name : +DATA
Device/File integrity check succeeded
Device/File Name : +OCR
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@rac1 bin]# ./ocrconfig -delete +DATA
[root@rac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2948
Available space (kbytes) : 259172
ID : 40263290
Device/File Name : +OCR
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 succeeded
[root@rac1 bin]#
执行完毕

浙公网安备 33010602011771号