操作系统及版本
AIX
数据库类型及版本
oracle 11.2.0.4
数据库架构
RAC
问题详情
asm在踢盘时,磁盘状态一直为member,删盘不成功
复现步骤
1.删除一块asm磁盘
alter diskgroup ARCHDG drop disk ARCHDG_0000 rebalance power 8;
2.查看asm状态,state一直显示DROPPING,header_statu仍为member,表名改磁盘还在磁盘组里,没有被成功踢出。
SQL> select name,header_status,STATE,path,os_mb,failgroup from v$asm_disk order by 1;
NAME HEADER_STATU STATE PATH OS_MB FAILGROUP
------------------------------ ------------ -------- ------------------------------ ---------- ------------------------------
ARCHDG_0000 MEMBER DROPPING /dev/rhdiskpower12 10240 ARCHDG_0001
......