ASM的disk怎么删不掉啊？

显示全部楼层 · 2008-6-30 01:01:54

SQL> alter diskgroup DG9 drop disk RAWD2;
Diskgroup altered.
SQL>select a.name,b.group_number,b.path from v$asm_disk b,v$asm_diskgroup a
2 where a.group_number=b.group_number
3 orderby 1
4;
DG9
1
ORCL:RAWD2
DGT
2
ORCL:T3
DGT
2
ORCL:T4
DGT
2
ORCL:T1

千问 · 2008-6-30 01:01:54

请指教

千问 · 2008-6-30 01:01:54

看disk的状态,是不是hung了?

千问 · 2008-6-30 01:01:54

原帖由 Toms_zhang 于 2010-5-28 22:01 发表
看disk的状态,是不是hung了?

SQL> select name,DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS,MODE_STATUS from v$asm_disk_stat;
NAME DISK_NUMBER MOUNT_STATUS HEADER_STATUS
MODE_STATUS
---------- ----------- -------------- ------------------------ --------------

0 CLOSED FORMER
ONLINE

1 CLOSED UNKNOWN
ONLINE
RAWD2
1 CACHED MEMBER
ONLINE
T1
0 CACHED MEMBER
ONLINE
T3
1 CACHED MEMBER
ONLINE
T4
2 CACHED MEMBER
ONLINE
6 rows selected.

千问 · 2008-6-30 01:01:54

有可能是你在drop以后，disk group还没有完成rebalance.所以这里还能看到这个disk，你可以查询一下v$asm_operation看看。

千问 · 2008-6-30 01:01:54

原帖由 hdydmichael 于 2010-5-29 08:06 发表

SQL> select name,DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS,MODE_STATUS from v$asm_disk_stat;
NAME DISK_NUMBER MOUNT_STATUS HEADER_STATUS
MODE_STATUS
---------- ----------- -------------- ------------------------ --------------

0 CLOSED FORMER
ONLINE

1 CLOSED UNKNOWN
ONLINE
RAWD2
1 CACHED MEMBER
ONLINE
T1
0 CACHED MEMBER
ONLINE
T3
1 CACHED MEMBER
ONLINE
T4
2 CACHED MEMBER
ONLINE
6 rows selected.

看一下state状态:
select name,DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS,MODE_STATUS,STATE from v$asm_disk_stat;
你这个diskgroup只有一个FG,删除disk的时候估计disk state变成HUNG状态了

千问 · 2008-6-30 01:01:54

真是高手，怎么会变成 HUNG状态的？HUNG状态的话怎么删除呢？

SQL> select name,DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS,MODE_STATUS,state from v$asm_disk_stat;

0 CLOSED FORMER
ONLINE NORMAL

1 CLOSED UNKNOWN
ONLINE NORMAL

2 CLOSED CANDIDATE
ONLINE NORMAL

3 CLOSED FOREIGN
ONLINE NORMAL

4 CLOSED FOREIGN
ONLINE NORMAL

5 CLOSED CANDIDATE
ONLINE NORMAL
RAWD2
1 CACHED MEMBER
ONLINE HUNG
T1
0 CACHED MEMBER
ONLINE NORMAL
T3
1 CACHED MEMBER
ONLINE NORMAL
T4
2 CACHED MEMBER
ONLINE NORMAL
10 rows selected.

千问 · 2008-6-30 01:01:54

你这个DG里就一个FG,而这个FG里就一个disk导致的,你先undrop disks, 然后add 一块其他的disk,再删除这个disk
good luck