- 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