oracle12c

记录一个真实的案例，最后请了某大神解决的，之前没有研究过12c的AFD

首先说下背景：

我刚刚接手某客户一周不到，因硬件故障，突然db2节点重启了，重启就发现无法启动12C集群了，登录环境查看发现，使用emcpowerpath多路径，+DATA和+FRA扩展过一次磁盘组，本次出问题的就是后加的2个磁盘，对比两个节点，db2上后加磁盘的powerpath后的合成名称和db1上不一致，报错如下

ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "2" is missing from group number "1"
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/dxdb2/crs/trace/crsd_oraagent_grid.trc".
2021-11-16 02:21:54.076 [ORAAGENT(5666)]CRS-5017: The resource action "ora.DATA.dg start" encountered the following error:
2021-11-16 02:21:54.076+ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "2" is missing from group number "1"
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/dxdb2/crs/trace/crsd_oraagent_grid.trc".
2021-11-16 02:22:06.403 [ORAAGENT(5666)]CRS-5017: The resource action "ora.FRA.dg start" encountered the following error:
2021-11-16 02:22:06.403+ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "2" is missing from group number "1"
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/dxdb2/crs/trace/crsd_oraagent_grid.trc".

外援大神就搞了这2个命令解决问题

/u01/app/12.2.0/bin/asmcmd afd_label 'FRA3' /dev/emcpowero --migrate

/u01/app/12.2.0/bin/asmcmd afd_label 'DATA3' /dev/emcpowerp --migrate