标题: Oracle 19c RAC报错ORA-15032 ORA15411 [打印本页] 作者: jiawang 时间: 7 天前 标题: Oracle 19c RAC报错ORA-15032 ORA15411 select a.group_number,b.name,a.failgroup,a.path
from v$asm_disk a,v$asm_diskgroup b
where a.group_number=b.group_number
and a.group_number=1
order by 3;
GROUP_NUMBER NAME FAILGROUP PATH
-------------------------- --------- ------------------ ----------------------------
1 DATA DATA001 /dev/asm-data01
1 DATA DATA002 /dev/asm-data02
1 DATA DATA003 /dev/asm-data03
1 DATA DATA004 /dev/asm-data04
1 DATA DATA005 /dev/asm-data05
SQL> alter diskgroup data add failgroup DATA001 disk '/dev/data06';
alter diskgroup data add failgroup DATA001 disk '/dev/data06';
*
ERROR at line 1:
ORA-15032: not all alertations performed
ORA-15411: Failure groups in disk group DATA have different number of disks.
从报错信息得知，要求每个failgroup中磁盘数量一致，可通过修改ASM隐含参数来解决：
SQL> alter system set "_asm_disable_failgroup_size_checking"=true;
System altered.
SQL> alter system set "_asm_disable_dangerous_failgroup_checking"=true;
System altered.
SQL> alter diskgroup data add failgroup DATA001 disk '/dev/data06';