数据库日志,磁盘组突然被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日志,增加磁盘过程中 cache read a corrupt block,块损坏: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以上版本
asm增加磁盘由于Bug19874632导致磁盘块头丢失ORA-15196
来源:这里教程网
时间:2026-03-03 19:51:41
作者:
编辑推荐:
- 不是我说,这玩意也叫高可用?03-03
- asm增加磁盘由于Bug19874632导致磁盘块头丢失ORA-1519603-03
- auto space advisor导致ogg进程异常(OGG-00458)03-03
- OGG 跳过当前事务的几种方法03-03
- OGG DDL安装和卸载03-03
- OGG-01705 报错处理03-03
- rac数据库默认网关不通导致集群异常03-03
- OGG 捕获truncate操作03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- auto space advisor导致ogg进程异常(OGG-00458)
- OGG-01705 报错处理
OGG-01705 报错处理
26-03-03 - rac数据库默认网关不通导致集群异常
rac数据库默认网关不通导致集群异常
26-03-03 - rac数据库宕机重启未生成日志
rac数据库宕机重启未生成日志
26-03-03 - 一次ogg挖掘导致的生产故障
一次ogg挖掘导致的生产故障
26-03-03 - [20240328]为什么找不到执行计划.txt
[20240328]为什么找不到执行计划.txt
26-03-03 - oracle分布式事务异常处理方法
oracle分布式事务异常处理方法
26-03-03 - sqlhc的介绍和使用
sqlhc的介绍和使用
26-03-03 - Oracle 23C 新特征一JSON关系二元性
Oracle 23C 新特征一JSON关系二元性
26-03-03 - Oracle 23C 新特征- True Cache
Oracle 23C 新特征- True Cache
26-03-03
