创建asm磁盘指定failgroup

 

 

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