1 2 Previous Next 19 Replies Latest reply on Oct 4, 2013 1:18 PM by Sami

    ERROR: diskgroup was not mounted

    Sami

      Hi All,

       

      We have 2 node with such node 1 and node 2.

       

      From both nodes we can start the cluster environment.. at present node 2 is down due to OS problem.

      So i am trying to start the cluster from node 1 and started fine..

       

      while am trying to start the database... it show me error as follows

       

      
      SQL> connect sys  as sysdba
      Enter password:
      Connected to an idle instance.
      SQL> startup
      ORA-01078: failure in processing system parameters
      ORA-01565: error in identifying file '+FLASH_RECOVERY_AREA/XXXXX/spfileXXXXX.ora'
      ORA-17503: ksfdopn:2 Failed to open file +FLASH_RECOVERY_AREA/XXXXX/spfileXXXXXX.ora
      ORA-15077: could not locate ASM instance serving a required diskgroup
      SQL>
      

       

      oracle has mounted only data disk group .. its failing to mount FLASHBACK_RECOVERY_AREA.

      Enter user-name: /as sysdba
      
      
      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
      With the Partitioning, Real Application Clusters, OLAP and Data Mining options
      
      
      SQL> select NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;
      
      
      NAME                             TOTAL_MB    FREE_MB
      ------------------------------ ---------- ----------
      RUBIKON_DATA                       358400     292097
      
      
      
      
      
      
      
      

       

       

      When i try to mount it .. it showing following error....

       

      SQL> alter diskgroup FLASH_RECOVERY_AREA mount;
      alter diskgroup FLASH_RECOVERY_AREA mount
      *
      ERROR at line 1:
      ORA-15032: not all alterations performed
      ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FLASH_RECOVERY_AREA"
      
      

       

      but ASM is listing all nodes..

      XXXXXX120:/ # /etc/init.d/oracleasm listdisks
      RUBIKON_DATA1
      RUBIKON_DATA2
      RUBIKON_FB01
      rubikon120:/ #
      

       

       

      NAME                           HEADER_STATU PATH
      ------------------------------ ------------ ---------------------------------------------------------------------------------------------------------------
       PROVISIONED  /dev/mapper/Rubikon_fb
      RUBIKON_DATA_0000              MEMBER       /dev/mapper/Rubikon_data1
      RUBIKON_DATA_0001              MEMBER       /dev/mapper/Rubikon_data2
      
      

       

      Please guide me how to mount the disk...

       

      Thanks & Regards

      Sami

        • 1. Re: ERROR: diskgroup was not mounted
          mkeskin

          Hi ,

           

          Try this;

          asmcmd > mount -a

           

          If it throws any error send out alert.log detail.

          • 2. Re: ERROR: diskgroup was not mounted
            Anar Godjaev

            HI,

             

            ovmdbtest1.asyalocal.com.tr@09:52:05> asmcmd
            ASMCMD> mount DATA
            ORA-15032: not all alterations performed
            ORA-15017: diskgroup “DATA” cannot be mounted
            ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATA” (DBD ERROR: OCIStmtExecute)
            ASMCMD>

            Same as;

            SQL> alter diskgroup DATA mount;
            alter diskgroup DATA mount
            *
            ERROR at line 1:
            ORA-15032: not all alterations performed
            ORA-15017: diskgroup “DATA” cannot be mounted
            ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATA”

            I think, one  or more of ASM disk’s header  was corrupted.  I checked my disks using ASMCA utility and  it shows the status of 2 disks  as “PROVISIONED”. Similarly, kfod utility also shows the status of 2 disks  as “PROVISIONED”.

            # $GRID_HOME/bin/kfod status=TRUE asm_diskstring=’/dev/raw/raw*’ disk=all dscvgroup=TRUE
            ——————————————————————————–
            Disk Size Header Path Disk Group User Group
            ================================================================================
            1: 512000 Mb MEMBER /dev/raw/raw1 DATA ora11g dba
            2: 512000 Mb PROVISIONED /dev/raw/raw2 DATA ora11g dba
            3: 512000 Mb MEMBER /dev/raw/raw3 DATA ora11g dba
            4: 512000 Mb PROVISIONED /dev/raw/raw4 DATA ora11g dba
            5: 512000 Mb MEMBER /dev/raw/raw5 DATA ora11g dba
            6: 512000 Mb MEMBER /dev/raw/raw6 DATA ora11g dba
            ——————————————————————————–
            ORACLE_SID ORACLE_HOME
            ================================================================================
            +ASM /oracle/grid11g

            I closed ASM instance and checked the header information of damaged disk using kfed utility.

            # $GRID_HOME/bin/kfed read /dev/raw/raw2

            kfbh.endian:                          1 ; 0×000: 0×01
            kfbh.hard:                          130 ; 0×001: 0×82
            kfbh.type:                            1 ; 0×002: KFBTYP_DISKHEAD
            kfbh.datfmt:                          1 ; 0×003: 0×01
            kfbh.block.blk:                       0 ; 0×004: blk=0
            kfbh.block.obj:              2147483648 ; 0×008: disk=0
            kfbh.check:                   945480537 ; 0x00c: 0x385ae359
            kfbh.fcn.base:                        0 ; 0×010: 0×00000000
            kfbh.fcn.wrap:                        0 ; 0×014: 0×00000000
            kfbh.spare1:                          0 ; 0×018: 0×00000000
            kfbh.spare2:                          0 ; 0x01c: 0×00000000
            kfdhdb.driver.provstr:ORCLDISK ; 0×000: length=32
            kfdhdb.driver.reserved[0]:     33686018 ; 0×008: 0×02020202
            kfdhdb.driver.reserved[1]:     33686018 ; 0x00c: 0×02020202
            kfdhdb.driver.reserved[2]:     33686018 ; 0×010: 0×02020202
            kfdhdb.driver.reserved[3]:     33686018 ; 0×014: 0×02020202
            kfdhdb.driver.reserved[4]:     33686018 ; 0×018: 0×02020202
            kfdhdb.driver.reserved[5]:     33686018 ; 0x01c: 0×02020202
            kfdhdb.compat:                186646528 ; 0×020: 0x0b200000
            kfdhdb.dsknum:                        0 ; 0×024: 0×0000
            kfdhdb.grptyp:                        1 ; 0×026: KFDGTP_EXTERNAL
            kfdhdb.hdrsts:                        3 ; 0×027: KFDHDR_MEMBER
            kfdhdb.dskname:               DATA_0000 ; 0×028: length=9
            kfdhdb.grpname:                    DATA ; 0×048: length=4
            kfdhdb.fgname:                DATA_0000 ; 0×068: length=9
            kfdhdb.capname:                         ; 0×088: length=0
            kfdhdb.crestmp.hi:             32983952 ; 0x0a8: HOUR=0×10 DAYS=0x1c MNTH=0×2 YEAR=0x7dd
            kfdhdb.crestmp.lo:           3911025664 ; 0x0ac: USEC=0×0 MSEC=0×361 SECS=0×11 MINS=0x3a
            kfdhdb.mntstmp.hi:             32984464 ; 0x0b0: HOUR=0×10 DAYS=0xc MNTH=0×3 YEAR=0x7dd
            kfdhdb.mntstmp.lo:           3973637120 ; 0x0b4: USEC=0×0 MSEC=0×239 SECS=0xd MINS=0x3b
            kfdhdb.secsize:                     512 ; 0x0b8: 0×0200
            kfdhdb.blksize:                    4096 ; 0x0ba: 0×1000
            kfdhdb.ausize:                  1048576 ; 0x0bc: 0×00100000
            kfdhdb.mfact:                    113792 ; 0x0c0: 0x0001bc80
            kfdhdb.dsksize:                  512000 ; 0x0c4: 0x0007d000
            kfdhdb.pmcnt:                         6 ; 0x0c8: 0×00000006
            kfdhdb.fstlocn:                       1 ; 0x0cc: 0×00000001
            kfdhdb.altlocn:                       2 ; 0x0d0: 0×00000002
            kfdhdb.f1b1locn:                      2 ; 0x0d4: 0×00000002
            kfdhdb.redomirrors[0]:                0 ; 0x0d8: 0×0000
            kfdhdb.redomirrors[1]:                0 ; 0x0da: 0×0000
            kfdhdb.redomirrors[2]:                0 ; 0x0dc: 0×0000
            kfdhdb.redomirrors[3]:                0 ; 0x0de: 0×0000
            kfdhdb.dbcompat:              168820736 ; 0x0e0: 0x0a100000
            kfdhdb.grpstmp.hi:             32983952 ; 0x0e4: HOUR=0×10 DAYS=0x1c MNTH=0×2 YEAR=0x7dd
            kfdhdb.grpstmp.lo:           3909777408 ; 0x0e8: USEC=0×0 MSEC=0x29e SECS=0×10 MINS=0x3a
            kfdhdb.vfstart:                       0 ; 0x0ec: 0×00000000
            kfdhdb.vfend:                         0 ; 0x0f0: 0×00000000
            kfdhdb.spfile:                        0 ; 0x0f4: 0×00000000
            kfdhdb.spfflg:                        0 ; 0x0f8: 0×00000000
            kfdhdb.ub4spare[0]:                   0 ; 0x0fc: 0×00000000
            kfdhdb.ub4spare[1]:                   0 ; 0×100: 0×00000000
            kfdhdb.ub4spare[2]:                   0 ; 0×104: 0×00000000
            kfdhdb.ub4spare[3]:                   0 ; 0×108: 0×00000000
            kfdhdb.ub4spare[4]:                   0 ; 0x10c: 0×00000000
            kfdhdb.ub4spare[5]:                   0 ; 0×110: 0×00000000
            kfdhdb.ub4spare[6]:                   0 ; 0×114: 0×00000000
            kfdhdb.ub4spare[7]:                   0 ; 0×118: 0×00000000
            kfdhdb.ub4spare[8]:                   0 ; 0x11c: 0×00000000
            kfdhdb.ub4spare[9]:                   0 ; 0×120: 0×00000000
            kfdhdb.ub4spare[10]:                  0 ; 0×124: 0×00000000
            kfdhdb.ub4spare[11]:                  0 ; 0×128: 0×00000000
            kfdhdb.ub4spare[12]:                  0 ; 0x12c: 0×00000000
            kfdhdb.ub4spare[13]:                  0 ; 0×130: 0×00000000
            kfdhdb.ub4spare[14]:                  0 ; 0×134: 0×00000000
            kfdhdb.ub4spare[15]:                  0 ; 0×138: 0×00000000
            kfdhdb.ub4spare[16]:                  0 ; 0x13c: 0×00000000
            kfdhdb.ub4spare[17]:                  0 ; 0×140: 0×00000000
            kfdhdb.ub4spare[18]:                  0 ; 0×144: 0×00000000
            kfdhdb.ub4spare[19]:                  0 ; 0×148: 0×00000000
            kfdhdb.ub4spare[20]:                  0 ; 0x14c: 0×00000000
            kfdhdb.ub4spare[21]:                  0 ; 0×150: 0×00000000
            kfdhdb.ub4spare[22]:                  0 ; 0×154: 0×00000000
            kfdhdb.ub4spare[23]:                  0 ; 0×158: 0×00000000
            kfdhdb.ub4spare[24]:                  0 ; 0x15c: 0×00000000
            kfdhdb.ub4spare[25]:                  0 ; 0×160: 0×00000000
            kfdhdb.ub4spare[26]:                  0 ; 0×164: 0×00000000
            kfdhdb.ub4spare[27]:                  0 ; 0×168: 0×00000000
            kfdhdb.ub4spare[28]:                  0 ; 0x16c: 0×00000000
            kfdhdb.ub4spare[29]:                  0 ; 0×170: 0×00000000
            kfdhdb.ub4spare[30]:                  0 ; 0×174: 0×00000000
            kfdhdb.ub4spare[31]:                  0 ; 0×178: 0×00000000
            kfdhdb.ub4spare[32]:                  0 ; 0x17c: 0×00000000
            kfdhdb.ub4spare[33]:                  0 ; 0×180: 0×00000000
            kfdhdb.ub4spare[34]:                  0 ; 0×184: 0×00000000
            kfdhdb.ub4spare[35]:                  0 ; 0×188: 0×00000000
            kfdhdb.ub4spare[36]:                  0 ; 0x18c: 0×00000000
            kfdhdb.ub4spare[37]:                  0 ; 0×190: 0×00000000
            kfdhdb.ub4spare[38]:                  0 ; 0×194: 0×00000000
            kfdhdb.ub4spare[39]:             254613 ; 0×198: 0x0003e295
            kfdhdb.ub4spare[40]:                  0 ; 0x19c: 0×00000000
            kfdhdb.ub4spare[41]:                  0 ; 0x1a0: 0×00000000
            kfdhdb.ub4spare[42]:                  0 ; 0x1a4: 0×00000000
            kfdhdb.ub4spare[43]:                  0 ; 0x1a8: 0×00000000
            kfdhdb.ub4spare[44]:                  0 ; 0x1ac: 0×00000000
            kfdhdb.ub4spare[45]:                  0 ; 0x1b0: 0×00000000
            kfdhdb.ub4spare[46]:                  0 ; 0x1b4: 0×00000000
            kfdhdb.ub4spare[47]:                  0 ; 0x1b8: 0×00000000
            kfdhdb.ub4spare[48]:                  0 ; 0x1bc: 0×00000000
            kfdhdb.ub4spare[49]:                  0 ; 0x1c0: 0×00000000
            kfdhdb.ub4spare[50]:                  0 ; 0x1c4: 0×00000000
            kfdhdb.ub4spare[51]:                  0 ; 0x1c8: 0×00000000
            kfdhdb.ub4spare[52]:                  0 ; 0x1cc: 0×00000000
            kfdhdb.ub4spare[53]:                  0 ; 0x1d0: 0×00000000
            kfdhdb.acdb.aba.seq:                  0 ; 0x1d4: 0×00000000
            kfdhdb.acdb.aba.blk:                  0 ; 0x1d8: 0×00000000
            kfdhdb.acdb.ents:                     0 ; 0x1dc: 0×0000
            kfdhdb.acdb.ub2spare:             43605 ; 0x1de: 0xaa55

            The header information was corrupted. kfed output for the disk affected shows 0xaa55 on kfdhdb.acdb.ub2spare field. I backed up the header information using dd command.

            # dd if=/dev/raw/raw2 of=/tmp/DATA.dd bs=1M count=10

            I got the allocation unit size of damaged disk.

            # $GRID_HOME/bin/kfed read /dev/raw/raw2 | grep ausize

            Now we can repair damaged header information.

            # $GRID_HOME/bin/kfed repair /dev/raw/raw2 aus=1048576

            I rechecked the header information of damaged disk using kfed utility. Now, kfed output for the disk affected shows 0×0000 on kfdhdb.acdb.ub2spare field

            # $GRID_HOME/bin/kfed read /dev/raw/raw2

            kfbh.endian:                          1 ; 0×000: 0×01
            kfbh.hard:                          130 ; 0×001: 0×82
            kfbh.type:                            1 ; 0×002: KFBTYP_DISKHEAD
            kfbh.datfmt:                          1 ; 0×003: 0×01
            kfbh.block.blk:                       0 ; 0×004: blk=0
            kfbh.block.obj:              2147483648 ; 0×008: disk=0
            kfbh.check:                   945480537 ; 0x00c: 0x385ae359
            kfbh.fcn.base:                        0 ; 0×010: 0×00000000
            kfbh.fcn.wrap:                        0 ; 0×014: 0×00000000
            kfbh.spare1:                          0 ; 0×018: 0×00000000
            kfbh.spare2:                          0 ; 0x01c: 0×00000000
            kfdhdb.driver.provstr:ORCLDISK ; 0×000: length=32
            kfdhdb.driver.reserved[0]:     33686018 ; 0×008: 0×02020202
            kfdhdb.driver.reserved[1]:     33686018 ; 0x00c: 0×02020202
            kfdhdb.driver.reserved[2]:     33686018 ; 0×010: 0×02020202
            kfdhdb.driver.reserved[3]:     33686018 ; 0×014: 0×02020202
            kfdhdb.driver.reserved[4]:     33686018 ; 0×018: 0×02020202
            kfdhdb.driver.reserved[5]:     33686018 ; 0x01c: 0×02020202
            kfdhdb.compat:                186646528 ; 0×020: 0x0b200000
            kfdhdb.dsknum:                        0 ; 0×024: 0×0000
            kfdhdb.grptyp:                        1 ; 0×026: KFDGTP_EXTERNAL
            kfdhdb.hdrsts:                        3 ; 0×027: KFDHDR_MEMBER
            kfdhdb.dskname:               DATA_0000 ; 0×028: length=9
            kfdhdb.grpname:                    DATA ; 0×048: length=4
            kfdhdb.fgname:                DATA_0000 ; 0×068: length=9
            kfdhdb.capname:                         ; 0×088: length=0
            kfdhdb.crestmp.hi:             32983952 ; 0x0a8: HOUR=0×10 DAYS=0x1c MNTH=0×2 YEAR=0x7dd
            kfdhdb.crestmp.lo:           3911025664 ; 0x0ac: USEC=0×0 MSEC=0×361 SECS=0×11 MINS=0x3a
            kfdhdb.mntstmp.hi:             32984464 ; 0x0b0: HOUR=0×10 DAYS=0xc MNTH=0×3 YEAR=0x7dd
            kfdhdb.mntstmp.lo:           3973637120 ; 0x0b4: USEC=0×0 MSEC=0×239 SECS=0xd MINS=0x3b
            kfdhdb.secsize:                     512 ; 0x0b8: 0×0200
            kfdhdb.blksize:                    4096 ; 0x0ba: 0×1000
            kfdhdb.ausize:                  1048576 ; 0x0bc: 0×00100000
            kfdhdb.mfact:                    113792 ; 0x0c0: 0x0001bc80
            kfdhdb.dsksize:                  512000 ; 0x0c4: 0x0007d000
            kfdhdb.pmcnt:                         6 ; 0x0c8: 0×00000006
            kfdhdb.fstlocn:                       1 ; 0x0cc: 0×00000001
            kfdhdb.altlocn:                       2 ; 0x0d0: 0×00000002
            kfdhdb.f1b1locn:                      2 ; 0x0d4: 0×00000002
            kfdhdb.redomirrors[0]:                0 ; 0x0d8: 0×0000
            kfdhdb.redomirrors[1]:                0 ; 0x0da: 0×0000
            kfdhdb.redomirrors[2]:                0 ; 0x0dc: 0×0000
            kfdhdb.redomirrors[3]:                0 ; 0x0de: 0×0000
            kfdhdb.dbcompat:              168820736 ; 0x0e0: 0x0a100000
            kfdhdb.grpstmp.hi:             32983952 ; 0x0e4: HOUR=0×10 DAYS=0x1c MNTH=0×2 YEAR=0x7dd
            kfdhdb.grpstmp.lo:           3909777408 ; 0x0e8: USEC=0×0 MSEC=0x29e SECS=0×10 MINS=0x3a
            kfdhdb.vfstart:                       0 ; 0x0ec: 0×00000000
            kfdhdb.vfend:                         0 ; 0x0f0: 0×00000000
            kfdhdb.spfile:                        0 ; 0x0f4: 0×00000000
            kfdhdb.spfflg:                        0 ; 0x0f8: 0×00000000
            kfdhdb.ub4spare[0]:                   0 ; 0x0fc: 0×00000000
            kfdhdb.ub4spare[1]:                   0 ; 0×100: 0×00000000
            kfdhdb.ub4spare[2]:                   0 ; 0×104: 0×00000000
            kfdhdb.ub4spare[3]:                   0 ; 0×108: 0×00000000
            kfdhdb.ub4spare[4]:                   0 ; 0x10c: 0×00000000
            kfdhdb.ub4spare[5]:                   0 ; 0×110: 0×00000000
            kfdhdb.ub4spare[6]:                   0 ; 0×114: 0×00000000
            kfdhdb.ub4spare[7]:                   0 ; 0×118: 0×00000000
            kfdhdb.ub4spare[8]:                   0 ; 0x11c: 0×00000000
            kfdhdb.ub4spare[9]:                   0 ; 0×120: 0×00000000
            kfdhdb.ub4spare[10]:                  0 ; 0×124: 0×00000000
            kfdhdb.ub4spare[11]:                  0 ; 0×128: 0×00000000
            kfdhdb.ub4spare[12]:                  0 ; 0x12c: 0×00000000
            kfdhdb.ub4spare[13]:                  0 ; 0×130: 0×00000000
            kfdhdb.ub4spare[14]:                  0 ; 0×134: 0×00000000
            kfdhdb.ub4spare[15]:                  0 ; 0×138: 0×00000000
            kfdhdb.ub4spare[16]:                  0 ; 0x13c: 0×00000000
            kfdhdb.ub4spare[17]:                  0 ; 0×140: 0×00000000
            kfdhdb.ub4spare[18]:                  0 ; 0×144: 0×00000000
            kfdhdb.ub4spare[19]:                  0 ; 0×148: 0×00000000
            kfdhdb.ub4spare[20]:                  0 ; 0x14c: 0×00000000
            kfdhdb.ub4spare[21]:                  0 ; 0×150: 0×00000000
            kfdhdb.ub4spare[22]:                  0 ; 0×154: 0×00000000
            kfdhdb.ub4spare[23]:                  0 ; 0×158: 0×00000000
            kfdhdb.ub4spare[24]:                  0 ; 0x15c: 0×00000000
            kfdhdb.ub4spare[25]:                  0 ; 0×160: 0×00000000
            kfdhdb.ub4spare[26]:                  0 ; 0×164: 0×00000000
            kfdhdb.ub4spare[27]:                  0 ; 0×168: 0×00000000
            kfdhdb.ub4spare[28]:                  0 ; 0x16c: 0×00000000
            kfdhdb.ub4spare[29]:                  0 ; 0×170: 0×00000000
            kfdhdb.ub4spare[30]:                  0 ; 0×174: 0×00000000
            kfdhdb.ub4spare[31]:                  0 ; 0×178: 0×00000000
            kfdhdb.ub4spare[32]:                  0 ; 0x17c: 0×00000000
            kfdhdb.ub4spare[33]:                  0 ; 0×180: 0×00000000
            kfdhdb.ub4spare[34]:                  0 ; 0×184: 0×00000000
            kfdhdb.ub4spare[35]:                  0 ; 0×188: 0×00000000
            kfdhdb.ub4spare[36]:                  0 ; 0x18c: 0×00000000
            kfdhdb.ub4spare[37]:                  0 ; 0×190: 0×00000000
            kfdhdb.ub4spare[38]:                  0 ; 0×194: 0×00000000
            kfdhdb.ub4spare[39]:                  0 ; 0×198: 0×00000000
            kfdhdb.ub4spare[40]:                  0 ; 0x19c: 0×00000000
            kfdhdb.ub4spare[41]:                  0 ; 0x1a0: 0×00000000
            kfdhdb.ub4spare[42]:                  0 ; 0x1a4: 0×00000000
            kfdhdb.ub4spare[43]:                  0 ; 0x1a8: 0×00000000
            kfdhdb.ub4spare[44]:                  0 ; 0x1ac: 0×00000000
            kfdhdb.ub4spare[45]:                  0 ; 0x1b0: 0×00000000
            kfdhdb.ub4spare[46]:                  0 ; 0x1b4: 0×00000000
            kfdhdb.ub4spare[47]:                  0 ; 0x1b8: 0×00000000
            kfdhdb.ub4spare[48]:                  0 ; 0x1bc: 0×00000000
            kfdhdb.ub4spare[49]:                  0 ; 0x1c0: 0×00000000
            kfdhdb.ub4spare[50]:                  0 ; 0x1c4: 0×00000000
            kfdhdb.ub4spare[51]:                  0 ; 0x1c8: 0×00000000
            kfdhdb.ub4spare[52]:                  0 ; 0x1cc: 0×00000000
            kfdhdb.ub4spare[53]:                  0 ; 0x1d0: 0×00000000
            kfdhdb.acdb.aba.seq:                  0 ; 0x1d4: 0×00000000
            kfdhdb.acdb.aba.blk:                  0 ; 0x1d8: 0×00000000
            kfdhdb.acdb.ents:                     0 ; 0x1dc: 0×0000
            kfdhdb.acdb.ub2spare:                 0 ; 0x1de: 0×0000

            Now, we can mount DATA diskgroup successfully.

             

            Can you please check this link :

             

            Mounting ASM Diskgroup Fails With ORA-15063 Error and Resolving With KFED | Talip Hakan Ozturk's ORACLE BLOG

             

            Tahnk you

            • 3. Re: ERROR: diskgroup was not mounted
              Sami

              Hi AnarGodjaev,

               

              SQL> show parameter asm
              
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              asm_diskgroups                       string      RUBIKON_DATA, FLASH_RECOVERY_AREA
              asm_diskstring                       string      /dev/mapper/Rubikon_data1, /dev/mapper/Rubikon_data2, /dev/mapper/Rubikon_fb
              asm_power_limit                      integer     1
              SQL>
              
              
              
              
              

               

               

              I have tried your solution with following option..asm_diskstring='/dev/mapper/*' and asm_diskstring='/dev/raw/raw*' but no luck..

               

              oracle@rubikon120:/opt/app/oracle/oracle/product/10.2.0/db_1/bin> kfod status=TRUE asm_diskstring='/dev/mapper/*' disk=all dscvgroup=TRUE
              KFOD-00101: file not found; arguments: [101]
              
              
              oracle@rubikon120:/opt/app/oracle/oracle/product/10.2.0/db_1/bin> kfod status=TRUE asm_diskstring='/dev/raw/raw*' disk=all dscvgroup=TRUE
              KFOD-00101: file not found; arguments: [101]
              
              
              
              
              
              
              

               

              @mkeskin

               

              I have tried but output is like below.

               

              oracle@rubikon120:~> export ORACLE_SID=+ASM1
              oracle@rubikon120:~> asmcmd
              ASMCMD> mount -a
                      commands:
                      --------
                      cd
                      du
                      find
                      help
                      ls
                      lsct
                      lsdg
                      mkalias
                      mkdir
                      pwd
                      rm
                      rmalias
              ASMCMD>
              
              
              
              
              
              

               

              Thanks & Regards

              Sami

               

              Message was edited by: Sami

               

              Message was edited by: Sami

               

              Message was edited by: Sami

              • 4. Re: ERROR: diskgroup was not mounted
                Anar Godjaev

                hmmm it is very interesting  

                 

                Can you please run  chown oracle: dba /dev/rdsk/*

                 

                 

                Thank you

                • 5. Re: ERROR: diskgroup was not mounted
                  mkeskin

                  You have older version of asmcmd ;

                   

                  ASMCMD> help mount

                          mount

                   

                   

                          Mounts a disk group.

                   

                   

                          mount [--restrict] { [-a] | [-f] diskgroup[ diskgroup ...] }

                   

                   

                          The options for the mount command are described below.

                   

                   

                          diskgroup       - Name of the disk group.

                          -a              - Mounts all disk groups.

                          --restrict      - Mounts in restricted mode.

                          -f              - Forces the mount operation.

                   

                   

                          This operation mounts one or more disk groups. A disk group

                          can be mounted with or without force or restricted options.

                   

                   

                          The following are examples of the mount command showing the use of

                          the -force, -restrict, and -a options.

                   

                   

                          ASMCMD [+] > mount -f data

                          ASMCMD [+] > mount --restrict data

                          ASMCMD [+] > mount -a

                   

                   

                  You have to mount manually diskgroups;

                   

                  $ sqlplus "/as sysasm"

                   

                  SQL> show parameter asm_diskgroups;

                   

                   

                  NAME                                 TYPE        VALUE

                  ------------------------------------ ----------- ------------------------------

                  asm_diskgroups                       string      DATA, FLASH_RECOVERY_AREA

                   

                  If above query return value empty ,

                   

                  alter system set asm_diskgroups="DATA, FLASH_RECOVERY_AREA" sid=”*”;


                  restart asm instance and try again

                  • 6. Re: ERROR: diskgroup was not mounted
                    Sami

                    Hi All,

                     

                    Thanks for your reply..

                     

                    its already having the permission

                     

                    brw-rw---- 1 oracle oinstall 253,  4 Oct  1 15:01 Rubikon_data1
                    brw-rw---- 1 oracle oinstall 253,  3 Oct  1 14:51 Rubikon_data2
                    brw-rw---- 1 oracle oinstall 253,  2 Sep 30 16:19 Rubikon_fb
                    
                    

                     

                    @mkeskin

                     

                    I have already post the asm_string.. Please refer it.

                     

                    Thanks & Regards

                    Sami

                    • 7. Re: ERROR: diskgroup was not mounted
                      mkeskin

                      Can you check this file's permissions ?

                       

                      ls -al $GRID_HOME/bin/oracle

                       

                       

                      ls -al $ORACLE_HOME/bin/oracle

                      • 8. Re: ERROR: diskgroup was not mounted
                        Sami

                        Hi mkeskin,


                        ls -al $ORACLE_HOME/bin/oracle


                        oracle@rubikon120:/opt/app/oracle/oracle/product/10.2.0/db_1/bin> ls -al oracle
                        -rwsr-s--x 1 oracle oinstall 108853007 2010-02-04 15:58 oracle
                        
                        
                        

                         


                        ls -al $GRID_HOME/bin/oracle


                        I hope your saying GRID_HOME as CLUSTER_HOME

                         

                        I don't have file called oracle in CRS_HOME\bin

                         

                        oracle@rubikon120:/opt/app/oracle/oracle/product/10.2.0/crs/bin> ls -al ora*
                        -rwxr-xr-x 1 oracle oinstall 2947 2000-01-01 00:00 oraenv
                        

                         

                        Thanks & Regards

                        Sami

                        • 9. Re: ERROR: diskgroup was not mounted
                          mkeskin

                          Run this commands,

                           

                          $ cd $ORACLE_HOME/rdbms/lib

                          $ make -f ins* ikfed

                           

                          and after check this note ,

                           

                          Mounting Diskgroup Fails With ORA-15063 and V$ASM_DISK Shows PROVISIONED (Doc ID 1487443.1)

                          1 person found this helpful
                          • 10. Re: ERROR: diskgroup was not mounted
                            mkeskin

                            Hi AnarGodjaev,

                             

                            Your solution can be applied  if ASM version is 11.1.0.7 or above. Check support note in my last post.

                            AnarGodjaev wrote:

                             

                            HI,

                             

                            ovmdbtest1.asyalocal.com.tr@09:52:05> asmcmd
                            ASMCMD> mount DATA
                            ORA-15032: not all alterations performed
                            ORA-15017: diskgroup “DATA” cannot be mounted
                            ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATA” (DBD ERROR: OCIStmtExecute)
                            ASMCMD>

                            Same as;

                            SQL> alter diskgroup DATA mount;
                            alter diskgroup DATA mount
                            *
                            ERROR at line 1:
                            ORA-15032: not all alterations performed
                            ORA-15017: diskgroup “DATA” cannot be mounted
                            ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATA”

                            I think, one  or more of ASM disk’s header  was corrupted.  I checked my disks using ASMCA utility and  it shows the status of 2 disks  as “PROVISIONED”. Similarly, kfod utility also shows the status of 2 disks  as “PROVISIONED”.

                            # $GRID_HOME/bin/kfod status=TRUE asm_diskstring=’/dev/raw/raw*’ disk=all dscvgroup=TRUE
                            ——————————————————————————–
                            Disk Size Header Path Disk Group User Group
                            ================================================================================
                            1: 512000 Mb MEMBER /dev/raw/raw1 DATA ora11g dba
                            2: 512000 Mb PROVISIONED /dev/raw/raw2 DATA ora11g dba
                            3: 512000 Mb MEMBER /dev/raw/raw3 DATA ora11g dba
                            4: 512000 Mb PROVISIONED /dev/raw/raw4 DATA ora11g dba
                            5: 512000 Mb MEMBER /dev/raw/raw5 DATA ora11g dba
                            6: 512000 Mb MEMBER /dev/raw/raw6 DATA ora11g dba
                            ——————————————————————————–
                            ORACLE_SID ORACLE_HOME
                            ================================================================================
                            +ASM /oracle/grid11g

                            I closed ASM instance and checked the header information of damaged disk using kfed utility.

                            # $GRID_HOME/bin/kfed read /dev/raw/raw2

                            kfbh.endian:                          1 ; 0×000: 0×01
                            kfbh.hard:                          130 ; 0×001: 0×82
                            kfbh.type:                            1 ; 0×002: KFBTYP_DISKHEAD
                            kfbh.datfmt:                          1 ; 0×003: 0×01
                            kfbh.block.blk:                       0 ; 0×004: blk=0
                            kfbh.block.obj:              2147483648 ; 0×008: disk=0
                            kfbh.check:                   945480537 ; 0x00c: 0x385ae359
                            kfbh.fcn.base:                        0 ; 0×010: 0×00000000
                            kfbh.fcn.wrap:                        0 ; 0×014: 0×00000000
                            kfbh.spare1:                          0 ; 0×018: 0×00000000
                            kfbh.spare2:                          0 ; 0x01c: 0×00000000
                            kfdhdb.driver.provstr:ORCLDISK ; 0×000: length=32
                            kfdhdb.driver.reserved[0]:     33686018 ; 0×008: 0×02020202
                            kfdhdb.driver.reserved[1]:     33686018 ; 0x00c: 0×02020202
                            kfdhdb.driver.reserved[2]:     33686018 ; 0×010: 0×02020202
                            kfdhdb.driver.reserved[3]:     33686018 ; 0×014: 0×02020202
                            kfdhdb.driver.reserved[4]:     33686018 ; 0×018: 0×02020202
                            kfdhdb.driver.reserved[5]:     33686018 ; 0x01c: 0×02020202
                            kfdhdb.compat:                186646528 ; 0×020: 0x0b200000
                            kfdhdb.dsknum:                        0 ; 0×024: 0×0000
                            kfdhdb.grptyp:                        1 ; 0×026: KFDGTP_EXTERNAL
                            kfdhdb.hdrsts:                        3 ; 0×027: KFDHDR_MEMBER
                            kfdhdb.dskname:               DATA_0000 ; 0×028: length=9
                            kfdhdb.grpname:                    DATA ; 0×048: length=4
                            kfdhdb.fgname:                DATA_0000 ; 0×068: length=9
                            kfdhdb.capname:                         ; 0×088: length=0
                            kfdhdb.crestmp.hi:             32983952 ; 0x0a8: HOUR=0×10 DAYS=0x1c MNTH=0×2 YEAR=0x7dd
                            kfdhdb.crestmp.lo:           3911025664 ; 0x0ac: USEC=0×0 MSEC=0×361 SECS=0×11 MINS=0x3a
                            kfdhdb.mntstmp.hi:             32984464 ; 0x0b0: HOUR=0×10 DAYS=0xc MNTH=0×3 YEAR=0x7dd
                            kfdhdb.mntstmp.lo:           3973637120 ; 0x0b4: USEC=0×0 MSEC=0×239 SECS=0xd MINS=0x3b
                            kfdhdb.secsize:                     512 ; 0x0b8: 0×0200
                            kfdhdb.blksize:                    4096 ; 0x0ba: 0×1000
                            kfdhdb.ausize:                  1048576 ; 0x0bc: 0×00100000
                            kfdhdb.mfact:                    113792 ; 0x0c0: 0x0001bc80
                            kfdhdb.dsksize:                  512000 ; 0x0c4: 0x0007d000
                            kfdhdb.pmcnt:                         6 ; 0x0c8: 0×00000006
                            kfdhdb.fstlocn:                       1 ; 0x0cc: 0×00000001
                            kfdhdb.altlocn:                       2 ; 0x0d0: 0×00000002
                            kfdhdb.f1b1locn:                      2 ; 0x0d4: 0×00000002
                            kfdhdb.redomirrors[0]:                0 ; 0x0d8: 0×0000
                            kfdhdb.redomirrors[1]:                0 ; 0x0da: 0×0000
                            kfdhdb.redomirrors[2]:                0 ; 0x0dc: 0×0000
                            kfdhdb.redomirrors[3]:                0 ; 0x0de: 0×0000
                            kfdhdb.dbcompat:              168820736 ; 0x0e0: 0x0a100000
                            kfdhdb.grpstmp.hi:             32983952 ; 0x0e4: HOUR=0×10 DAYS=0x1c MNTH=0×2 YEAR=0x7dd
                            kfdhdb.grpstmp.lo:           3909777408 ; 0x0e8: USEC=0×0 MSEC=0x29e SECS=0×10 MINS=0x3a
                            kfdhdb.vfstart:                       0 ; 0x0ec: 0×00000000
                            kfdhdb.vfend:                         0 ; 0x0f0: 0×00000000
                            kfdhdb.spfile:                        0 ; 0x0f4: 0×00000000
                            kfdhdb.spfflg:                        0 ; 0x0f8: 0×00000000
                            kfdhdb.ub4spare[0]:                   0 ; 0x0fc: 0×00000000
                            kfdhdb.ub4spare[1]:                   0 ; 0×100: 0×00000000
                            kfdhdb.ub4spare[2]:                   0 ; 0×104: 0×00000000
                            kfdhdb.ub4spare[3]:                   0 ; 0×108: 0×00000000
                            kfdhdb.ub4spare[4]:                   0 ; 0x10c: 0×00000000
                            kfdhdb.ub4spare[5]:                   0 ; 0×110: 0×00000000
                            kfdhdb.ub4spare[6]:                   0 ; 0×114: 0×00000000
                            kfdhdb.ub4spare[7]:                   0 ; 0×118: 0×00000000
                            kfdhdb.ub4spare[8]:                   0 ; 0x11c: 0×00000000
                            kfdhdb.ub4spare[9]:                   0 ; 0×120: 0×00000000
                            kfdhdb.ub4spare[10]:                  0 ; 0×124: 0×00000000
                            kfdhdb.ub4spare[11]:                  0 ; 0×128: 0×00000000
                            kfdhdb.ub4spare[12]:                  0 ; 0x12c: 0×00000000
                            kfdhdb.ub4spare[13]:                  0 ; 0×130: 0×00000000
                            kfdhdb.ub4spare[14]:                  0 ; 0×134: 0×00000000
                            kfdhdb.ub4spare[15]:                  0 ; 0×138: 0×00000000
                            kfdhdb.ub4spare[16]:                  0 ; 0x13c: 0×00000000
                            kfdhdb.ub4spare[17]:                  0 ; 0×140: 0×00000000
                            kfdhdb.ub4spare[18]:                  0 ; 0×144: 0×00000000
                            kfdhdb.ub4spare[19]:                  0 ; 0×148: 0×00000000
                            kfdhdb.ub4spare[20]:                  0 ; 0x14c: 0×00000000
                            kfdhdb.ub4spare[21]:                  0 ; 0×150: 0×00000000
                            kfdhdb.ub4spare[22]:                  0 ; 0×154: 0×00000000
                            kfdhdb.ub4spare[23]:                  0 ; 0×158: 0×00000000
                            kfdhdb.ub4spare[24]:                  0 ; 0x15c: 0×00000000
                            kfdhdb.ub4spare[25]:                  0 ; 0×160: 0×00000000
                            kfdhdb.ub4spare[26]:                  0 ; 0×164: 0×00000000
                            kfdhdb.ub4spare[27]:                  0 ; 0×168: 0×00000000
                            kfdhdb.ub4spare[28]:                  0 ; 0x16c: 0×00000000
                            kfdhdb.ub4spare[29]:                  0 ; 0×170: 0×00000000
                            kfdhdb.ub4spare[30]:                  0 ; 0×174: 0×00000000
                            kfdhdb.ub4spare[31]:                  0 ; 0×178: 0×00000000
                            kfdhdb.ub4spare[32]:                  0 ; 0x17c: 0×00000000
                            kfdhdb.ub4spare[33]:                  0 ; 0×180: 0×00000000
                            kfdhdb.ub4spare[34]:                  0 ; 0×184: 0×00000000
                            kfdhdb.ub4spare[35]:                  0 ; 0×188: 0×00000000
                            kfdhdb.ub4spare[36]:                  0 ; 0x18c: 0×00000000
                            kfdhdb.ub4spare[37]:                  0 ; 0×190: 0×00000000
                            kfdhdb.ub4spare[38]:                  0 ; 0×194: 0×00000000
                            kfdhdb.ub4spare[39]:             254613 ; 0×198: 0x0003e295
                            kfdhdb.ub4spare[40]:                  0 ; 0x19c: 0×00000000
                            kfdhdb.ub4spare[41]:                  0 ; 0x1a0: 0×00000000
                            kfdhdb.ub4spare[42]:                  0 ; 0x1a4: 0×00000000
                            kfdhdb.ub4spare[43]:                  0 ; 0x1a8: 0×00000000
                            kfdhdb.ub4spare[44]:                  0 ; 0x1ac: 0×00000000
                            kfdhdb.ub4spare[45]:                  0 ; 0x1b0: 0×00000000
                            kfdhdb.ub4spare[46]:                  0 ; 0x1b4: 0×00000000
                            kfdhdb.ub4spare[47]:                  0 ; 0x1b8: 0×00000000
                            kfdhdb.ub4spare[48]:                  0 ; 0x1bc: 0×00000000
                            kfdhdb.ub4spare[49]:                  0 ; 0x1c0: 0×00000000
                            kfdhdb.ub4spare[50]:                  0 ; 0x1c4: 0×00000000
                            kfdhdb.ub4spare[51]:                  0 ; 0x1c8: 0×00000000
                            kfdhdb.ub4spare[52]:                  0 ; 0x1cc: 0×00000000
                            kfdhdb.ub4spare[53]:                  0 ; 0x1d0: 0×00000000
                            kfdhdb.acdb.aba.seq:                  0 ; 0x1d4: 0×00000000
                            kfdhdb.acdb.aba.blk:                  0 ; 0x1d8: 0×00000000
                            kfdhdb.acdb.ents:                     0 ; 0x1dc: 0×0000
                            kfdhdb.acdb.ub2spare:             43605 ; 0x1de: 0xaa55

                            The header information was corrupted. kfed output for the disk affected shows 0xaa55 on kfdhdb.acdb.ub2spare field. I backed up the header information using dd command.

                            # dd if=/dev/raw/raw2 of=/tmp/DATA.dd bs=1M count=10

                            I got the allocation unit size of damaged disk.

                            # $GRID_HOME/bin/kfed read /dev/raw/raw2 | grep ausize

                            Now we can repair damaged header information.

                            # $GRID_HOME/bin/kfed repair /dev/raw/raw2 aus=1048576

                            I rechecked the header information of damaged disk using kfed utility. Now, kfed output for the disk affected shows 0×0000 on kfdhdb.acdb.ub2spare field

                            # $GRID_HOME/bin/kfed read /dev/raw/raw2

                            kfbh.endian:                          1 ; 0×000: 0×01
                            kfbh.hard:                          130 ; 0×001: 0×82
                            kfbh.type:                            1 ; 0×002: KFBTYP_DISKHEAD
                            kfbh.datfmt:                          1 ; 0×003: 0×01
                            kfbh.block.blk:                       0 ; 0×004: blk=0
                            kfbh.block.obj:              2147483648 ; 0×008: disk=0
                            kfbh.check:                   945480537 ; 0x00c: 0x385ae359
                            kfbh.fcn.base:                        0 ; 0×010: 0×00000000
                            kfbh.fcn.wrap:                        0 ; 0×014: 0×00000000
                            kfbh.spare1:                          0 ; 0×018: 0×00000000
                            kfbh.spare2:                          0 ; 0x01c: 0×00000000
                            kfdhdb.driver.provstr:ORCLDISK ; 0×000: length=32
                            kfdhdb.driver.reserved[0]:     33686018 ; 0×008: 0×02020202
                            kfdhdb.driver.reserved[1]:     33686018 ; 0x00c: 0×02020202
                            kfdhdb.driver.reserved[2]:     33686018 ; 0×010: 0×02020202
                            kfdhdb.driver.reserved[3]:     33686018 ; 0×014: 0×02020202
                            kfdhdb.driver.reserved[4]:     33686018 ; 0×018: 0×02020202
                            kfdhdb.driver.reserved[5]:     33686018 ; 0x01c: 0×02020202
                            kfdhdb.compat:                186646528 ; 0×020: 0x0b200000
                            kfdhdb.dsknum:                        0 ; 0×024: 0×0000
                            kfdhdb.grptyp:                        1 ; 0×026: KFDGTP_EXTERNAL
                            kfdhdb.hdrsts:                        3 ; 0×027: KFDHDR_MEMBER
                            kfdhdb.dskname:               DATA_0000 ; 0×028: length=9
                            kfdhdb.grpname:                    DATA ; 0×048: length=4
                            kfdhdb.fgname:                DATA_0000 ; 0×068: length=9
                            kfdhdb.capname:                         ; 0×088: length=0
                            kfdhdb.crestmp.hi:             32983952 ; 0x0a8: HOUR=0×10 DAYS=0x1c MNTH=0×2 YEAR=0x7dd
                            kfdhdb.crestmp.lo:           3911025664 ; 0x0ac: USEC=0×0 MSEC=0×361 SECS=0×11 MINS=0x3a
                            kfdhdb.mntstmp.hi:             32984464 ; 0x0b0: HOUR=0×10 DAYS=0xc MNTH=0×3 YEAR=0x7dd
                            kfdhdb.mntstmp.lo:           3973637120 ; 0x0b4: USEC=0×0 MSEC=0×239 SECS=0xd MINS=0x3b
                            kfdhdb.secsize:                     512 ; 0x0b8: 0×0200
                            kfdhdb.blksize:                    4096 ; 0x0ba: 0×1000
                            kfdhdb.ausize:                  1048576 ; 0x0bc: 0×00100000
                            kfdhdb.mfact:                    113792 ; 0x0c0: 0x0001bc80
                            kfdhdb.dsksize:                  512000 ; 0x0c4: 0x0007d000
                            kfdhdb.pmcnt:                         6 ; 0x0c8: 0×00000006
                            kfdhdb.fstlocn:                       1 ; 0x0cc: 0×00000001
                            kfdhdb.altlocn:                       2 ; 0x0d0: 0×00000002
                            kfdhdb.f1b1locn:                      2 ; 0x0d4: 0×00000002
                            kfdhdb.redomirrors[0]:                0 ; 0x0d8: 0×0000
                            kfdhdb.redomirrors[1]:                0 ; 0x0da: 0×0000
                            kfdhdb.redomirrors[2]:                0 ; 0x0dc: 0×0000
                            kfdhdb.redomirrors[3]:                0 ; 0x0de: 0×0000
                            kfdhdb.dbcompat:              168820736 ; 0x0e0: 0x0a100000
                            kfdhdb.grpstmp.hi:             32983952 ; 0x0e4: HOUR=0×10 DAYS=0x1c MNTH=0×2 YEAR=0x7dd
                            kfdhdb.grpstmp.lo:           3909777408 ; 0x0e8: USEC=0×0 MSEC=0x29e SECS=0×10 MINS=0x3a
                            kfdhdb.vfstart:                       0 ; 0x0ec: 0×00000000
                            kfdhdb.vfend:                         0 ; 0x0f0: 0×00000000
                            kfdhdb.spfile:                        0 ; 0x0f4: 0×00000000
                            kfdhdb.spfflg:                        0 ; 0x0f8: 0×00000000
                            kfdhdb.ub4spare[0]:                   0 ; 0x0fc: 0×00000000
                            kfdhdb.ub4spare[1]:                   0 ; 0×100: 0×00000000
                            kfdhdb.ub4spare[2]:                   0 ; 0×104: 0×00000000
                            kfdhdb.ub4spare[3]:                   0 ; 0×108: 0×00000000
                            kfdhdb.ub4spare[4]:                   0 ; 0x10c: 0×00000000
                            kfdhdb.ub4spare[5]:                   0 ; 0×110: 0×00000000
                            kfdhdb.ub4spare[6]:                   0 ; 0×114: 0×00000000
                            kfdhdb.ub4spare[7]:                   0 ; 0×118: 0×00000000
                            kfdhdb.ub4spare[8]:                   0 ; 0x11c: 0×00000000
                            kfdhdb.ub4spare[9]:                   0 ; 0×120: 0×00000000
                            kfdhdb.ub4spare[10]:                  0 ; 0×124: 0×00000000
                            kfdhdb.ub4spare[11]:                  0 ; 0×128: 0×00000000
                            kfdhdb.ub4spare[12]:                  0 ; 0x12c: 0×00000000
                            kfdhdb.ub4spare[13]:                  0 ; 0×130: 0×00000000
                            kfdhdb.ub4spare[14]:                  0 ; 0×134: 0×00000000
                            kfdhdb.ub4spare[15]:                  0 ; 0×138: 0×00000000
                            kfdhdb.ub4spare[16]:                  0 ; 0x13c: 0×00000000
                            kfdhdb.ub4spare[17]:                  0 ; 0×140: 0×00000000
                            kfdhdb.ub4spare[18]:                  0 ; 0×144: 0×00000000
                            kfdhdb.ub4spare[19]:                  0 ; 0×148: 0×00000000
                            kfdhdb.ub4spare[20]:                  0 ; 0x14c: 0×00000000
                            kfdhdb.ub4spare[21]:                  0 ; 0×150: 0×00000000
                            kfdhdb.ub4spare[22]:                  0 ; 0×154: 0×00000000
                            kfdhdb.ub4spare[23]:                  0 ; 0×158: 0×00000000
                            kfdhdb.ub4spare[24]:                  0 ; 0x15c: 0×00000000
                            kfdhdb.ub4spare[25]:                  0 ; 0×160: 0×00000000
                            kfdhdb.ub4spare[26]:                  0 ; 0×164: 0×00000000
                            kfdhdb.ub4spare[27]:                  0 ; 0×168: 0×00000000
                            kfdhdb.ub4spare[28]:                  0 ; 0x16c: 0×00000000
                            kfdhdb.ub4spare[29]:                  0 ; 0×170: 0×00000000
                            kfdhdb.ub4spare[30]:                  0 ; 0×174: 0×00000000
                            kfdhdb.ub4spare[31]:                  0 ; 0×178: 0×00000000
                            kfdhdb.ub4spare[32]:                  0 ; 0x17c: 0×00000000
                            kfdhdb.ub4spare[33]:                  0 ; 0×180: 0×00000000
                            kfdhdb.ub4spare[34]:                  0 ; 0×184: 0×00000000
                            kfdhdb.ub4spare[35]:                  0 ; 0×188: 0×00000000
                            kfdhdb.ub4spare[36]:                  0 ; 0x18c: 0×00000000
                            kfdhdb.ub4spare[37]:                  0 ; 0×190: 0×00000000
                            kfdhdb.ub4spare[38]:                  0 ; 0×194: 0×00000000
                            kfdhdb.ub4spare[39]:                  0 ; 0×198: 0×00000000
                            kfdhdb.ub4spare[40]:                  0 ; 0x19c: 0×00000000
                            kfdhdb.ub4spare[41]:                  0 ; 0x1a0: 0×00000000
                            kfdhdb.ub4spare[42]:                  0 ; 0x1a4: 0×00000000
                            kfdhdb.ub4spare[43]:                  0 ; 0x1a8: 0×00000000
                            kfdhdb.ub4spare[44]:                  0 ; 0x1ac: 0×00000000
                            kfdhdb.ub4spare[45]:                  0 ; 0x1b0: 0×00000000
                            kfdhdb.ub4spare[46]:                  0 ; 0x1b4: 0×00000000
                            kfdhdb.ub4spare[47]:                  0 ; 0x1b8: 0×00000000
                            kfdhdb.ub4spare[48]:                  0 ; 0x1bc: 0×00000000
                            kfdhdb.ub4spare[49]:                  0 ; 0x1c0: 0×00000000
                            kfdhdb.ub4spare[50]:                  0 ; 0x1c4: 0×00000000
                            kfdhdb.ub4spare[51]:                  0 ; 0x1c8: 0×00000000
                            kfdhdb.ub4spare[52]:                  0 ; 0x1cc: 0×00000000
                            kfdhdb.ub4spare[53]:                  0 ; 0x1d0: 0×00000000
                            kfdhdb.acdb.aba.seq:                  0 ; 0x1d4: 0×00000000
                            kfdhdb.acdb.aba.blk:                  0 ; 0x1d8: 0×00000000
                            kfdhdb.acdb.ents:                     0 ; 0x1dc: 0×0000
                            kfdhdb.acdb.ub2spare:                 0 ; 0x1de: 0×0000

                            Now, we can mount DATA diskgroup successfully.

                             

                            Can you please check this link :

                             

                            Mounting ASM Diskgroup Fails With ORA-15063 Error and Resolving With KFED | Talip Hakan Ozturk's ORACLE BLOG

                             

                            Tahnk you

                            • 11. Re: ERROR: diskgroup was not mounted
                              Anar Godjaev

                              Hİ MKeskin

                               

                              I have reviewed your message. Your review right may be....

                              mkeskin wrote:

                               

                              Hi AnarGodjaev,

                               

                              Your solution can be applied  if ASM version is 11.1.0.7 or above. Check support note in my last post.

                               

                              • 12. Re: ERROR: diskgroup was not mounted
                                mkeskin

                                May be ... ??

                                 

                                # $GRID_HOME/bin/kfed repair /dev/raw/raw2 aus=1048576

                                I rechecked the header information of damaged disk using kfed utility. Now, kfed output for the disk affected shows 0×0000 on kfdhdb.acdb.ub2spare field

                                 

                                This is the support note ... Please read carefully ..

                                 

                                If ASM version is 11.1.0.7 or above,

                                $ kfed repair /dev/oracleasm/disks/DATA aus=1048576


                                   If ASM version is less than 11.1.0.7,

                                $ kfed read /dev/oracleasm/disks/DATA text=./DATA.kfed $ kfed write /dev/oracleasm/disks/DATA CHKSUM=YES aus=1048576 text=./DATA.kfed  
                                • 14. Re: ERROR: diskgroup was not mounted
                                  Sami

                                  Hi mkeskin,

                                   

                                  Thanks for your reply.. Sorry for late reply..

                                   

                                  After applying the above step and 1487443.1

                                   

                                  Now header status has been move from PROVISIONED to INCOMPATIBLE  status.


                                  SQL> select  mount_status, header_status,mode_status,state, path from v$asm_disk ;
                                  
                                  
                                  MOUNT_S HEADER_STATU MODE_ST    STATE     PATH
                                  ------------  ---------------     -------------   --------    --------
                                  CLOSED  INCOMPATIBLE  ONLINE     NORMAL /dev/mapper/Rubikon_fb
                                  CACHED  MEMBER          ONLINE    NORMAL /dev/mapper/Rubikon_data1
                                  CACHED  MEMBER       ONLINE        NORMAL  /dev/mapper/Rubikon_data2
                                  
                                  
                                  
                                  
                                  
                                  

                                   

                                  when try to start the ASM it show the following error.

                                   

                                  
                                  SQL> startup
                                  ASM instance started
                                  
                                  
                                  Total System Global Area  130023424 bytes
                                  Fixed Size                  2019032 bytes
                                  Variable Size             102838568 bytes
                                  ASM Cache                  25165824 bytes
                                  ORA-15032: not all alterations performed
                                  ORA-15063: ASM discovered an insufficient number of disks for diskgroup
                                  "FLASH_RECOVERY_AREA"
                                  
                                  
                                  
                                  
                                  

                                   

                                   

                                   

                                   

                                  Kindly help to solve it..

                                  Thanks & Regards

                                  Sami.

                                  1 2 Previous Next