oracle12c-AFD故障_oracle afd-优快云博客

本文链接：https://blog.youkuaiyun.com/kevinyu998/article/details/129969422

在处理一个12c数据库集群的问题时，由于硬件故障导致db2节点重启，ASM磁盘组出现不完整错误。通过检查发现新添加的磁盘在两个节点上的PowerPath合成名称不一致。大神使用`asmcmdafd_label`命令进行AFD标签迁移，成功解决了ORA-15040和ORA-15042错误，使数据库集群恢复正常运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

记录一个真实的案例，最后请了某大神解决的，之前没有研究过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

AFD命令

+ASM1:/home/grid@db1> asmcmd afd_lsdsk

20230912日重启测试-配置后启动正常
# export ORACLE_HOME=/u01/app/12.2.0
# /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
# /u01/app/12.2.0/bin/crsctl start crs

常用命令，root用户执行

. /home/grid/.bash_profile
asmcmd afd_label REDO1 /dev/sdr
asmcmd afd_lslbl
asmcmd afd_lsdsk
asmcmd afd_scan
asmcmd afd_unlabel REDO1

SQL> CREATE DISKGROUP REDO1 EXTERNAL REDUNDANCY DISK 'AFD:REDO1', 'AFD:REDO2' attribute 'compatible.asm'='19.0.0.0.0',
'compatible.rdbms'='10.1.0.0.0','compatible.advm'='19.0.0.0.0','au_size'='4M';

asmcmd afd_label命令，

结合--init参数就可以完成对磁盘打AFD的标签，

如果遇到已经是AFD磁盘了，可以通过添加--migrate参数。