指定故障组创建磁盘组:
eg:
SQL> create diskgroup datagroup3 normal redundancy 2 failgroup failgroup_1 disk 3 '/dev/oracleasm/disks/ASMDISK7' NAME DATAGROUP3_DISK7 4 failgroup failgroup_2 disk 5 '/dev/oracleasm/disks/ASMDISK8' NAME DATAGROUP3_DISK8, 6 '/dev/oracleasm/disks/ASMDISK9' NAME DATAGROUP3_DISK9 7 failgroup failgroup_3 disk '/dev/oracleasm/disks/ASMDISK10' NAME DATAGROUP3_DISK10 8 9 ATTRIBUTE 'au_size'='1M', 'compatible.rdbms'='11.2', 10 11 'compatible.asm'='11.2', 12 'sector_size'='512'; Diskgroup created. 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 993 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK9 1019 1019 990 NORMAL FAILGROUP_2 REGULAR /dev/oracleasm/disks/ASMDISK9 SQL>
A quorum failure group is not considered when determining redundancy requirements in respect to storing user data. However, a quorum failure group counts when mounting a disk group.
注意故障磁盘组有两种一种是quorum一种是regular,不同之处是quorum不包含用户数据。
如创建quorum故障组的磁盘组:
eg:
SQL> drop diskgroup datagroup3 including contents; Diskgroup dropped. SQL> create diskgroup datagroup3 normal redundancy 2 failgroup failgroup_1 disk 3 '/dev/oracleasm/disks/ASMDISK7' NAME DATAGROUP3_DISK7 4 failgroup failgroup_2 disk 5 '/dev/oracleasm/disks/ASMDISK