asm增加磁盘由于Bug19874632导致磁盘块头丢失ORA-15196

文章描述了一次Oracle数据库中磁盘组在进行平衡操作时遇到磁盘故障,导致磁盘组被强制卸载,伴随控制文件错误和ASM缓存读取错误。问题源于一个无效的ASM块头,需要升级到12.2及以上版本进行修复。
摘要由CSDN通过智能技术生成

数据库日志,磁盘组突然被dismount掉:

Tue Apr 02 10:39:15 2024
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lgwr_150319.trc:
ORA-00345: redo log write error block 222293 count 1
ORA-00312: online log 5 thread 1: '+DB/orcl/onlinelog/group_5.266.1018653861'
ORA-15079: ASM file is closed
ORA-15079: ASM file is closed
ORA-00345: redo log write error block 222293 count 1
ORA-00312: online log 5 thread 1: '+DB/orcl/onlinelog/group_5.267.1018653861'
ORA-15079: ASM file is closed
ORA-15079: ASM file is closed
SUCCESS: diskgroup DB was dismounted
SUCCESS: diskgroup DB was dismounted
Tue Apr 02 10:39:16 2024
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ckpt_150321.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '+DB/orcl/controlfile/current.260.1018653857'
ORA-15078: ASM diskgroup was forcibly dismounted
ORA-15078: ASM diskgroup was forcibly dismounted
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '+DB/orcl/controlfile/current.261.1018653857'
ORA-15078: ASM diskgroup was forcibly dismounted
ORA-15078: ASM diskgroup was forcibly dismounted
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ckpt_150321.trc:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '+DB/orcl/controlfile/current.260.1018653857'
ORA-15078: ASM diskgroup was forcibly dismounted
ORA-15078: ASM diskgroup was forcibly dismounted
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '+DB/orcl/controlfile/current.261.1018653857'
ORA-15078: ASM diskgroup was forcibly dismounted
ORA-15078: ASM diskgroup was forcibly dismounted
CKPT (ospid: 150321): terminating the instance due to error 221

asm alert日志,在rebanlence过程中,发生cache read  a corrupt block,导致磁盘组被强制dismount掉:

SQL> ALTER DISKGROUP DB ADD  DISK '/dev/asm-diskm' SIZE 819200M /* ASMCA */ 
NOTE: GroupBlock outside rolling migration privileged region
NOTE: Assigning number (3,3) to disk (/dev/asm-diskm)
NOTE: requesting all-instance membership refresh for group=3
Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_48089.trc:

....

Tue Apr 02 02:06:35 2024
NOTE: membership refresh pending for group 3/0x7a8273b (DB)
Tue Apr 02 02:06:38 2024
GMON querying group 3 at 13 for pid 18, osid 608135
SUCCESS: refreshed membership for 3/0x7a8273b (DB)
NOTE: Attempting voting file refresh on diskgroup DB
NOTE: Refresh completed on diskgroup DB. No voting file found.

.....

Tue Apr 02 02:39:13 2024
WARNING: cache read  a corrupt block: group=3(DB) dsk=2 blk=4 disk=2 (DB_0002) incarn=99145693 au=0 blk=4 count=1
Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_49054.trc:
ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483650] [4] [2359874717 != 2235620521]
NOTE: a corrupted block from group DB was dumped to /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_49054.trc
WARNING: cache read (retry) a corrupt block: group=3(DB) dsk=2 blk=4 disk=2 (DB_0002) incarn=99145693 au=0 blk=4 count=1
Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_49054.trc:
ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483650] [4] [2359874717 != 2235620521]
ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483650] [4] [2359874717 != 2235620521]
ERROR: cache failed to read group=3(DB) dsk=2 blk=4 from disk(s): 2(DB_0002)
ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483650] [4] [2359874717 != 2235620521]
ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483650] [4] [2359874717 != 2235620521]
NOTE: cache initiating offline of disk 2 group DB
NOTE: process _arb0_+asm1 (49054) initiating offline of disk 2.99145693 (DB_0002) with mask 0x7e in group 3
NOTE: initiating PST update: grp = 3, dsk = 2/0x5e8d7dd, mask = 0x6a, op = clear
Tue Apr 02 02:39:13 2024
GMON updating disk modes for group 3 at 14 for pid 39, osid 49054
ERROR: Disk 2 cannot be offlined, since diskgroup has external redundancy.
ERROR: too many offline disks in PST (grp 3)
Tue Apr 02 02:39:13 2024
NOTE: cache dismounting (not clean) group 3/0x07A8273B (DB) 
NOTE: messaging CKPT to quiesce pins Unix process pid: 231667, image: oracle@database01 (B000)
Tue Apr 02 02:39:13 2024
NOTE: halting all I/Os to diskgroup 3 (DB)
Tue Apr 02 02:39:13 2024
NOTE: LGWR doing non-clean dismount of group 3 (DB)
NOTE: LGWR sync ABA=72.2161 last written ABA 72.2161
WARNING: Offline for disk DB_0002 in mode 0x7f failed.
Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_49054.trc  (incident=660793):
ORA-15335: ASM metadata corruption detected in disk group 'DB'
ORA-15130: diskgroup "DB" is being dismounted
ORA-15066: offlining disk "DB_0002" in group "DB" may result in a data loss
ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483650] [4] [2359874717 != 2235620521]
ORA-15196: invalid ASM block header [kfc.c:26368] [check_kfbh] [2147483650] [4] [2359874717 != 2235620521]
Incident details in: /u01/app/grid/diag/asm/+asm/+ASM1/incident/incdir_660793/+ASM1_arb0_49054_i660793.trc

bug文档参考:

Bug 19874632 - ORA-15196: INVALID ASM BLOCK HEADER [KFC.C:26368] [OBJ_KFBL] [8] [529] [3 != 8] (Doc ID 19874632.8)

该问题只能重建磁盘组,要解决这个bug升级到12.2以上版本

  • 28
    点赞
  • 18
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值