❤️Oracle ASM加磁盘及剔盘操作❤️

grid用户登陆节点1操作系统，
检查已存在及待加入ASM磁盘HEADER_STATUS是否为CANDIDATE,
并检查现有磁盘组当前状态。  
select r.NAME,inst_id,group_number,header_status,path from gv$asm_disk r order by 1;
select name,state from v$asm_diskgroup
alter diskgroup DATA add disk '/dev/mapper/MES_DATA1'
alter diskgroup DATA rebalance power 8;
select * from V$asm_operation;

 --磁盘组名称
select name,state from v$asm_diskgroup 
--磁盘信息
select r.NAME,inst_id,group_number,header_status,path from gv$asm_disk r order by 1;  
alter diskgroup IDX drop disk IDX_0001 rebalance power 4; 
 --查看磁盘均衡是否操作结束
select * from V$asm_operation; 

1.检查确认要删除的磁盘组是否在用
select * from dba_data_files;
select * from dba_temp_files;
select * from v$logfile;
2.先在各节点上dismount磁盘组（2个节点都要操作）
alter diskgroup REDO01 dismount;
alter diskgroup REDO02 dismount;
alter diskgroup REDODG1 dismount;
SQL> alter diskgroup DATA dismount;   
SQL> alter diskgroup ARCH mount;
3.ASM中删除磁盘组(grid用户以sysasm角色)
drop diskgroup REDO01 force including contents;
drop diskgroup REDO02 force including contents;
drop diskgroup REDODG1 force including contents;