ASM Balance Issues

1. The following operations are performed in ASM:

sql>  show parameter power;name          Type  value------------------------------------ ----------- ------------------------------ asm_power_limit        integer  1sql> alter  system set asm_power_limit=8; system altered. sql> show parameter power;name          type  value------------------------------------ ----------- ------------ ------------------asm_power_limit        integer  8sql>  select name,group_number from v$asm_diskgroup;NAME           group_number------------------------------ ------------data        2crs       1elapsed: 00:00:00.01 

Add disk before query V$asm_operation, is not logged:

Sql> Select inst_id, operation, state, POWER, Sofar, Est_work, Est_rate, est_minutes from Gv$asm_operation where Group_ Number=2;no rows selectedelapsed:00:00:00.04

To perform an operation to add a disk:

Sql> select inst_id, operation, state, power, sofar, est_work, est_ Rate, est_minutes from gv$asm_operation where group_number=2;   inst_ id opera stat    power      sofar    est_work  est_rate est_minutes---------- ----- ---- ---------- ------ ---- ---------- ---------- -----------  1 REBAL WAIT         8  1 REBAL WAIT         8  2 REBAL RUN        8  52    4407       266    16  2  rebal wait        8   0       0  0     0elapsed: 00:00:00.01 

See Oracle estimate 16 minutes to complete

To view a process:

[Email protected] ~]# Ps-fu Grid |        grep arbgrid 7130 1 0 13:19? 00:00:01 asm_arb0_+asm2

Also look at the alert log for ASM:

$ pwd/oracle/app/grid/diag/asm/+asm/+asm2/trace$ ls Alert*alert_+asm2.log

ASM Balance Issues