Time taken by rebalance process of ASM in Oracle

File extents relocation in Oracle

In ASM, I remove a disk using the default rebalance power and then check GV$ASM_OPERATION for the estimated completion time (EST_MINUTES):

1. Check the ASM power limit parameter in the database.

SQL> show parameter power
NAME            TYPE    VALUE
--------------- ------- ----------------
asm_power_limit integer 1

2. Drop the disk from the disk group as below.

alter diskgroup DATA1 drop disk DATA1_01;
Diskgroup altered.

3. Check the time taken by the ASM rebalance operation(estimated time to complete is 26 minutes) :

select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION where GROUP_NUMBER=1;

INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES
------- ----- ---- ----- ----- -------- -------- -----------
3       REBAL WAIT  1
2       REBAL RUN   1    516   53736       2012  26
4       REBAL WAIT  1