ASM存储管理

ASM 存储管理

---

查看磁盘组状态

select name,state from v$asm_diskgroup;

查看磁盘组和裸设备直接的关系

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;

删除磁盘组

drop diskgroup data_nor;

---

举例

1. 以sysasm 进入sqlplus
   
2. 查看当前磁盘组和裸设备直接的关系
   
3. 查看当前系统所以磁盘
   
4. 创建正常冗于磁盘组
   
5. 查看当前磁盘组和裸设备直接的关系
   
6. 卸载/加载
   
   
7. 删除磁盘组