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