首页 > 其他分享 >asm增加磁盘由于Bug19874632导致磁盘块头丢失ORA-15196

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

时间:2024-04-07 09:30:58浏览次数:24  
标签:15196 group DB block file 磁盘 ASM ORA

数据库日志,磁盘组突然被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以上版本

标签:15196,group,DB,block,file,磁盘,ASM,ORA
From: https://blog.csdn.net/lmxx2020/article/details/137275011

相关文章

  • Oracle之DBMS_LOCK包用法详解
    概述与背景某些并发程序,在高并发的情况下,必须控制好并发请求的运行时间和次序,来保证处理数据的正确性和完整性。对于并发请求的并发控制,EBS系统可以通过ConcurrentProgram定义界面的Incompatibilities功能配置实现。但是Incompatibilities功能存在其局限性,它只能把整个并发请求......
  • android 【存储相关】preserveLegacyExternalStorage,requestLegacyExternalStorage
    这两个属性是与Android10(API级别29)及更高版本中的外部存储访问权限限制相关的属性。android:preserveLegacyExternalStorage="true"这个属性用于在Android10及更高版本上保留旧版的外部存储访问模式。在Android10及更高版本中,默认情况下,应用程序只能访问自己......
  • Typora 使用中的几个问题
    一、切换源代码模式快捷键修改:文件---偏好设置---通用---高级设置---打开高级设置,会打开C:\Users\Administrator\AppData\Roaming\Typora\conf目录,打开里面的conf.user.json文件,在keyBinding属性下,添加"源代码模式":"Ctrl+`",即可修改快捷键。二、编辑界面两边的空白:源......
  • Typora
    markdown的使用说明一、标题语法:#(一级标题)##(二级标题)###(三级标题)。。。。代码:#这是一级标题##这是二级标题效果:这是一个一级标题这是二级标题快捷键:Ctrl+数字1-6可以快速将选中的文本调成对应级别的标题Ctrl+0可以将选中的文本调成普通文本Ct......
  • ubuntu20.04.6将虚拟机用户目录映射为磁盘Z
    文章目录linux虚拟机设置为NAT模式安装sshd服务映射目录到windows磁盘安装samba套件修改配置文件smb.conf重启smbd并设置用户名和密码windows映射遇到的问题1、设置好之后映射不成功2、smbd下载失败3、smbd密码配置问题4、当有改动时候,最好重启一下smbd服务linux虚......
  • 开源模型应用落地-qwen1.5-7b-chat-LoRA微调代码拆解
    一、前言  本篇文章将解析QWen1.5系列模型的微调代码,帮助您理解其中的关键技术要点。通过阅读本文,您将能够更好地掌握这些关键技术,并应用于自己的项目中。   开源模型应用落地-qwen1.5-7b-chat-LoRA微调(二)二、术语介绍2.1.LoRA微调  LoRA(Low-RankAdap......
  • Typora添加鼠标右键新建md文件
    2024年4月6日博客园发布默认路径安装Typora在桌面新建一个.txt文件,并复制以下代码WindowsRegistryEditorVersion5.00[HKEY_CLASSES_ROOT\.md]@="markdown"[HKEY_CLASSES_ROOT\.md\ShellNew]"NullFile"=""[HKEY_CLASSES_ROOT\markdown]@="Bla......
  • 在Linux中,如何检查磁盘使用情况和剩余空间?
    在Linux系统中,检查磁盘使用情况和剩余空间是系统管理和维护的常见任务。有多种命令可以帮助你获取磁盘空间的详细信息。以下是一些常用的方法:1.df命令df(DiskFree)命令用于显示文件系统的磁盘空间使用情况。它可以报告各个挂载点的总空间、已用空间、可用空间和挂载信息。基本......
  • linux创建新分区扩展磁盘空间
    sudofdisk/dev/sda在fdisk中按下n键创建新分区。选择分区类型(通常是主分区)并输入默认的分区编号4。确保新分区的起始扇区是/dev/sda3结束的下一个扇区。设置分区结束扇区为默认值以占用剩余的空间。将分区类型设置为LVM或者其他你需要的文件系统类型。保存并退......
  • P10238 [yLCPC2024] F. PANDORA PARADOXXX
    P10238[yLCPC2024]F.PANDORAPARADOXXX并查集维护连通性+结论+数据结构维护距离题目的操作是删边通常复杂,并且不强制在线,所以离线倒过来加边。题目要求的就是当前所有连通块的直径的最大值,考虑加边后两个连通块合并后直径的变化。有结论:合并后的连通块的直径两端点一定是合......