ocl asm management

查询所有disk状态
select GROUP_NUMBER,DISK_NUMBER,INCARNATION,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,REDUNDANCY,
TOTAL_MB,FREE_MB,NAME,FAILGROUP from v$asm_disk;


查询所有diskgroup状态
select  GROUP_NUMBER,NAME,SECTOR_SIZE,BLOCK_SIZE,ALLOCATION_UNIT_SIZE,STATE,
TYPE,TOTAL_MB,FREE_MB,REQUIRED_MIRROR_FREE_MB,
USABLE_FILE_MB,OFFLINE_DISKS from v$asm_diskgroup;




建带failgroup的diskgroup
CREATE DISKGROUP DATA01 NORMAL REDUNDANCY 
FAILGROUP controller1 DISK 
'/dev/asm-diskc' name fio1,
'/dev/asm-diskd' name fio2
FAILGROUP controller2 DISK 
'/dev/asm-diskf' name sv01,
'/dev/asm-diskg' name sv02
attribute
'au_size'='4M', 
'compatible.asm'='12.1';


默认读取failgroup
alter system  set asm_preferred_read_failure_groups='controller1';


select instname,failgroup,sum(reads),sum(writes) from v$asm_disk_iostat 
group by instname,failgroup order by 1,2;




drop diskgroup data02;




CREATE DISKGROUP REDO external REDUNDANCY 
DISK '/dev/asm-diskh' name redo
attribute
'au_size'='1M', 
'compatible.asm'='12.1';






set linesize 1000
set pagesize 1000




CREATE DISKGROUP FLASH NORMAL REDUNDANCY 
FAILGROUP controller1 DISK 
'/dev/asm-nvme1' name nvme1
FAILGROUP controller2 DISK 
'/dev/asm-nvme2' name nvme2
attribute
'au_size'='4M', 
'compatible.asm'='12.1';