当我们进行磁盘组操作的时候,如果在删除磁盘的时候需要取消,那么可以使用alter diskgroup undrop disks命令,以此进行取消,类似于此时的磁盘数据restore
如下当磁盘状态是droping的时候,再次执行undrop;
eg:
SQL> SELECT A.NAME G_NAME, B.NAME D_NAME,B.OS_MB,B.TOTAL_MB,B.FREE_MB,B.STATE, FAILGROUP, B.FAILGROUP_TYPE, PATH 2 FROM V$ASM_DISKGROUP A, V$ASM_DISK B 3 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER 4 AND B.NAME LIKE 'DATAGROUP3%'; G_NAME D_NAME OS_MB TOTAL_MB FREE_MB STATE FAILGROUP FAILGRO PATH --------------- ------------------------- ---------- ---------- ---------- -------- ------------------------------ ------- ---------------------------------------- DATAGROUP3 DATAGROUP3_DISK10 1019 1019 1017 NORMAL FAILGROUP_3 QUORUM /dev/oracleasm/disks/ASMDISK10 DATAGROUP3 DATAGROUP3_DISK7 1019 1019 966 DROPPING FAILGROUP_1 REGULAR /dev/oracleasm/disks/ASMDISK7 DATAGROUP3 DATAGROUP3_DISK8 1019 1019 992 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK9 1019 1019 991 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9 SQL> r 1 SELECT A.NAME G_NAME, B.NAME D_NAME,B.OS_MB,B.TOTAL_MB,B.FREE_MB,B.STATE, FAILGROUP, B.FAILGROUP_TYPE, PATH 2 FROM V$ASM_DISKGROUP A, V$ASM_DISK B 3 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER 4* AND B.NAME LIKE 'DATAGROUP3%' G_NAME D_NAME OS_MB TOTAL_MB FREE_MB STATE FAILGROUP FAILGRO PATH --------------- ------------------------- ---------- ---------- ---------- -------- ------------------------------ ------- ---------------------------------------- DATAGROUP3 DATAGROUP3_DISK10 1019 1019 1017 NORMAL FAILGROUP_3 QUORUM /dev/oracleasm/disks/ASMDISK10 DATAGROUP3 DATAGROUP3_DISK7 1019 1019 966 DROPPING FAILGROUP_1 REGULAR /dev/oracleasm/disks/ASMDISK7 DATAGROUP3 DATAGROUP3_DISK8 1019 1019 992 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK9 1019 1019 991 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9 SQL> alter diskgroup datagroup3 undrop disks; Diskgroup altered. SQL> SELECT A.NAME G_NAME, B.NAME D_NAME,B.OS_MB,B.TOTAL_MB,B.FREE_MB,B.STATE, FAILGROUP, B.FAILGROUP_TYPE, PATH 2 FROM V$ASM_DISKGROUP A, V$ASM_DISK B 3 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER 4 AND B.NAME LIKE 'DATAGROUP3%'; G_NAME D_NAME OS_MB TOTAL_MB FREE_MB STATE FAILGROUP FAILGRO PATH --------------- ------------------------- ---------- ---------- ---------- -------- ------------------------------ ------- ---------------------------------------- DATAGROUP3 DATAGROUP3_DISK10 1019 1019 1017 NORMAL FAILGROUP_3 QUORUM /dev/oracleasm/disks/ASMDISK10 DATAGROUP3 DATAGROUP3_DISK7 1019 1019 966 NORMAL FAILGROUP_1 REGULAR /dev/oracleasm/disks/ASMDISK7 DATAGROUP3 DATAGROUP3_DISK8 1019 1019 992 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK9 1019 1019 991 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9 SQL>
删除故障组中的所有磁盘:
注意:
A normal redundancy disk group must contain at least two failure groups. A high redundancy disk group must contain at least three failure groups.
eg:
SQL> SELECT A.NAME G_NAME, B.NAME D_NAME,B.OS_MB,B.TOTAL_MB,B.FREE_