当前位置：Gxlcms > 数据库问题 > Oracle11g添加asm磁盘到asm磁盘组，发现添加错误如何删除新添加到磁盘？

Oracle11g添加asm磁盘到asm磁盘组，发现添加错误如何删除新添加到磁盘？

时间：2021-07-01 10:21:17 帮助过：28人阅读

‘/dev/oracleasm/disks/DATA009‘ rebalance power 0;

SQL>select group_number,name ,path from v$asm_disk;
GROUP_NUMBER NAME PATH
------------ ------------- ------------------------------
1 ARCH_0003 /dev/oracleasm/disks/ARCH004
1 ARCH_0002 /dev/oracleasm/disks/ARCH003
1 ARCH_0005 /dev/oracleasm/disks/ARCH006
1 ARCH_0004 /dev/oracleasm/disks/ARCH005
1 ARCH_0007 /dev/oracleasm/disks/DATA014
1 ARCH_0006 /dev/oracleasm/disks/DATA013
1 ARCH_0011 /dev/oracleasm/disks/DATA018
1 ARCH_0010 /dev/oracleasm/disks/DATA017
1 ARCH_0009 /dev/oracleasm/disks/DATA016
1 ARCH_0008 /dev/oracleasm/disks/DATA015
······
27 rows selected.

其中存储工程师帮忙提供的存储DATA*是提供给DATA磁盘组使用的，因此存在问题。

删除磁盘命令

alter diskgroup arch drop disk <span style="color: #800000;">‘</span><span style="color: #800000;">ARCH_0006</span><span style="color: #800000;">‘</span> rebalance power <span style="color: #800080;">0</span><span style="color: #000000;">;
alter diskgroup arch drop disk </span><span style="color: #800000;">‘</span><span style="color: #800000;">ARCH_0007</span><span style="color: #800000;">‘</span> rebalance power <span style="color: #800080;">0</span><span style="color: #000000;">;
alter diskgroup arch drop disk </span><span style="color: #800000;">‘</span><span style="color: #800000;">ARCH_0008</span><span style="color: #800000;">‘</span> rebalance power <span style="color: #800080;">0</span><span style="color: #000000;">;
alter diskgroup arch drop disk </span><span style="color: #800000;">‘</span><span style="color: #800000;">ARCH_0009</span><span style="color: #800000;">‘</span> rebalance power <span style="color: #800080;">0</span><span style="color: #000000;">;
alter diskgroup arch drop disk </span><span style="color: #800000;">‘</span><span style="color: #800000;">ARCH_0010</span><span style="color: #800000;">‘</span> rebalance power <span style="color: #800080;">0</span><span style="color: #000000;">;
alter diskgroup arch drop disk </span><span style="color: #800000;">‘</span><span style="color: #800000;">ARCH_0011</span><span style="color: #800000;">‘</span> rebalance power <span style="color: #800080;">0</span>;<br>此时删除成功，但是视图查询ARCH磁盘还在！！！需要重平衡。

alter diskgroup arch rebalance power 6;

再次查询视图

SQL>select group_number,name ,path from v$asm_disk;

SQL>select group_number,name ,path from v$asm_disk;
GROUP_NUMBER NAME PATH
------------ ------------- ------------------------------
/dev/oracleasm/disks/DATA014
/dev/oracleasm/disks/DATA013
/dev/oracleasm/disks/DATA018
/dev/oracleasm/disks/DATA017
/dev/oracleasm/disks/DATA016
/dev/oracleasm/disks/DATA015