标题: ODA: Multipath Disk Partition Was Added with an Incorrect Logical Disk Name a... [打印本页] 作者: 刘泽宇 时间: 2025-2-9 11:02 标题: ODA: Multipath Disk Partition Was Added with an Incorrect Logical Disk Name a... 现象：
1) Multipath disk partition (e.g. "/dev/mapper/HDD_E0_S14_3xxxxxxx6p1") was added to an ODA diskgroup (e.g. +DATA) as follows:
SQL> alter diskgroup DATA add disk '/dev/mapper/HDD_E0_S14_3xxxxxxx6p1';
2) But it was added with a non-standard failgroup name (e.g. "DATA_0014" instead of "HDD_E0_S14_3xxxxxxx6P1") and logical disk name (e.g. "DATA_0014" instead of "HDD_E0_S14_3xxxxxxx6P1"):
Group# Disk# MNT_STA HDR_STAT MODE_ST STATE Total (GB) Free (GB) FAILGROUP NAME PATH
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1 14 CACHED MEMBER ONLINE NORMAL 360 359.1 DATA_0014 DATA_0014 /dev/mapper/HDD_E0_S14_3xxxxxxx6p1
原因：
Disk was added with non-standard failgroup name and logical name (the names were not explicitly defined in the "ALTER DISKGROUP … ADD FAILGROUP …DISK" statement).
处理方法：
We can correct this situation as follows:
1) Drop the associated logical ASM disk (e.g. “DATA_0014” ):
SQL> alter diskgroup data drop disks in failgroup DATA_0014 rebalance power 11;
2) Wait until rebalance operation completes:
SQL> select * from gv$asm_operation;
3) Then add the multipath disk partition back as follows:
SQL> alter diskgroup DATA add failgroup HDD_E0_S14_3xxxxxxx6p1 disk '/dev/mapper/HDD_E0_S14_3xxxxxxx6p1' name HDD_E0_S14_3xxxxxxx6p1 rebalance power 11;
4) Wait until rebalance operation completes:
SQL> select * from gv$asm_operation;
5) Check the new failgroup name and logical disk name:
Group# Disk# MNT_STA HDR_STAT MODE_ST STATE Total (GB) Free (GB) FAILGROUP NAME PATH
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1 14 CACHED MEMBER ONLINE NORMAL 360 359.1 HDD_E0_S14_3xxxxxxx6P1 HDD_E0_S14_3xxxxxxx6P1 /dev/mapper/HDD_E0_S14_3xxxxxxx6p1