ORA-15067: command or option incompatible with diskgroup redundancy

<<Back to Oracle ASM Main Page

SQL> ALTER DISKGROUP DG_NORMAL ADD FILEGROUP FG_PDB1 DATABASE PDB1;
ALTER DISKGROUP DG_NORMAL ADD FILEGROUP FG_PDB1 DATABASE PDB1
*
ERROR at line 1:
ORA-15067: command or option incompatible with diskgroup redundancy

$ oerr ora 15067
15067, 00000, "command or option incompatible with diskgroup redundancy"
// *Cause:  An attempt was made to use a feature which is not
//          permitted by the diskgroup's redundancy policy.  Common examples
//          are forcibly dropping a disk from an EXTERNAL REDUNDANCY diskgroup,
//          using the FAILGROUP clause with an EXTERNAL REDUNDANCY diskgroup,
//          using invalid template attributes, or mounting a HIGH or
//          EXTERNAL redundancy diskgroup for recovery.
// *Action: Omit the option from the command.
//

Reason: Creating a FileGroup on a Diskgroup which don't have FLEX redundancy.

Creating a File Group and Quota Group  is only supported with FLEX diskgroup.

SQL> select GROUP_NUMBER,NAME,TYPE from v$asm_diskgroup where GROUP_NUMBER=5 ;
GROUP_NUMBER NAME                           TYPE
------------ ------------------------------ ------
           5 DG_NORMAL                      NORMAL

Solution: Modify the command to include database clause

Create a FLEX DiskGroup and Use Flex DiskGroup to create FileGroup.

Related Posts:

ASM Diskgroup with Flex Redundancy

Oracle ASM Flex Redundancy and Flex Disk Groups