Asm实验

切换到ASM实例

[oracle@ghyyk ~]$ . oraenv

ORACLE_SID = [ghyyk] ? +ASM

The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/gridis /u01/app/oracle

查看查看磁盘

SYS@+ASM>select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS, TOTAL_MB,FREE_MB,NAME,PATH from v$asm_disk;

查看磁盘组的情况

SYS@+ASM> select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB,TOTAL_MB-FREE_MB USED_MB from v$asm_diskgroup;

删除磁盘组DATA的ASMDATA01磁盘

SYS@+ASM> alter diskgroup DATA drop disk 'ASMDATA01';

SYS@+ASM>select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,TOTAL_MB,FREE_MB,NAME,PATH from v$asm_disk;

删除磁盘组FLASH的ASMFLASH01磁盘

SYS@+ASM> alter diskgroup FLASH drop disk 'ASMFLASH01';

SYS@+ASM>select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,TOTAL_MB,FREE_MB,NAME,PATH from v$asm_disk;

给asm磁盘组添加磁盘

SYS@+ASM> alter diskgroup DATA add disk 'ORCL:ASMDATA01' name test01;

            ---给DATA磁盘组添加一块磁盘，磁盘名为test01

SYS@+ASM> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,TOTAL_MB,FREE_MB,NAME,PATH from v$asm_disk;

这里注意，从磁盘组删除磁盘是使用的是磁盘名称，即v$asm_disk视图中的name字段

从磁盘组中添加磁盘时，由于name字段为空，只能添加路径，即v$asm_disk视图中的path字段

--ASM磁盘对应物理路径

[oracle@ghyyk ~]$ /etc/init.d/oracleasm querydisk -d ASMFLASH01

Disk "ASMFLASH01" is a valid ASM disk on device /dev/sdf1[8,81]