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

EE_MB STATE FAILGROUP FAILGRO PATH --------------- ------------------------- ---------- ---------- ---------- -------- ------------------------------ ------- ---------------------------------------- DATAGROUP3 DATAGROUP3_0001 1019 1019 966 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK7 1019 1019 966 NORMAL FAILGROUP_1 REGULAR /dev/oracleasm/disks/ASMDISK7 SQL> alter diskgroup datagroup3 add disk '/dev/oracleasm/disks/ASMDISK9' NAME datagroup3_disk9 ; Diskgroup altered. SQL> select b.group_number group_number, a.name name, 2 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 RUN 2 2 2 69 265 0 SQL>

可以看到，目前添加磁盘组的状态为rebalance，正在运行run，当时平衡力度为2，正常使用的为2，目前平衡了2个au，需要69个au进行rebalance，每分钟可以完成265个au的平衡。

添加故障组：

eg：

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_DISK7                1019       1019        966 NORMAL   FAILGROUP_1                    REGULAR /dev/oracleasm/disks/ASMDISK7
DATAGROUP3      DATAGROUP3_0001                 1019       1019        966 NORMAL   FAILGROUP_2                    REGULAR /dev/oracleasm/disks/ASMDISK8
DATAGROUP3      DATAGROUP3_DISK9                1019       1019        966 NORMAL   DATAGROUP3_DISK9               REGULAR /dev/oracleasm/disks/ASMDISK9


SQL> ALTER DISKGROUP DATAGROUP3 ADD FAILGROUP FAILGROUP_4 DISK '/dev/oracleasm/disks/ASMDISK10';

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_0003                 1019       1019        982 NORMAL   FAILGROUP_4                    REGULAR /dev/oracleasm/disks/ASMDISK10
DATAGROUP3      DATAGROUP3_0001                 1019       1019        977 NORMAL   FAILGROUP_2                    REGULAR /dev/oracleasm/disks/ASMDISK8
DATAGROUP3      DATAGROUP3_DISK9                1019       1019        978 NORMAL   DATAGROUP3_DISK9               REGULAR /dev/oracleasm/disks/ASMDISK9
DATAGROUP3      DATAGROUP3_DISK7                1019       1019        978 NORMAL   FAILGROUP_1                    REGULAR /dev/oracleasm/disks/ASMDISK7

SQL>

(六）重置大小。

磁盘组的resize有如下情况

1、重置整个磁盘组所有磁盘的大小

eg：

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.

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