OCR中添加ASM DG资源
1、1:现象说明
crsdg和crsmirdg 都处于mounted状态。且集群运行正常
[root@node1 grid]# crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
2、2:查看OCR资源
[grid@node2 ~]$ crsctl stat res 简单查看所有OCR资源
[grid@node2 ~]$ crsctl stat res -p 详细查看所有OCR资源
[grid@node2 ~]$ crsctl stat res -p 详细查看所有OCR资源
[grid@node2 ~]$ crsctl stat res ora.DATADG.dg -p
3、3:添加crsdg和crsmirdg资源
crsctl add res ora.crsdg.dg -type ora.diskgroup.type -attr "ACL='owner:grid:rwx,pgrp:oinstall:rwx,other::rw-',AUTO_START=always,VERSION=11.2.0.4.0" -i
crsctl add res ora.crsmirdg.dg -type ora.diskgroup.type -attr "ACL='owner:grid:rwx,pgrp:oinstall:rwx,other::rw-',AUTO_START=always,VERSION=11.2.0.4.0" -i
4、4:启动crsdg和crsmirdg资源
[grid@node2 ~]$ crsctl start res ora.crsdg.dg
CRS-2672: Attempting to start 'ora.crsdg.dg' on 'node1'
CRS-2672: Attempting to start 'ora.crsdg.dg' on 'node2'
CRS-2674: Start of 'ora.crsdg.dg' on 'node2' failed
CRS-2674: Start of 'ora.crsdg.dg' on 'node1' failed
CRS-4000: Command Start failed, or completed with errors.
[grid@node2 ~]$ crsctl start res ora.crsmirdg.dg
CRS-2672: Attempting to start 'ora.crsmirdg.dg' on 'node1'
CRS-2672: Attempting to start 'ora.crsmirdg.dg' on 'node2'
CRS-2674: Start of 'ora.crsmirdg.dg' on 'node2' failed
CRS-2674: Start of 'ora.crsmirdg.dg' on 'node1' failed
CRS-4000: Command Start failed, or completed with errors.
启动报错,无法启动
5、5:解决启动报错问题 --DG需要大写
删除原有资源,因为这两个资源没有启动,可以直接删除,如果启动需要停止。
[root@node1 grid]# crsctl delete resource ora.crsdg.dg
[root@node1 grid]# crsctl delete resource ora.crsmirdg.dg
crsctl add resource ora.CRSSG.dg -type ora.diskgroup.type -attr "ACL='owner:grid:rwx,pgrp:oinstall:rwx,other::rw-',AUTO_START=always,VERSION=11.2.0.4.0" -i
crsctl add resource ora.CRSMIRDG.dg -type ora.diskgroup.type -attr "ACL='owner:grid:rwx,pgrp:oinstall:rwx,other::rw-',AUTO_START=always,VERSION=11.2.0.4.0" -i
6、6:重新启动crsdg和crsmirdg资源
[root@node1 grid]# crsctl start resource ora.CRSSG.dg
CRS-2672: Attempting to start 'ora.CRSSG.dg' on 'node1'
CRS-2672: Attempting to start 'ora.CRSSG.dg' on 'node2'
CRS-5017: The resource action "ora.CRSSG.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "CRSSG" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "CRSSG"
[root@node1 grid]# crsctl start resource ora.CRSMIRDG.dg
CRS-2672: Attempting to start 'ora.CRSMIRDG.dg' on 'node2'
CRS-2672: Attempting to start 'ora.CRSMIRDG.dg' on 'node1'
CRS-2676: Start of 'ora.CRSMIRDG.dg' on 'node1' succeeded
CRS-2676: Start of 'ora.CRSMIRDG.dg' on 'node2' succeeded
发现ora.CRSSG.dg启动失败,ora.CRSMIRDG.dg 启动成功。原因是ora.CRSSG.dg命名错误。
重新删除ora.CRSSG.dg资源,再创建,再启动:
[root@node1 grid]# crsctl delete resource ora.CRSSG.dg
[root@node1 grid]# crsctl add resource ora.CRSDG.dg -type ora.diskgroup.type -attr "ACL='owner:grid:rwx,pgrp:oinstall:rwx,other::rw-',AUTO_START=always,VERSION=11.2.0.4.0" -i
[root@node1 grid]# crsctl start resource ora.CRSDG.dg
CRS-2672: Attempting to start 'ora.CRSDG.dg' on 'node2'
CRS-2672: Attempting to start 'ora.CRSDG.dg' on 'node1'
CRS-2676: Start of 'ora.CRSDG.dg' on 'node2' succeeded
CRS-2676: Start of 'ora.CRSDG.dg' on 'node1' succeeded
7、7:检测crsdg和crsmirdg资源
[root@node1 grid]# crsctl status resource ora.CRSDG.dg
NAME=ora.CRSDG.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE , ONLINE
STATE=ONLINE on node1, ONLINE on node2
[root@node1 grid]# crsctl status resource ora.CRSMIRDG.dg
NAME=ora.CRSMIRDG.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE , ONLINE
STATE=ONLINE on node1, ONLINE on node2
[root@node1 grid]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRSDG.dg ora....up.type ONLINE ONLINE node1
ora....IRDG.dg ora....up.type ONLINE ONLINE node1
ora.DATADG.dg ora....up.type ONLINE ONLINE node1
ora....ER.lsnr ora....er.type ONLINE ONLINE node1
ora....N1.lsnr ora....er.type ONLINE ONLINE node2
..............................