2.查看当前的状态
SQL> select group_number, name, total_mb, free_mb, total_mb-free_mb used_mb from v$asm_disk_stat;
GROUP_NUMBER NAME TOTAL_MB FREE_MB USED_MB
------------ ------------------------------ ---------- ---------- ----------
0 1019 0 1019
0 101 0 101
0 101 0 101
1 DATA_0001 1019 565 454
1 DATA_0000 3067 2129 938
SQL> select name, total_mb, free_mb from v$asm_disk_stat;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
1019 0
101 0
101 0
DATA_0001 1019 565
DATA_0000 3067 2129
SQL> select * from v$asm_operation;
no rows selected
3.开始删除磁盘DATA_0001
SQL> alter diskgroup data drop disk DATA_0001;
Diskgroup altered.
4.磁盘做rebalance操作
SQL> set linesize 200;
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
1 REBAL RUN 1 1 167 456 414 0
SQL> select name, total_mb, free_mb from v$asm_disk_stat;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
1019 0
101 0
101 0
DATA_0001 1019 732
DATA_0000 3067 1962
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
1 REBAL RUN 1 1 381 454 411 0
5.继续等待磁盘已经删除
SQL> select * from v$asm_operation;
no rows selected
SQL> select * from v$asm_operation;
no rows selected
SQL> select name, total_mb, free_mb from v$asm_disk_stat;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
1019 0
101 0
101 0
DATA_0000 3067 1677
SQL> select path,group_number, disk_number,mount_status,header_status,mode_status,state from v$asm_disk;
PATH GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE
---------------------------------------- ------------ ----------- ------- ------------ ------- --------
/dev/raw/raw5 0 0 CLOSED FORMER ONLINE NORMAL
/dev/raw/raw3 0