问题描述
故障日志
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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。