ASM : Cancel a DROP Disk operation

  • The UNDROP DISKS clause of the ALTER DISKGROUP statement enables you to cancel all pending drops of disks within disk groups.
  • If a drop disk operation has completed, then this statement cannot be used to restore it
SQL>  ALTER DISKGROUP DATA  DROP DISK DATA_0002;
Diskgroup altered.

DG_NAME    DG_STATE   TYPE   NAME     DSK_NO MOUNT_S HEADER_STATU MODE_ST STATE    PATH                 FAILGROUP
---------- ---------- ------ ---------- ------- ------- ------------ ------- -------- ------------------------------ ---------------
DATA       MOUNTED    NORMAL DATA_0000          0 CACHED    MEMBER         ONLINE  NORMAL   /dev/asmdisk1_udev_sdb1         DATA_0000
DATA       MOUNTED    NORMAL DATA_0001          1 CACHED    MEMBER         ONLINE  NORMAL   /dev/asmdisk1_udev_sdc1         DATA_0001
DATA       MOUNTED    NORMAL DATA_0002          2 CACHED    MEMBER         ONLINE  DROPPING /dev/asm_data_10G_disk2         DATA_0002
DATA       MOUNTED    NORMAL DATA_0003          3 CACHED    MEMBER         ONLINE  NORMAL   /dev/asm_data_10G_disk3         DATA_0003

DISK_GRP               GROUP_NUMBER OPERA EST_MINUTES
------------------------------ ------------ ----- -----------
DATA                      1 REBAL       14

SQL> ALTER DISKGROUP data UNDROP DISKS;
Diskgroup altered.

G_NAME    DG_STATE   TYPE   NAME     DSK_NO MOUNT_S HEADER_STATU MODE_ST STATE    PATH                 FAILGROUP
---------- ---------- ------ ---------- ------- ------- ------------ ------- -------- ------------------------------ ---------------
DATA       MOUNTED    NORMAL DATA_0000          0 CACHED    MEMBER         ONLINE  NORMAL   /dev/asmdisk1_udev_sdb1         DATA_0000
DATA       MOUNTED    NORMAL DATA_0001          1 CACHED    MEMBER         ONLINE  NORMAL   /dev/asmdisk1_udev_sdc1         DATA_0001
DATA       MOUNTED    NORMAL DATA_0002          2 CACHED    MEMBER         ONLINE  NORMAL   /dev/asm_data_10G_disk2         DATA_0002
DATA       MOUNTED    NORMAL DATA_0003          3 CACHED    MEMBER         ONLINE  NORMAL   /dev/asm_data_10G_disk3         DATA_0003

DISK_GRP               GROUP_NUMBER OPERA EST_MINUTES
------------------------------ ------------ ----- -----------
DATA                      1 REBAL        4
--> disk DATA_0002  switched from  DROPPING to NORMAL 
    It will take 4 minutes until the UNDROP operation will be finished

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>