ORACLE ASM磁盘组部分管理

查看asm磁盘在操作系统路径

sqlplus / as sysasm
show parameter asm_diskstring
SQL> show parameter asm_diskstring

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring                       string      /dev/*

磁盘在/dev 目录路径
进入查看磁盘信息：
cd /dev
[root@rac1 dev]# ls |grep asm-disk
asm-diskb
asm-diskc
asm-diskd
asm-diske
asm-diskf
asm-diskg

使用asm-diske和asm-diskf创建normal模式冗余磁盘组

--NORMAL模式磁盘组创建 
CREATE DISKGROUP DATADG NORMAL REDUNDANCY
  FAILGROUP FG1 DISK
    '/dev/asm-diske' 
  FAILGROUP FG2 DISK
    '/dev/asm-diskf' 
  ATTRIBUTE 'au_size'='1M',
    'compatible.asm' = '11.2', 
    'compatible.rdbms' = '11.2',
    'compatible.advm' = '11.2';

normal模式有两个failgroup，数据通过2-way mirror方式，分别存放到两个failgroup中各一份。上述failgroup分别取名库FG1和FG2
au_size: disk group数据存储和分配的最小单元
compatible.asm：Determines the minimum software version for any Oracle ASM instance that uses a disk group。–使用此磁盘组的最小兼容性软件版本
compatible.rdbms : rdbms实例所支持的最小compatible version
compatible.advm: Determines whether the disk group can contain Oracle ASM volumes

查看磁盘组状态

SQL> set linesize 120     
SQL> set pagesize 120
SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
SYSVG                          MOUNTED
DATADG                         MOUNTED

mount和dismount磁盘组
Disk groups that are specified in the ASM_DISKGROUPS initialization parameter are mounted automatically at Oracle ASM instance startup。在asm实例启动时，自动到mount状态

alter diskgroup datadg dismount
SQL> select name,state from v$asm_diskgroup
NAME                 STATE
-------------------- -----------
SYSVG                MOUNTED
DATADG               DISMOUNTED
--mount磁盘组
alter diskgroup datadg mount
SQL>  select name,state from v$asm_diskgroup;
NAME                 STATE
-------------------- -----------
SYSVG                MOUNTED
DATADG               MOUNTED

drop掉磁盘组

drop diskgroup datadg force