暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ASM mount diskgroup报错ORA-15063

原创 问题归档 2019-07-19
1302

问题描述

故障日志

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

MEMBER        属于当前diskgroup的disk

FORMER        这个disk以前属于一个diskgroup,现在这个diskgroup被删除了

CANDIDATE        当使用裸设备,一个新的可以被diskgroup所用的disk

PROVISIONED        当使用asmlib,一个新的可以被diskgroup所用的disk

[grid@oradb1 ~]$ kfed read /dev/oracleasm/disks/DGBAK | head -25
kfbh.endian:                          1 ; 0x000: 0x01
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt:                          1 ; 0x003: 0x01
kfbh.block.blk:                       0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj:              2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check:                  3099589087 ; 0x00c: 0xb8bff9df
kfbh.fcn.base:                        0 ; 0x010: 0x00000000
kfbh.fcn.wrap:                        0 ; 0x014: 0x00000000
kfbh.spare1:                          0 ; 0x018: 0x00000000
kfbh.spare2:                          0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr:    ORCLDISKDGBAK ; 0x000: length=13
kfdhdb.driver.reserved[0]:   1094862660 ; 0x008: 0x41424744
kfdhdb.driver.reserved[1]:           75 ; 0x00c: 0x0000004b
kfdhdb.driver.reserved[2]:            0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]:            0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]:            0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]:            0 ; 0x01c: 0x00000000
kfdhdb.compat:                186646528 ; 0x020: 0x0b200000
kfdhdb.dsknum:                        0 ; 0x024: 0x0000
kfdhdb.grptyp:                        1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts:                        4 ; 0x027: KFDHDR_FORMER
kfdhdb.dskname:                   DGBAK ; 0x028: length=5
kfdhdb.grpname:                   DGBAK ; 0x048: length=5
kfdhdb.fgname:                    DGBAK ; 0x068: length=5


专家解答

通过KDED 修改状态

[grid@oradb1 ~]$ kfed read /dev/oracleasm/disks/DGBAK | grep KFDHDR
kfdhdb.hdrsts:                        3 ; 0x027: KFDHDR_MEMBER
 
SQL> alter  diskgroup dgbak mount;
Diskgroup altered.
SQL>
SQL> select  group_number,name,state from v$asm_diskgroup;
GROUP_NUMBER NAME                           STATE
------------ ------------------------------ -----------
          1 DATA                           MOUNTED
          2 DGBAK                          MOUNTED
          3 ORADATA                        MOUNTED


「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论