SQL> alter diskgroup DGA drop disk '/dev/raw/raw7';
alter diskgroup DGA drop disk '/dev/raw/raw7'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/RAW/RAW7" does not exist in diskgroup "DGA"

--删除disk失败
SQL> select name,path from v$asm_disk where name is not null;

NAME       PATH
---------- ------------------------------
DGA_0000   ORCL:VOL3
DGA_0001   /dev/raw/raw7
SQL> alter diskgroup DGA drop disk 'DGA_0001';

Diskgroup altered.
--这里说明了 disk 参数指向的是v$asm_disk的name
SQL> select name,path from v$asm_disk;

NAME       PATH
---------- ------------------------------
           /dev/raw/raw2
           /dev/raw/raw1
           ORCL:VOL4
DGA_0000   ORCL:VOL3
DGA_0001   /dev/raw/raw7
--怎么还在？？重均衡rebalance总是要点时间的。
有些已经是ocr votedisk所用怎么还在？？
说明 asm instance 启动时会在参数asm_diskstring指定的路径下查找所有设备
如果未设置则会扫描所有可用的设备
SQL> select name,path from v$asm_disk
2 ;

NAME       PATH
---------- ------------------------------
           /dev/raw/raw2
           /dev/raw/raw1
           ORCL:VOL4
DGA_0000   ORCL:VOL3
DGA_0001   /dev/raw/raw7

SQL> alter diskgroup DGA drop disk 'DGA_0001';
alter diskgroup DGA drop disk 'DGA_0001'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "DGA_0001" does not exist in diskgroup "DGA"

SQL> select name,path from v$asm_disk;

NAME       PATH
---------- ------------------------------
           /dev/raw/raw2
           /dev/raw/raw1
           /dev/raw/raw7
           ORCL:VOL4
DGA_0000   ORCL:VOL3

ITPub博客

asm add drop体验

最新文章