操作系统版本redhat6.9,数据库版本11.2.0.4;
手工将新增的ASM磁盘添加至ASM磁盘组,发现磁盘组名称写错了!!!如何回退
命令如下 alter diskgroup DATA add disk ‘/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 ‘ARCH_0006‘ rebalance power 0; alter diskgroup arch drop disk ‘ARCH_0007‘ rebalance power 0; alter diskgroup arch drop disk ‘ARCH_0008‘ rebalance power 0; alter diskgroup arch drop disk ‘ARCH_0009‘ rebalance power 0; alter diskgroup arch drop disk ‘ARCH_0010‘ rebalance power 0; alter diskgroup arch drop disk ‘ARCH_0011‘ rebalance power 0;
此时删除成功,但是视图查询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
次数磁盘被重新释放,可以正确的添加了。
Oracle11g添加asm磁盘到asm磁盘组,发现添加错误如何删除新添加到磁盘?
原文:https://www.cnblogs.com/lvcha001/p/13326741.html