Oracle 19c RAC报错ORA-15032 ORA15411

tech2026-03-13  4

报错描述:

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'; System altered.
最新回复(0)