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

8' NAME DATAGROUP3_DISK8, 6 '/dev/oracleasm/disks/ASMDISK9' NAME DATAGROUP3_DISK9 quorum failgroup failgroup_3 disk 7 8 '/dev/oracleasm/disks/ASMDISK10' NAME DATAGROUP3_DISK10 9 ATTRIBUTE 'au_size'='1M', 10 'compatible.rdbms'='11.2', 11 'compatible.asm'='11.2', 12 'sector_size'='512'; Diskgroup created. SQL> SQL> 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 1017 NORMAL FAILGROUP_3 QUORUM /dev/oracleasm/disks/ASMDISK10 DATAGROUP3 DATAGROUP3_DISK7 1019 1019 966 NORMAL FAILGROUP_1 REGULAR /dev/oracleasm/disks/ASMDISK7 DATAGROUP3 DATAGROUP3_DISK8 1019 1019 992 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK9 1019 1019 991 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9 SQL>

（四）删除磁盘组

对于磁盘组使用alter diskgroup命令进行相应维护，但在磁盘组中无论是删除磁盘、添加磁盘还是重置磁盘大小，那么都是在线的不影响正常使用。在每次磁盘组信息进行改变的时候oracle都会自动的rebalance磁盘组中的数据，当我们执行alter diskgroup 之后的sql命令执行提示，并不是在完成rebalance数据之后才返回的。而是数据的rebalance是在后台进行的，如果要等到平衡数据完成后才告知命令执行情况，可以考虑添加rebalance wait参数。另外要注意，当我们使用alter diskgoup命令的时候突然按ctrl+c，那么oracle是不会取消磁盘的删除、添加、重定义大小和平衡操作。而是在后台执行。

删除磁盘组中的磁盘：

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_DISK10               1019       1019       1017 NORMAL   FAILGROUP_3                    QUORUM  /dev/oracleasm/disks/ASMDISK10
DATAGROUP3      DATAGROUP3_DISK7                1019       1019        966 NORMAL   FAILGROUP_1                    REGULAR /dev/oracleasm/disks/ASMDISK7
DATAGROUP3      DATAGROUP3_DISK8                1019       1019        992 NORMAL   FAILGROUP_2                    REGULAR /dev/oracleasm/disks/ASMDISK8
DATAGROUP3      DATAGROUP3_DISK9                1019       1019        991 NORMAL   FAILGROUP_2                    REGULAR /dev/oracleasm/disks/ASMDISK9

SQL> alter diskgroup datagroup3 drop disk DATAGROUP3_DISK10;
SQL> alter diskgroup datagroup3 drop disk datagroup3_disk7;

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       1017 NORMAL   FAILGROUP_3                    QUORUM  /dev/oracleasm/disks/ASMDISK10
DATAGROUP3      DATAGROUP3_DISK7                1019       1019        966 DROPPING FAILGROUP_1                    REGULAR /dev/oracleasm/disks/ASMDI

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