ORA-15196: invalid ASM block header----惜分飞

数据库遭遇ASM磁盘组DATA在启动时自动卸载的问题,日志显示数据块损坏导致COD恢复失败。问题源于逻辑坏块,影响到redo log文件的打开,最终导致实例异常关闭。解决策略包括应用ASM补丁稳定mount,安全迁移数据,实现无数据丢失的恢复。

客户反馈,数据库无法正常启动,通过分析asm的alert日志发现,data磁盘组mount成功之后,没有一会儿自动dismount掉

Mon Sep 26 16:40:14 2022

SQL> /* ASMCMD */ALTER DISKGROUP data MOUNT 

NOTE: cache registered group DATA number=2 incarn=0x9dfa705f

NOTE: cache began mount (first) of group DATA number=2 incarn=0x9dfa705f

NOTE: Assigning number (2,1) to disk (/dev/oracleasm/disks/DATA02)

NOTE: Assigning number (2,0) to disk (/dev/oracleasm/disks/DATA01)

Mon Sep 26 16:40:20 2022

NOTE: GMON heartbeating for grp 2

GMON querying group 2 at 68 for pid 25, osid 14650

NOTE: cache opening disk 0 of grp 2: DATA_0000 path:/dev/oracleasm/disks/DATA01

NOTE: F1X0 found on disk 0 au 2 fcn 0.0

NOTE: cache opening disk 1 of grp 2: DATA_0001 path:/dev/oracleasm/disks/DATA02

NOTE: cache mounting (first) external redundancy group 2/0x9DFA705F (DATA)

Mon Sep 26 16:40:20 2022

* allocate domain 2, invalid = TRUE

kjbdomatt send to inst 2

Mon Sep 26 16:40:20 2022

NOTE: attached to recovery domain 2

NOTE: cache recovered group 2 to fcn 0.321845

NOTE: redo buffer size is 256 blocks (1053184 bytes)

Mon Sep 26 16:40:20 2022

NOTE: LGWR attempting to mount thread 1 for diskgroup 2 (DATA)

NOTE: LGWR found thread 1 closed at ABA 20.3546

NOTE: LGWR mounted thread 1 for diskgroup 2 (DATA)

NOTE: LGWR opening thread 1 at fcn 0.321845 ABA 21.3547

NOTE: cache mounting group 2/0x9DFA705F (DATA) succeeded

NOTE: cache ending mount (success) of group DATA number=2 incarn=0x9dfa705f

Mon Sep 26 16:40:20 2022

NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2

SUCCESS: diskgroup DATA was mounted

SUCCESS: /* ASMCMD */ALTER DISKGROUP data MOUNT

Mon Sep 26 16:40:22 2022

WARNING: failed to online diskgroup resource ora.DATA.dg (unable to communicate with CRSD/OHASD)

Mon Sep 26 16:40:47 2022

NOTE: client xff1:xff registered, osid 14742, mbr 0x0

Mon Sep 26 16:40:57 2022

WARNING: cache read  a corrupt block: group=2(DATA) dsk=1 blk=257 disk=1 (DATA_0001)

incarn=3916071178 au=113792 blk=1 count=1

Errors in file /opt/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_14778.trc:

ORA-15196: invalid ASM block header [kfc.c:26368] [endian_kfbh] [2147483649] [257] [0 != 1]

NOTE: a corrupted block from group DATA was dumped to /opt/grid/diag/asm/+asm

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值