OCR中添加ASM DG资源
1、1：现象说明crsdg和crsmirdg 都处于mounted状态。且集群运行正常[root@node1 grid]# crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-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" -icrsctl 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.dgCRS-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' failedCRS-2674: Start of 'ora.crsdg.dg' on 'node1' failedCRS-4000: Command Start failed, or completed with errors.[grid@node2 ~]$ crsctl start res ora.crsmirdg.dgCRS-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' failedCRS-2674: Start of 'ora.crsmirdg.dg' on 'node1' failedCRS-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.dgcrsctl 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" -icrsctl 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.dgCRS-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 performedORA-15017: diskgroup "CRSSG" cannot be mountedORA-15063: ASM discovered an insufficient number of disks for diskgroup "CRSSG"[root@node1 grid]# crsctl start resource ora.CRSMIRDG.dgCRS-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' succeededCRS-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.dgCRS-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' succeededCRS-2676: Start of 'ora.CRSDG.dg' on 'node1' succeeded
7、7：检测crsdg和crsmirdg资源[root@node1 grid]# crsctl status resource ora.CRSDG.dgNAME=ora.CRSDG.dgTYPE=ora.diskgroup.typeTARGET=ONLINE , ONLINESTATE=ONLINE on node1, ONLINE on node2[root@node1 grid]# crsctl status resource ora.CRSMIRDG.dgNAME=ora.CRSMIRDG.dgTYPE=ora.diskgroup.typeTARGET=ONLINE , ONLINESTATE=ONLINE on node1, ONLINE on node2[root@node1 grid]# crs_stat -tName 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 ..............................
