select adg.name,adg.state,ads.name,ads.path from v$asm_disk_stat ads, v$asm_diskgroup adg where ads.group_number = adg.group_number;
查看剩余空间
select name,type,total_mb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup;-- usable_file_mb < 0 添加空间
创建正常冗余磁盘组
create diskgroup data_nor normal redundancy
failgroup controller1 disk '/dev/oracleasm/disks/DISK09'
failgroup controller2 disk '/dev/oracleasm/disks/DISK10';
创建外部冗余磁盘组
create diskgroup data_ext external redundancy
disk '/dev/oracleasm/disks/DISK11';
卸载or装载
alter diskgroup data_ext dismount;alter diskgroup data_ext mount;
删除磁盘
select b.name ,a.name ,a.path from v$asm_diskgroup b ,v$asm_disk_stat a where a.group_number = b.group_number and b.name = 'DATA_NOR';alter diskgroup data_nor drop disk data_nor_0000;alter diskgroup data_nor drop disk data_nor_0002;