news 2026/6/10 14:40:43

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

作者头像

张小明

前端开发工程师

1.2k 24
文章封面图
obet处理ORA-704 ORA-604 ORA-1578故障

有客户数据库启动报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.

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

版权声明: 本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若内容造成侵权/违法违规/事实不符，请联系邮箱：809451989@qq.com进行投诉反馈，一经查实，立即删除！
网站建设 2026/5/22 19:24:45

改进的USBASP模块

简 介&#xff1a; 本文介绍了改进版USBASP下载模块的制作过程。主要改进包括&#xff1a;将12MHz晶体改为表贴式以缩小体积&#xff0c;增加独立负载电源接口&#xff0c;在USB D-线添加上拉电阻使Mega8可识别为低速USB模式&#xff0c;优化跳线设计实现单面PCB制作。通过一分…

作者头像 李华
网站建设 2026/6/9 21:31:07

AI4Science的前沿公司：Polymathic AI

1. 摘要 在当前的人工智能&#xff08;AI&#xff09;浪潮中&#xff0c;公众与市场的目光往往聚焦于以大语言模型&#xff08;LLM&#xff09;为代表的生成式 AI&#xff0c;其商业逻辑通常围绕“软件即服务”&#xff08;SaaS&#xff09;或API调用的变现模式展开。然而&…

作者头像 李华
网站建设 2026/6/10 10:58:05

1.2 一句话说清 Agent 和普通程序到底差在哪

1.2 一句话说清：Agent 和普通程序到底差在哪 本节学习目标 用一句话精确定义 Agent，并能向他人解释清楚。 掌握 Agent 的四大核心属性：自主感知、决策、行动、目标导向。 能区分「传统程序 / 传统自动化」与「Agent」，避免概念混淆。 一、一句话定义 一句话：Agent 是在给…

作者头像 李华
网站建设 2026/6/10 10:55:40

第1章 程序点滴程序点滴-1.1 程序≠软件(2)

1.1.2 认清自己的发展如果连以上认识都不清楚&#xff0c;很可能就以为去书店买一本MFC高手速成之类的书&#xff0c;编两个程序就能成为软件高手。就好像这些书是“黄金”&#xff0c;我学两下&#xff0c;学会了VC、MFC&#xff0c;就能做一个软件拿出去卖了。这种想法也不是…

作者头像 李华
网站建设 2026/6/10 11:00:54

【课程设计/毕业设计】基于springboot的零食售货机管理系统的设计与实现商品管理、购买管理【附源码、数据库、万字文档】

博主介绍&#xff1a;✌️码农一枚 &#xff0c;专注于大学生项目实战开发、讲解和毕业&#x1f6a2;文撰写修改等。全栈领域优质创作者&#xff0c;博客之星、掘金/华为云/阿里云/InfoQ等平台优质作者、专注于Java、小程序技术领域和毕业项目实战 ✌️技术范围&#xff1a;&am…

作者头像 李华