• 以sysasm登录oracle
 1 [grid@dntodu001 ~]$ sqlplus / as sysasm
 2
 3 SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 18 16:20:36 2019
 4
 5 Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 6
 7
 8 Connected to:
 9 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
10 With the Real Application Clusters and Automatic Storage Management options
  • 手动平衡data_dg
1 SQL> alter diskgroup data_dg  rebalance power 5;
2
3 Diskgroup altered.
  • 观察状态
1 SQL> select group_number,operation,state,power from v$asm_operation;
2
3 GROUP_NUMBER OPERA STAT      POWER
4 ------------ ----- ---- ----------
5            1 REBAL RUN           5
  • 手动暂停rebalance,并观察
1 SQL> alter diskgroup data_dg  rebalance power 0;
2
3 Diskgroup altered.
4
5 SQL> select group_number,operation,state,power from v$asm_operation;
6
7 GROUP_NUMBER OPERA STAT      POWER
8 ------------ ----- ---- ----------
9            1 REBAL WAIT          0
  • 继续rebalance
1 SQL> alter diskgroup data_dg  rebalance power 8;
2
3 Diskgroup altered.
4
5 SQL> select group_number,operation,state,power from v$asm_operation;
6
7 GROUP_NUMBER OPERA STAT      POWER
8 ------------ ----- ---- ----------
9            1 REBAL RUN           8
  • rebalance结束
1 SQL> select group_number,operation,state,power from v$asm_operation;
2
3 no rows selected
12-13 16:52