SQL> create diskgroup VOTEDISK normal redundancy
2 failgroup failvotedisk1 disk '/dev/mapper/votedisk' name fail1
3 failgroup failvotedisk2 disk '/dev/mapper/votedisk01' name fail2
ATTRIBUTE 'compatible.rdbms' = '19.0', 'compatible.asm' = '19.0';
Diskgroup created.
SQL> set linesize 1000;
SQL> column group_number format 99;
SQL> column name format a16;
SQL> column failgroup format a16;
SQL> column path format a32;
SQL>
SQL>
SQL> select
2 group_number,name,failgroup,path
3 from v$asm_disk
4 where path in ('/dev/mapper/votedisk01', '/dev/mapper/votedisk');
GROUP_NUMBER NAME FAILGROUP PATH
------------ ---------------- ---------------- --------------------------------
6 FAIL2 FAILVOTEDISK2 /dev/mapper/votedisk01
6 FAIL1 FAILVOTEDISK1 /dev/mapper/votedisk