export ORACLE_SID=+ASM1
sqlplus / as sysasm
select * from v$asm_diskgroup order by group_number;
alter diskgroup test2 dismount FORCE;
drop diskgroup test2 force INCLUDING CONTENTS;
select group_number,disk_number,name,label,
HEADER_STATUS,TOTAL_MB,failgroup,path, OS_MB
from v$asm_disk order by group_number,disk_number;
CREATE DISKGROUP test2 NORMAL REDUNDANCY
FAILGROUP controller1
DISK '/dev/sdd' NAME disk21
FAILGROUP controller2
DISK '/dev/sde' NAME disk22
ATTRIBUTE 'au_size'='4M',
'compatible.asm' = '19.0',
'compatible.rdbms' = '19.0',
'compatible.advm' = '19.0';
alter diskgroup test2 add
FAILGROUP controller1
DISK '/dev/sdf' NAME disk23
FAILGROUP controller2
DISK '/dev/sdg' NAME disk24;
※ディスクサイズが異なるとエラーとなる
ORA-15410: Disks in disk group TEST2 do not have equal size.
select * from v$asm_diskgroup order by group_number;
select group_number,disk_number,name,label,
HEADER_STATUS,TOTAL_MB,failgroup,path, OS_MB
from v$asm_disk order by group_number,disk_number;