oracle删除DG磁盘组,oracle RAC ASM磁盘组删除磁盘的方法

1、检查asm磁盘列表

[root@node1 ~]# su - grid

[grid@node1 ~]$ asmcmd lsdsk

Path

/dev/mapper/mpathaap1

/dev/mapper/mpathaap2

/dev/mapper/mpathabp1

/dev/mapper/mpathabp2

/dev/mapper/mpathacp1

/dev/mapper/mpathacp2

/dev/mapper/mpathadp1

/dev/mapper/mpathaep1

/dev/mapper/mpathaep2

/dev/mapper/mpathb

/dev/mapper/mpathc

/dev/mapper/mpathd

/dev/mapper/mpathe

/dev/mapper/mpathf

/dev/mapper/mpathg

/dev/mapper/mpathh

/dev/mapper/mpathi

/dev/mapper/mpathj

/dev/mapper/mpathk

/dev/mapper/mpathl

/dev/mapper/mpathm

/dev/mapper/mpathn

/dev/mapper/mpatho

/dev/mapper/mpathp

/dev/mapper/mpathq

/dev/mapper/mpathr

/dev/mapper/mpaths

/dev/mapper/mpatht

/dev/mapper/mpathu

/dev/mapper/mpathv

/dev/mapper/mpathw

/dev/mapper/mpathx

/dev/mapper/mpathy

2、检查asm磁盘组状态

准备从磁盘组2 DATADG中删除1块磁盘

3、查看磁盘组2中对应的磁盘

SQL> col path format a30;

SQL> select disk_number, path, name from v$asm_disk where group_number = 2;

   准备删除DATADG_0023这块磁盘，对应的path是/dev/mapper/mpathy

4、drop磁盘

SQL> alter diskgroup datadg drop disk DATADG_0023 rebalance power 1;

5、查询DATADG_0023的磁盘头状态

SQL> select path,header_status from v$asm_disk where path = '/dev/mapper/mpathy';

/dev/mapper/mpathy 仍然是member状态，说明后台的rebalance操作还没有完成

6、查询v$asm_operation视图查看操作执行情况

直到以上的查询记录消失才表示rebalance操作已经完成

7、再次DATADG_0023的磁盘头状态

rebalance操作完成后，磁盘头的状态变成了former，表示该磁盘已经从DATADG磁盘组彻底drop。