This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Oct 4, 2013 6:18 AM by Sami RSS

ERROR: diskgroup was not mounted

Sami Newbie
Currently Being Moderated

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 Explorer
    Currently Being Moderated

    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 Expert
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Expert
    Currently Being Moderated

    hmmm it is very interesting  

     

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

     

     

    Thank you

  • 5. Re: ERROR: diskgroup was not mounted
    mkeskin Explorer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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)

  • 10. Re: ERROR: diskgroup was not mounted
    mkeskin Explorer
    Currently Being Moderated

    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 Expert
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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  
  • 13. Re: ERROR: diskgroup was not mounted
    Anar Godjaev Expert
    Currently Being Moderated

  • 14. Re: ERROR: diskgroup was not mounted
    Sami Newbie
    Currently Being Moderated

    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points