Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center