Can we user database when Rebalance still running?
Hi All,
I had running Rebalance and this is the status
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA PASS STAT POWER ACTUAL SOFAR EST_WORK
------------ ----- --------- ---- ---------- ---------- ---------- ----------
EST_RATE EST_MINUTES ERROR_CODE CON_ID
---------- ----------- -------------------------------------------- ----------
1 REBAL COMPACT WAIT 1 0
1 REBAL REBALANCE WAIT 1 0
1 REBAL REBUILD WAIT 1 0
GROUP_NUMBER OPERA PASS STAT POWER ACTUAL SOFAR EST_WORK
----------- ----- --------- ---- ---------- ---------- ---------- ----------
EST_RATE EST_MINUTES ERROR_CODE CON_ID
---------- ----------- -------------------------------------------- ----------
1 REBAL RESYNC WAIT 1 0
and using this query the process still running
SQL> select INST_ID,OPERATION,STATE,POWER,SOFAR,EST_WORK,EST_RATE,EST_MINUTES from GV$ASM_OPERATION where GROUP_NUMBER=1;