报错描述:
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.
版权声明:本文为m0_37625564原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。