10 Replies Latest reply: Oct 23, 2013 12:21 AM by Mahir M. Quluzade RSS

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

    Step_Into_Oracle_DBA

      Hi,

       

      I'm trying to create a diskgroup for a temporary purpose. I didnt mention the type of redundancy. When i ran the below command i got the mentioned errors.

      SQL> Create diskgroup temp_dg disk '/dev/mapper/003w1_e2p5' attribute 'compatible.asm' = '11.2.0.0.0';

      Create diskgroup temp_dg disk '/dev/mapper/003w1_e2p5' attribute 'compatible.asm' = '11.2.0.0.0'

      *

      ERROR at line 1:

      ORA-15018: diskgroup cannot be created

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

       

      When i used two disks, then diskgroup got created.

       

      All the diskgroups in ASM are of EXTERNAL redundancy.

       

       

      SQL> Select distinct type from v$asm_diskgroup;

       

       

      TYPE

      ------

      EXTERN

       

      I would like to know why it was asking to create diskgroup of NORMAL redundancy. Is there some thing like default REDUNDANCY in ASM.

       

      Please share your views.

       

      By,

      Step Into Oracle DBA