oracleasm磁盘管理基础篇（一） - 数据库编程

roup3 resize disks in failgroup failgroup_2; Diskgroup altered. SQL> SELECT A.NAME G_NAME, B.NAME D_NAME,B.OS_MB,B.TOTAL_MB,B.FREE_MB,B.STATE, FAILGROUP, B.FAILGROUP_TYPE, PATH 2 FROM V$ASM_DISKGROUP A, V$ASM_DISK B 3 WHERE A.GROUP_NUMBER = B.GROUP_NUMBER 4 AND B.NAME LIKE 'DATAGROUP3%'; G_NAME D_NAME OS_MB TOTAL_MB FREE_MB STATE FAILGROUP FAILGRO PATH --------------- ------------------------- ---------- ---------- ---------- -------- ------------------------------ ------- ---------------------------------------- DATAGROUP3 DATAGROUP3_DISK10 1019 1019 966 NORMAL FAILGROUP_3 REGULAR /dev/oracleasm/disks/ASMDISK10 DATAGROUP3 DATAGROUP3_DISK7 1019 1019 966 NORMAL FAILGROUP_1 REGULAR /dev/oracleasm/disks/ASMDISK7 DATAGROUP3 DATAGROUP3_DISK8 1019 1019 990 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK9 1019 1019 993 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9 SQL>

注意：oracle建议故障组大小最好保证一致提高更好的性能实用。

（七）手动平衡数据

可以通过手动执行alter diskgroup rebalance 进行数据的平衡，如果默认情况下不指定power，那么将采用asm_power_limit参数值，如果手动将忽略参数文件中的该参数

如下：

SQL> show parameter asm_power_limit;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_power_limit                      integer     2
SQL> alter diskgroup datagroup3 rebalance;

Diskgroup altered.

SQL> select b.group_number group_number,
  2         a.name         name,
  3         b.operation    operation,
  4         b.state        state,
  5         b.power        power,
  6         b.actual       actual,
  7         b.sofar        sofar,
  8         b.est_work     ext_work,
  9         b.est_rate     est_rate,
 10         b.est_minutes  est_minutes
 11    from v$asm_diskgroup a, v$asm_operation b
 where a.group_number = b.group_number
 12   13     and a.name like 'DATAGROUP3%';

GROUP_NUMBER NAME                      OPERA STAT      POWER     ACTUAL      SOFAR   EXT_WORK   EST_RATE EST_MINUTES
------------ ------------------------- ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
           2 DATAGROUP3                REBAL REAP          2          2          0          0          0           0

SQL> 
SQL> alter diskgroup datagroup3 rebalance power 10;

Diskgroup altered.

SQL> select b.group_number group_number,
  2         a.name         name,
  3         b.operation    operation,
  4         b.state        state,
  5         b.power        power,
  6         b.actual       actual,
  7         b.sofar        sofar,
  8         b.est_work     ext_work,
  9         b.est_rate     est_rate,
 10         b.est_minutes  est_minutes
 11    from v$asm_diskgroup a, v$asm_operation b
 12   where a.group_number = b.group_number
 13     and a.name like 'DATAGROUP3%';

GROUP_NUMBER NAME                      OPERA STAT      POWER     ACTUAL      SOFAR   EXT_WORK   EST_RATE EST_MINUTES
------------ ------------------------- ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
           2 DATAGROUP3                REBAL REAP         10         10          0          0          0           0

SQL>

That's all !

oracleasm磁盘管理基础篇（一）(十)