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


Komentáře