How To Change The Asm Rebalancing Power After Starting The Rebalancing Process

 

       The rebalance power defaults to the value of the ASM_POWER_LIMIT initialization parameter (default = 1).

       The higher the limit, the faster a rebalance operation may complete. Lower values cause rebalancing to take longer, but consume fewer processing and I/O resources.       This leaves these resources available for other applications, such as the database.

The POWER value can be from 0 to 11 where 0 stops rebalancing and 11 is the fastest.

It is possible to adjust this parameter dynamically, however adjusting ASM_POWER_LIMIT only affects future rebalances. It does not affect an in progress rebalance.

To change the power of an in progress rebalance, a new rebalance command should be issued with the POWER clause.

ALTER DISKGROUP <disk group name> REBALANCE [POWER n];

The asm_power_limit can be found in the v$asm_operation view.

Test Case:
       Altering a diskgroup (add, drop, undrop, resize) will trigger an automatic rebalance operation according to ASM_POWER_LIMIT initialization parameter if no POWER clause specified in the alter command. If the optional POWER clause is specified, ASM will rebalance the diskgroup using the integer value to override the value that the ASM_POWER_LIMIT initialization parameter.

 

SQL> show parameter limit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------
asm_power_limit                      integer     1

 

SQL> alter diskgroup dg1 add disk
  2  '//./ORCLDISKD10',
  3  '//./ORCLDISKD20',
  4  '//./ORCLDISKD30';

Diskgroup altered.

One rebalance process started (ARB0)

 

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
           1 REBAL WAIT          1          0          0          0     

ASM alert.log

Fri Dec 26 16:55:08 2008
NOTE: starting rebalance of group 1/0x8c6014a7 (DG1) at power 1
Starting background process ARB0
ARB0 started with pid=14, OS id=316
Fri Dec 26 16:55:08 2008
NOTE: assigning ARB0 to group 1/0x8c6014a7 (DG1)

 

After running a rebalance command, the running rebalance process will be stopped and new  rebalance slave processes will spawned depending on POWER used

 

SQL> alter diskgroup dg1 rebalance power 8;
Diskgroup altered.

 

 

8 rebalance slave processes  spawned (ARB0,....,ARB7)

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
           1 REBAL RUN           8          8          0        407          0

ASM alert.log

Fri Dec 26 16:55:11 2008
SQL> alter diskgroup dg1 rebalance power 8 

NOTE: stopping process ARB0
Fri Dec 26 16:55:11 2008
NOTE: rebalance interrupted for group 1/0x8c6014a7 (DG1)
Fri Dec 26 16:55:11 2008
NOTE: PST update: grp = 1
NOTE: requesting all-instance PST refresh for group=1
Fri Dec 26 16:55:11 2008
NOTE: PST refresh pending for group 1/0x8c6014a7 (DG1)
SUCCESS: refreshed PST for 1/0x8c6014a7 (DG1)
Fri Dec 26 16:55:14 2008
NOTE: starting rebalance of group 1/0x8c6014a7 (DG1) at power 8
Starting background process ARB0
Starting background process ARB1
ARB0 started with pid=14, OS id=1628
Fri Dec 26 16:55:15 2008
Starting background process ARB2
ARB1 started with pid=15, OS id=1920
Fri Dec 26 16:55:15 2008
Starting background process ARB3
ARB2 started with pid=16, OS id=1964
Fri Dec 26 16:55:15 2008
Starting background process ARB4
ARB3 started with pid=17, OS id=1664
Fri Dec 26 16:55:15 2008
Starting background process ARB5
ARB4 started with pid=18, OS id=1836
Fri Dec 26 16:55:15 2008
Starting background process ARB6
ARB5 started with pid=19, OS id=1972
Fri Dec 26 16:55:15 2008
Starting background process ARB7
ARB6 started with pid=20, OS id=1800 

 

 

 

 

 

 

From Oracle

-------------------------------------------------------------------------------------------------------

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

DBA1 群：62697716(满);   DBA2 群：62697977(满)   DBA3 群：62697850(满)  

DBA 超级群：63306533(满);  DBA4 群： 83829929  DBA5群： 142216823   

聊天 群：40132017   聊天2群：69087192

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请