oracleasm磁盘管理基础篇（一）(五)
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 994 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8
DATAGROUP3 DATAGROUP3_DISK9 1019 1019 989 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9
SQL> alter diskgroup datagroup3 drop 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 1003 DROPPING FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8
DATAGROUP3 DATAGROUP3_DISK9 1019 1019 999 DROPPING FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9
SQL>
r
1 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 1017 DROPPING FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8
DATAGROUP3 DATAGROUP3_DISK9 1019 1019 1017 DROPPING FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9
SQL> r
1 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_DISK8 0 1019 966 DROPPING FAILGROUP_2 REGULAR
DATAGROUP3 DATAGROUP3_DISK7 1019 1019 966 NORMAL FAILGROUP_1 REGULAR /dev/oracleasm/