Delete the disk, and note that if the disk is deleted, the data will be stored on the remaining disk with sufficient space. If there is not enough space, deleting the work will not succeed. Check the space enough: select A.group_number,a.disk_number,a.name, Decode (sign (A.FREE_MB-D.COLD_USED_MB/2), 1, ' Y ',-1, ' n ', ' n ') From V$asm_diskgroup d,v$asm_disk a where a.group_number = D.group_number and a.group_number = 2; --Write your own statement, if you have questions, please tell me, thank you 1. Check disk group_number group_name NAME PATH State TOTAL_MB----- ---------------------------------------------------------------------------0 DATA DATA2 /DEV/RAW/RAW6 normal 8192 5 FRA fra/dev/raw/raw5 Normal 8192 0 DATA data/dev/raw/raw4 NORMAL 8192 0 CRS crs_000 2/DEV/RAW/RAW3 NORMAL 3072 0 CRS crs_0001/dev/raw/raw2 NO Rmal 3072 0 CRS crs_0000/dev/raw/raw1 NORMAL 30722. Delete sql> alter di skgRoup 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 fra/dev/raw/raw5 NORMAL 8192 0 DATA DA Ta/dev/raw/raw4 NORMAL 8192 0 CRS crs_0002/dev/raw/raw3 Normal 3072 0 CRS crs_0001/dev/raw/raw2 normal 3072 0 CR S crs_0000/dev/raw/raw1 NORMAL 30723. Wait a minute. Group_number group_name NAME P ATH State total_mb------------------------------------------------------------------------------ --5 FRA fra/dev/raw/raw5 NORMAL 8192 0 DATA data/dev/raw/raw4 NORMAL 8192 0 CRS Crs_0002/dev/ra W/RAW3 normal 3072 0 CRS crs_0001/dev/raw/raw2 Normal 3072 0 CRS crs_0000/dev/raw/raw1 NORMAL 3072 Note: If in dropping state, suddenly regret, then alter DiskGroup Data undrop disks; if it's done, add it.
Remove one of the disks for the data disk group (there are two disks in the ASM external data set)