oracleasm磁盘管理基础篇(一)(二)

2014-11-24 11:26:23 · 作者: · 浏览: 4
iskgroup datagroup3 normal redundancy 2 disk '/dev/oracleasm/disks/ASMDISK7' NAME DATAGROUP3_DISK7, 3 4 '/dev/oracleasm/disks/ASMDISK8' NAME DATAGROUP3_DISK8, 5 '/dev/oracleasm/disks/ASMDISK9' NAME DATAGROUP3_DISK9, 6 '/dev/oracleasm/disks/ASMDISK10' NAME DATAGROUP3_DISK10 7 ATTRIBUTE 'au_size'='1M', 8 'compatible.rdbms'='11.2', 9 'compatible.asm'='11.2', 10 '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 980 NORMAL DATAGROUP3_DISK10 REGULAR /dev/oracleasm/disks/ASMDISK10 DATAGROUP3 DATAGROUP3_DISK7 1019 1019 977 NORMAL DATAGROUP3_DISK7 REGULAR /dev/oracleasm/disks/ASMDISK7 DATAGROUP3 DATAGROUP3_DISK8 1019 1019 980 NORMAL DATAGROUP3_DISK8 REGULAR /dev/oracleasm/disks/ASMDISK8 DATAGROUP3 DATAGROUP3_DISK9 1019 1019 978 NORMAL DATAGROUP3_DISK9 REGULAR /dev/oracleasm/disks/ASMDISK9 SQL>

指定故障组创建磁盘组:

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