asm删除磁盘组的磁盘及磁盘组本身

来源:互联网 发布:五毛特效软件下载 编辑:程序博客网 时间:2024/05/01 20:30

asm删除磁盘组的磁盘及磁盘组本身
export ORALCE_SID=+ASM

sqlplus /nolog

conn /as sysdba;

select group_number,name,total_mb,free_mb from v$asm_disk_stat;

SELECT NAME,TYPE,TOTAL_MB FROM V$ASM_DISKGROUP;

select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat;

 

ALTER DISKGROUP USERGROUP1 DROP DISK VOL1;

DROP DISKGROUP USERGROUP1;