事件描述:rac10g,磁盘组2个failgroup,磁盘组大小为60g,人工添加个50g的盘到磁盘组里面后,删除这个磁盘删除不了这个是添加后的大小
ASMCMD> ls -s
SectorBlock AUTotal_MBFree_MBReq_mir_free_MBUsable_file_MBOffline_disksName
512 40961048576 3070829690
0 29690
0DATABK/
512 40961048576119317 117046
49999 33523
3NEWDG_DATA/
添加磁盘命令:alter diskgroup newdg_data add disk '/dev/raw/raw18/' name A18;
添加后的磁盘的状态
SQL> select MOUNT_STATUS,MODE_STATUS,HEADER_STATUS,STATE,NAME,PATH from v$asm_disk;
MOUNT_S MODE_ST HEADER_STATU STATENAME
PATH
------- ------- ------------ -------- --------------- ---------------
MISSING OFFLINE CANDIDATEHUNG NEWDG_DATA_0005
MISSING OFFLINE CANDIDATEHUNG NEWDG_DATA_0004
MISSING OFFLINE CANDIDATEHUNG NEWDG_DATA_0003
CACHEDONLINEMEMBER NORMAL NEWDG_DATA_0002 /dev/raw/raw11
CACHEDONLINEMEMBER NORMAL NEWDG_DATA_0001 /dev/raw/raw10
CACHEDONLINEMEMBER NORMAL NEWDG_DATA_0000 /dev/raw/raw9
CACHEDONLINEMEMBER NORMAL DATABK_0002 /dev/raw/raw5
CACHEDONLINEMEMBER NORMAL DATABK_0001 /dev/raw/raw4
CACHEDONLINEMEMBER NORMAL DATABK_0000 /dev/raw/raw3
CACHEDONLINEMEMBER NORMAL A18
/dev/raw/raw18
然后删除磁盘
SQL> alter diskgroup newdg_data drop disk a18;
SQL> select MOUNT_STATUS,MODE_STATUS,HEADER_STATUS,STATE,NAME,failgroup from v$asm_disk;
MOUNT_S MODE_ST HEADER_STATU STATENAME
FAILGROUP
------- ------- ------------ -------- --------------- ----------
CACHEDONLINEMEMBER DROPPING A18
A18
state状态显示一会dropping后
SQL> select MOUNT_STATUS,MODE_STATUS,HEADER_STATUS,STATE,NAME,failgroup,header_status from v$asm_disk;
CACHEDONLINEMEMBER HUNG A18
A18MEMBER
查看官档关于hung的解释
HUNG - Disk drop operation cannot continue because there is insufficient space to relocate the data from the disk being dropped
这个磁盘组的空间free的很多,从前面的free_mb就可以看到,但是为什么这个磁盘就是删不掉呢,有没大神遇到过这个问题,谢谢指教。。。
|