Delete a disk from the data disk group (two disks exist in the asmexternaldata disk group)

Delete a disk from the data disk group (two disks exist in the asmexternaldata disk group)

Delete a disk. Note: if data is stored on the remaining disk after the disk is deleted, check whether there is sufficient storage space. If there is not enough space, the deletion will not succeed. Check space is insufficient: select. GROUP_NUMBER,. DISK_NUMBER,. NAME, decode (sign (. FREE_MB-d.COLD_USED_MB/2), 1, 'y',-1, 'n', 'n') from v $ asm_diskgroup d, v $ asm_disk a where. GROUP_NUMBER = d. GROUP_NUMBER and. GROUP_NUMBER = 2; -- a self-written statement. If any problem occurs, please let me know. Thank you. 1. check disk GROUP_NUMBER GROUP_NAME name path state TOTAL_MB ------------ ---------- ---------------------- ---------------- -------- ------------ 0 DATA DATA2/dev/raw/r Aw6 NORMAL 8192 5 FRA/dev/raw/raw5 NORMAL 8192 0 DATA/dev/raw/raw4 NORMAL 8192 0 CRS CRS_0002/dev/raw/raw3 NORMAL 3072 0 CRS CRS_0001/ dev/raw/raw2 NORMAL 3072 0 CRS CRS_0000/dev/raw/raw1 NORMAL 30722. delete SQL> alter diskgroup data drop disk data2; Diskgroup altered. GROUP_NUMBER GROUP_NAME name path state TOTAL_MB ----------------------------------------------------------------------- --------- 0 DATA DATA2/dev/raw/raw6 DROPPING 8192 5 FRA/dev/raw/raw5 NORMAL 8192 0 DATA/dev/raw/raw4 NORMAL 8192 0 CRS CRS_0002/dev/ raw/raw3 NORMAL 3072 0 CRS CRS_0001/dev/raw/raw2 NORMAL 3072 0 CRS CRS_0000/dev/raw/raw1 NORMAL 30723. wait for a while. GROUP_NUMBER GROUP_NAME name path state TOTAL_MB ------------ ---------- -------------------- ---------------- -------- ------------ 5 FRA/de V/raw/raw5 NORMAL 8192 0 DATA/dev/raw/raw4 NORMAL 8192 0 CRS CRS_0002/dev/raw/raw3 NORMAL 3072 0 CRS CRS_0001/dev/raw/raw2 NORMAL 3072 0 CRS CRS_0000/dev/raw/raw1 NORMAL 3072 note: if you suddenly regret it in the dropping status, then alter diskgroup data undrop disks; if you have deleted it, add it.