How to fix the Oracle error ORA-15072: command requires at least string regular failure groups, discovered only string?

In this post, you’ll learn more about the Oracle ErrorORA-15072: command requires at least string regular failure groups, discovered only string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-15072: command requires at least string regular failure groups, discovered only string

Reason for the Error ORA-15072: command requires at least string regular failure groups, discovered only string

An attempt was made to create either a normal redundancy diskgroup for which fewer than two regular failure groups were both specified and discovered, or a high redundancy diskgroup for which fewer than three regular failure groups were both specified and discovered, or an external redundancy diskgroup for which only quorum disks were both specified and discovered.

How to fix the Error ORA-15072: command requires at least string regular failure groups, discovered only string ?

You can fix this error in Oracle by following the below steps

Check the that the command does specify the required number of failure groups, and that all of the specified disks are discovered by ASM. A query of the V$ASM_DISK fixed view will show which disks are discovered by ASM. Note that a quorum failure group will not be used as a regular failure group. An external redundancy diskgroup requires at least one regular disk.