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

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> SQL> SQL> SQL> alter diskgroup datagroup3 resize all size 512M; 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 512 475 NORMAL FAILGROUP_4 REGULAR /dev/oracleasm/disks/ASMDISK10 DATAGROUP3 DATAGROUP3_0001 1019 512 470 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK9 1019 512 471 NORMAL DATAGROUP3_DISK9 REGULAR /dev/oracleasm/disks/ASMDISK9 DATAGROUP3 DATAGROUP3_DISK7 1019 512 471 NORMAL FAILGROUP_1 REGULAR /dev/oracleasm/disks/ASMDISK7

2、重置磁盘组中指定磁盘的大小

SQL> alter diskgroup datagroup3 resize disk datagroup3_0003 size 1019M;

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
   AND B.NAME LIKE 'DATAGROUP3%';  4  

G_NAME          D_NAME                         OS_MB   TOTAL_MB    FREE_MB STATE    FAILGROUP                      FAILGRO PATH
--------------- ------------------------- ---------- ---------- ---------- -------- ------------------------------ ------- ----------------------------------------
DATAGROUP3      DATAGROUP3_0003                 1019       1019        979 NORMAL   FAILGROUP_4                    REGULAR /dev/oracleasm/disks/ASMDISK10
DATAGROUP3      DATAGROUP3_0001                 1019        512        470 NORMAL   FAILGROUP_2                    REGULAR /dev/oracleasm/disks/ASMDISK8
DATAGROUP3      DATAGROUP3_DISK9                1019        512        472 NORMAL   DATAGROUP3_DISK9               REGULAR /dev/oracleasm/disks/ASMDISK9
DATAGROUP3      DATAGROUP3_DISK7                1019        512        473 NORMAL   FAILGROUP_1                    REGULAR /dev/oracleasm/disks/ASMDISK7

3、重置磁盘组中指定故障组中所有磁盘的大小。

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
   AND B.NAME LIKE 'DATAGROUP3%';  4  

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_

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