0

ASM mount diskgroup报错ORA-15063

问题归档 2019-07-19
57
摘要:mount diskgroup ORA-15063

问题描述

故障日志

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


「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
近期活动
全部
相关课程
全部