暂无图片
oracle asm删磁盘后磁盘状态仍未member,存在ORA-15041报错
最近更新:2023-01-11 08:46:39

操作系统及版本

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
......