加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

ASM磁盘组删除磁盘

发布时间:2020-12-12 13:27:14 所属栏目:百科 来源:网络整理
导读: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_NU

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中被彻底删除。

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读