My Oracle Support Banner

Exadata/SuperCluster/ODA/RAC/SIHA: Dropping Failgroup in Normal/High Redundancy Diskgroup fails with ORA-15067 or ORA-59327 (Doc ID 2594359.1)

Last updated on OCTOBER 02, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
Applies to Exadata/SuperCluster/ODA/RAC/SIHA: 12.1.0.2 and Higher Release.

Symptoms

In ASM 12.1.0.2 and higher versions, any attempt to drop the Failgroup in Normal/High Redundancy Diskgroup results in one of the below errors:

ORA-15067: command or option incompatible with diskgroup redundancy

ORA-59327: Dropping more fail groups is not allowed with disk group redundancy.

 

The behaviour is explained with below testcase:

12.1.0.2 - 18c : 

SQL> create diskgroup TEST19 normal redundancy disk '/dev/asm0' disk '/dev/asm1' disk '/dev/asm2' attribute 'compatible.asm'='12.2.0.2';

SQL> select name,state,type from v$asm_diskgroup;

NAME         STATE TYPE
---------- ----------- ------
TEST19 MOUNTED NORMAL

SQL> select group_number,substr(path,1,12) Path,substr(name,1,15) Name, substr(failgroup,1,12) Failgroup,header_status,state from v$asm_disk where group_number=(select group_number from v$asm_diskgroup where name='TEST19');

GROUP_NUMBER PATH NAME FAILGROUP HEADER_STATU STATE
------------ ------------ --------------- ------------ ------------ --------
2             /dev/asm2 TEST19_0002 TEST19_0002 MEMBER NORMAL
2             /dev/asm1 TEST19_0001 TEST19_0001 MEMBER NORMAL
2             /dev/asm0 TEST19_0000 TEST19_0000 MEMBER NORMAL

 

SQL> alter diskgroup TEST19 drop disks in failgroup TEST19_0000;

alter diskgroup TEST19 drop disks in failgroup TEST19_0000
*
ERROR at line 1:
ORA-15067: command or option incompatible with diskgroup redundancy         <<<<<<

 

 19c and later:

SQL>create diskgroup TEST19 normal redundancy disk '/dev/asm0' disk '/dev/asm1' disk '/dev/asm2' attribute 'compatible.asm'='19.3.0.0';

SQL> select name,state,type from v$asm_diskgroup;

NAME STATE TYPE
---------- ----------- ------
TEST19 MOUNTED NORMAL

SQL> select group_number,substr(path,1,12) Path,substr(name,1,15) Name, substr(failgroup,1,12) Failgroup,header_status,state from v$asm_disk where group_number=(select group_number from v$asm_diskgroup where name='TEST19');

GROUP_NUMBER PATH NAME FAILGROUP HEADER_STATU STATE
------------ ------------ --------------- ------------ ------------ --------
2 /dev/asm2 TEST19_0002 TEST19_0002 MEMBER NORMAL
2 /dev/asm1 TEST19_0001 TEST19_0001 MEMBER NORMAL
2 /dev/asm0 TEST19_0000 TEST19_0000 MEMBER NORMAL

 

SQL> alter diskgroup TEST19 drop disks in failgroup TEST19_0000;
alter diskgroup TEST19 drop disks in failgroup TEST19_0000
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-59327: Dropping more fail groups is not allowed with disk group redundancy             <<<<<

 

Imp: Any attempt to drop the Failgroup with force option results in the following behaviour :

SQL> alter diskgroup TEST19 drop disks in failgroup TEST19_0001 force;

SQL> select group_number,substr(path,1,12) Path,substr(name,1,15) Name, substr(failgroup,1,12) Failgroup,header_status,state from v$asm_disk where group_number=(select group_number from v$asm_diskgroup where name='TEST19');

GROUP_NUMBER PATH NAME                    FAILGROUP HEADER_STATU STATE
------------ ------------ ---------------------- ------------ ----------------- -----------
2                              _DROPPED_0001_T  TEST19_0001 UNKNOWN FORCING       <<<<<<
2              /dev/asm2 TEST19_0002            TEST19_0002 MEMBER    NORMAL
2              /dev/asm0 TEST19_0000            TEST19_0000 MEMBER    NORMAL

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.