Drop ASM disk
SQL> alter diskgroup DATA2 drop disk RAC_DATA_04_M2;
Diskgroup altered.
Rebalancing
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA State POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ------------ ----- ----------- ---------- ---------- ---------- ---------- ---------- ----------- ERROR_CODE -------------------------------------------- 1 REBAL RUN 1 1 34868 783797 8277 90
/
GROUP_NUMBER OPERA State POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ------------ ----- ----------- ---------- ---------- ---------- ---------- ---------- ----------- ERROR_CODE -------------------------------------------- 1 REBAL RUN 1 1 51922 740392 8597 80
Nastavení power
SQL> alter diskgroup DATA2 rebalance power 6;
SQL> set linesize 140 SQL> column DG_NAME format 99 SQL> column PATH format a25 SQL> column DISK_SIZE_MB format 9999999999 SQL> column state format a25 SQL> SQL> SELECT g.name DG_NAME, d.path PATH, d.total_mb DISK_SIZE_MB, d.state 2 FROM v$asm_disk d, v$asm_diskgroup g 3 WHERE g.group_number=d.group_number 4 AND g.name='DATA2';
DG_NAME PATH DISK_SIZE_MB STATE ------------------------------ ------------------------- ------------ ------------------------- DATA2 ORCL:RAC_DATA_01_M2 204800 NORMAL DATA2 ORCL:RAC_DATA_02_M2 204800 NORMAL DATA2 ORCL:RAC_DATA_03_M2 204800 NORMAL DATA2 ORCL:RAC_DATA_04_M2 204800 DROPPING DATA2 ORCL:RAC_DATA_05_M2 204800 NORMAL DATA2 ORCL:RAC_DATA_06_M2 204800 NORMAL DATA2 ORCL:RAC_DATA_D1 2097152 NORMAL DATA2 ORCL:RAC_DATA_D1_M2 2097152 NORMAL DATA2 ORCL:RAC_DATA_D2 2097152 NORMAL DATA2 ORCL:RAC_DATA_D2_M2 2097152 NORMAL