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