oracle 删除asm Oracle ASM磁盘组的卸载与删除

**创建磁盘组：**

使用Oracle用户连接

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL>create diskgroup arch external redundancy disk /dev/asm-disk5 ;


Oracle通过ASM实例管理磁盘组，要使用Gird用户连接ASM实例进行创建

[grid@rac1 ~]$ sqlplus / as sysasm

SQL> create diskgroup arch external redundancy disk /dev/asm-disk5 ;

Diskgroup created.

SQL> select name,state from v$asm_diskgroup;

NAME STATE

DATA MOUNTED

OCR MOUNTED

ARCH MOUNTED

**卸载磁盘组：**

SQL> alter diskgroup arch dismount;

Diskgroup altered.

尝试卸载DATA：

SQL> alter diskgroup data dismount;

alter diskgroup data dismount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15027: active use of diskgroup "