ASM磁盘组删除磁盘
ASM磁盘组删除磁盘 [[email?protected] ~]$ su - gridsqlplus / as sysasmConnected.SQL> alter diskgroup data drop disk data_0001;Diskgroup altered.SQL> select disk_number,state,name,total_mb,free_mb from v$asm_disk where group_number = 4;DISK_NUMBER STATE NAME TOTAL_MB FREE_MB----------- -------- ------------------------------ ---------- ---------- 1 DROPPING DATA_0001 1953124 1950842 0 NORMAL DATA_0000 1953124 1948124SQL> select disk_number,free_mb from v$asm_disk where group_number = 4;DISK_NUMBER STATE NAME TOTAL_MB FREE_MB----------- -------- ------------------------------ ---------- ---------- 1 DROPPING DATA_0001 1953124 1951434 0 NORMAL DATA_0000 1953124 1947532SQL> select disk_number,free_mb from v$asm_disk where group_number = 4;DISK_NUMBER STATE NAME TOTAL_MB FREE_MB----------- -------- ------------------------------ ---------- ---------- 1 DROPPING DATA_0001 1953124 1952556 0 NORMAL DATA_0000 1953124 1946410SQL> select disk_number,free_mb from v$asm_disk where group_number = 4;DISK_NUMBER STATE NAME TOTAL_MB FREE_MB----------- -------- ------------------------------ ---------- ---------- 1 DROPPING DATA_0001 1953124 1953096 0 NORMAL DATA_0000 1953124 1945870SQL> select disk_number,free_mb from v$asm_disk where group_number = 4;DISK_NUMBER STATE NAME TOTAL_MB FREE_MB----------- -------- ------------------------------ ---------- ---------- 0 NORMAL DATA_0000 1953124 1945854SQL> select group_number,disk_number,path,free_mb 2 from v$asm_disk 3 where path = ‘/dev/asm-disk5‘;GROUP_NUMBER DISK_NUMBER PATH NAME STATE TOTAL_MB FREE_MB------------ ----------- --------------- ---------- -------- ---------- ---------- 0 1 /dev/asm-disk5 NORMAL 0 0可以看到,虽然删除操作执行完成,但是磁盘并没有真正被删掉,ASM在后台尝试将磁盘上的数据挪到其他可用磁盘中,这时磁盘的状态为DROPPING。当后台数据同步的操作完成,磁盘的组信息被清除,磁盘恢复STATE状态。这时这个磁盘就从ASM中被彻底删除。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |