当前位置： 首页 > news >正文

obet处理ORA-704 ORA-604 ORA-1578故障

news 2026/3/26 18:00:19

有客户数据库启动报ORA-704 ORA-604 ORA-1578错误,导致启动失败

alert日志报错

Fri Feb 06 23:38:43 2026

SMON: enabling cache recovery

Errorsinfile/u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_239325.trc (incident=1008437):

ORA-01578: ORACLE data block corrupted (file# 1, block # 241)

ORA-01110: datafile1:'+DATADG/orcl/datafile/system.270.1015415183'

Fri Feb 06 23:38:46 2026

Redo thread 2 internally disabled atseq6 (CKPT)

Archived Log entry 182212 addedforthread 2 sequence 5 ID 0xd68b4385 dest 1:

ARC0: Archiving disabled thread 2 sequence 6

Archived Log entry 182213 addedforthread 2 sequence 6 ID 0xd68b4385 dest 1:

Thread 1 advanced to log sequence 9 (LGWR switch)

Current log# 1 seq# 9 mem# 0: +DATADG/orcl/onlinelog/group_1.302.1223816761

Current log# 1 seq# 9 mem# 1: +ARCHDG/orcl/onlinelog/group_1.257.1223816761

Errorsinfile/u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_239325.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file# 1, block # 241)

ORA-01110: datafile1:'+DATADG/orcl/datafile/system.270.1015415183'

Errorsinfile/u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_239325.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file# 1, block # 241)

ORA-01110: datafile1:'+DATADG/orcl/datafile/system.270.1015415183'

Error 704 happened during dbopen, shutting down database

USER (ospid: 239325): terminating the instance due to error 704

Fri Feb 06 23:38:48 2026

Instance terminated by USER, pid = 239325

ORA-1092 signalled during: alter databaseopen...

opiodr aborting process unknown ospid (239325) as a result of ORA-1092

Fri Feb 06 23:38:48 2026

ORA-1092 : opitsk aborting process

对system文件进行dbv检测(客户通过asmcmd cp命令拷贝出来system文件)

DBVERIFY - Verification starting : FILE =/asm_backup/orcl/datafile/SYSTEM.270.1015415183

DBV-00200: Block, DBA 4194545, already marked corrupt

csc(0x0006.d75a0ed7) higher than block scn(0x0000.00000000)

Page 241 failed with check code 6054

DBV-00200: Block, DBA 4306619, already marked corrupt

csc(0x0006.d75a14f4) higher than block scn(0x0000.00000000)

Page 112315 failed with check code 6054

DBVERIFY - Verification complete

Total Pages Examined : 738560

Total Pages Processed (Data) : 424109

Total Pages Failing (Data) : 1

Total Pages Processed (Index): 287403

Total Pages Failing (Index): 1

Total Pages Processed (Other): 3408

Total Pages Processed (Seg) : 1

Total Pages Failing (Seg) : 0

Total Pages Empty : 23640

Total Pages Marked Corrupt : 2

Total Pages Influx : 0

Total Pages Encrypted : 0

Highest block SCN : 3613010282 (6.3613010282)

这里可以看到有两个block被标记为坏块原因是由于:csc(0×0006.d75a0ed7) higher than block scn(0×0000.00000000),坏块错误代码为:Page 241 failed with check code 6054.这种问题的原因是由于block的scn小于数据块的csc(一般是由于写丢失导致),对于这个问题,最近在obet中刚刚增加了repair blkscn功能进行修复,具体参考:obet修复csc higher than block scn类型坏块,使用工具修复操作(其他block类似修改)

OBET>setfilename/datapool/asm_backup/orcl/datafile/SYSTEM.270.1015415183

filenamesetto:/datapool/asm_backup/orcl/datafile/SYSTEM.270.1015415183

OBET>setblock 241

blocksetto: 241

OBET> backup

Created backup directory: backup_blk

Successfully backed up current block from currentfileto

/tmp/backup_blk/SYSTEM.270.1015415183_241.20260209122822

OBET> repair blkscn

Repairing SCNforblock 241...

Current block SCN information:

scn_base: 0x00000000 (0)

scn_wrap: 0x0000 (0)

Block 1 reference information:

hdr_base: 0xD75FF65E (3613390430)

hdr_wrap: 0x0006 (6)

Current block CSC information:

csc_base: 0xD75A0ED7 (3613003479)

csc_wrap: 0x0006 (6)

Calculated values:

blkcsc: 29382807255 (0x00000006D75A0ED7)

blkscn: 0 (0x0000000000000000)

blkscn < blkcsc, SCN repair required.

SCN repair requires edit mode.

Pleaseenableedit mode with'set mode edit'first.

OBET>setmode edit

modesetto: edit

OBET> repair blkscn

Repairing SCNforblock 241...

Current block SCN information:

scn_base: 0x00000000 (0)

scn_wrap: 0x0000 (0)

Block 1 reference information:

hdr_base: 0xD75FF65E (3613390430)

hdr_wrap: 0x0006 (6)

Current block CSC information:

csc_base: 0xD75A0ED7 (3613003479)

csc_wrap: 0x0006 (6)

Calculated values:

blkcsc: 29382807255 (0x00000006D75A0ED7)

blkscn: 0 (0x0000000000000000)

blkscn < blkcsc, SCN repair required.

New SCN values to write:

new_scn_base: 0xD75FF65D (3613390429)

new_scn_wrap: 0x0006 (6)

Confirm SCN repair operations:

File:/datapool/asm_backup/orcl/datafile/SYSTEM.270.1015415183

Block: 241

Operations:

1. Write new scn_base (0xD75FF65D)

2. Write new scn_wrap (0x0006)

3. Fix seq_kcbh (0xFF -> 0x01)

Confirm? (Y/YESto proceed): y

[Undo information saved - use'undo'commandto restore original values]

Verification after SCN repair:

1. scn_base: 5DF65FD7 (expected: 5DF65FD7)

2. scn_wrap: 0600 (expected: 0600)

3. seq_kcbh: 0x01 OK

Block 241 SCN repair completed successfully.

Execute tailchk apply andsumapplyforthis block.

OBET> tailchk apply

Confirm applying tailchk:

File:/datapool/asm_backup/orcl/datafile/SYSTEM.270.1015415183

Block: 241

Offsetinblock: 8188 (fileoffset: 0x001E3FFC)

Original value: 0xFF060000

New value: 0x01065DF6

Confirm? (Y/YESto proceed): y

Verification successful: Stored tailchk matches calculated value (0x01065DF6).

Tailchk applied successfully.

OBET>sumapply

Confirm applying checksum:

File:/datapool/asm_backup/orcl/datafile/SYSTEM.270.1015415183

Block: 241

Offsetinblock: 16 (fileoffset: 0x001E2010)

Original value: 0x7330

New value: 0x2AE7

Confirm? (Y/YESto proceed): y

Verification successful: Stored checksum matches calculated value (0x2AE7).

Checksum applied successfully.

然后dbv检查数据文件

[oracle@db4 tmp]$ dbvfile=/datapool/asm_backup/orcl/datafile/SYSTEM.270.1015415183

DBVERIFY: Release 11.2.0.4.0 - Production on Mon Feb 9 20:37:54 2026

Copyright (c) 1982, 2011, Oracle and/orits affiliates. All rights reserved.

DBVERIFY - Verification starting : FILE =

/datapool/asm_backup/orcl/datafile/SYSTEM.270.1015415183

DBVERIFY - Verification complete

Total Pages Examined : 738560

Total Pages Processed (Data) : 424109

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 287403

Total Pages Failing (Index): 1

Total Pages Processed (Other): 3408

Total Pages Processed (Seg) : 1

Total Pages Failing (Seg) : 0

Total Pages Empty : 23640

Total Pages Marked Corrupt : 0

Total Pages Influx : 0

Total Pages Encrypted : 0

Highest block SCN : 3613451063 (6.3613451063)

然后直接顺利打开数据库

SQL>alterdatabaseopen;

Databasealtered.

由于该库在我接手之前已经做了大量的强制拉库等各种恢复尝试,因此对该库做逻辑导出,导入新库完成本次恢复任务

http://www.jsqmd.com/news/366513/

相关文章：

  • 破局南昌流量内卷｜这家代运营公司，如何帮本地商户“躺赢”？ - 野榜数据排行
  • 2026年知识库私有化部署推荐：优质厂商、服务商、方案商推荐 - 品牌2025
  • 2026年省时攻略，GEO服务商推荐，豆包GEO、DeepSeek GEO一键适配不费力 - 品牌2025
  • Java毕设项目推荐-基于springboot的中药科普知识平台的设计与实现中草药科普网站的设计与实现【附源码+文档，调试定制服务】
  • ThingsBoard - 断线后电量累加的解释
  • 记录一次bug：不可见字符/零宽字符
  • 想转AI大模型应用开发按这个顺序学！！从后端转型到AI开发，2026最新！
  • 必收藏！大模型就业前景+入门指南，小白/程序员速看
  • 高中排列组合学案
  • 2026年铅门厂家哪家强？五大优质品牌实力解析推荐 - 深度智识库
  • 第七章-数据验证与异常处理
  • 食品益生菌贴牌 2026年怎么选靠谱厂家?精选TOP2实力源头工厂 - 博客万
  • 2026年可靠的ISO14001认证材料,SO14001认证公司行业精选名录 - 品牌鉴赏师
  • 第九章-日志与审计
  • rocky8安装docker
  • 第八章-安全授权与身份认证
  • 适配注液设备：2026优选超声波流量计品牌推荐 - 品牌2025
  • ue的资源管理
  • 2026知识库部署方案商实力推荐清单 - 品牌2025
  • 2026年可靠的制造业ISO27001认证,简易ISO27001认证公司采购优选榜单 - 品牌鉴赏师
  • 2026年GEO服务新趋势：DeepSeek GEO合作伙伴推荐全解析 - 品牌2025
  • 第十章-缓存管理
  • 2026年专业的企业诚信管理体系认证,职业健康安全管理体系认证公司采购优选名录 - 品牌鉴赏师
  • 编写语言交友APP,根据用户想学习的语言（英语/韩语/日语/法语），匹配母语者/学习者，支持在线语音/文字交流，互相学习语言，结识外国朋友。
  • TikTok海外营销推广服务商推荐：助力制造业与三轮车、摩托车行业突破欧美市场 - 品牌2025
  • 第六章-数据库操作与EF-Core集成
  • 第十一章-事件总线
  • 2026年制造业海外社媒代运营服务商精选（涵盖 Facebook、LinkedIn 领英、TikTok 、Google、INS营销推广获客解决方案） - 品牌2025
  • 真心不骗你!千笔AI，断层领先的降AI率工具
  • 2026年南美（巴西、哥伦比亚、智利）海外名义雇主（EOR）服务商推荐：合规拓展拉美市场的关键伙伴 - 品牌2025