惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

S
Secure Thoughts
T
Threatpost
V
Vulnerabilities – Threatpost
Recorded Future
Recorded Future
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
P
Proofpoint News Feed
Spread Privacy
Spread Privacy
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
量
量子位
Engineering at Meta
Engineering at Meta
Project Zero
Project Zero
Jina AI
Jina AI
雷峰网
雷峰网
T
ThreatConnect
E
Exploit-DB.com RSS Feed
T
True Tiger Recordings
Y
Y Combinator Blog
C
Cyber Attacks, Cyber Crime and Cyber Security
GbyAI
GbyAI
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
T
Tenable Blog
小众软件
小众软件
aimingoo的专栏
aimingoo的专栏
S
SegmentFault 最新的问题
CTFtime.org: upcoming CTF events
CTFtime.org: upcoming CTF events
M
MIT News - Artificial intelligence
M
Microsoft Research Blog - Microsoft Research
U
Unit 42
L
LINUX DO - 热门话题
C
Cybersecurity and Infrastructure Security Agency CISA
I
InfoQ
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
Recent Commits to openclaw:main
Recent Commits to openclaw:main
WordPress大学
WordPress大学
人人都是产品经理
人人都是产品经理
F
Fortinet All Blogs
Google DeepMind News
Google DeepMind News
C
Check Point Blog
Malwarebytes
Malwarebytes
T
Threat Research - Cisco Blogs
The GitHub Blog
The GitHub Blog
D
Docker
www.infosecurity-magazine.com
www.infosecurity-magazine.com
Blog — PlanetScale
Blog — PlanetScale
T
The Exploit Database - CXSecurity.com
SecWiki News
SecWiki News
B
Blog RSS Feed
F
Future of Privacy Forum
罗
罗磊的独立博客
Scott Helme
Scott Helme

博客园 - 惜分飞

一次断电引起的Oracle故障恢复-ora-600 2662故障---惜分飞 Oracle故障第一现场被恢复混乱的数据库恢复--惜分飞 - 惜分飞 OraScan （Oracle碎片扫描工具）使用说明 imp导入dmp报IMP-00098: INTERNAL ERROR: impgst2故障处理 记录一次win删除数据文件完美恢复案例 - 惜分飞 国产信创库fio破坏主备库以及备份故障处理--惜分飞 .wman扩展名勒索mysql数据库恢复 - 惜分飞 Oracle数据库被勒索加密一键open工具–OraFHR rose双机引起文件系统损坏导致数据库异常故障处理---惜分飞 ORA-704 ORA-604 ORA-1578故障处理 csc(0x0006.d75a14f4) higher than block scn(0x0000.00000000)--故障处理--obet ORA-600 kcratr_nab_less_than_odr和ORA-600 4193故障处理---惜分飞 aix环境10g由于控制器异常导致ORA-600 4000故障处理---惜分飞 不当恢复truncate数据导致数据库不能open处理 在生产环境错误执行dd命令破坏asm磁盘故障恢复---惜分飞 Patch_SCN快速解决ORA-600 2663故障 obet实现对数据文件坏块检测功能（obet dbv） obet快速修改scn/resetlogs恢复数据库(缺少归档,ORA-00308） sql server 事务日志备份异常恢复案例---惜分飞 linux异常磁盘lvm恢复---惜分飞 win平台挂起Oracle数据库启动进程 expdp dmp 导出不完整导入ORA-39059 ORA-39246 故障抢救数据 mysql drop database 无有效备份恢复思路 mysql drop database 无法备份恢复思路
asm dd 10M导致system文件部分坏块修复---惜分飞
惜分飞 · 2026-05-23 · via 博客园 - 惜分飞

算幸运,由于ORA-15196: invalid ASM block header [kfc.c:30747] [endian_kfbh] 错误导致rebalance没有真正运行起来,从而该磁盘组没有dismount(19c这个方面确实增强不少,如果以前版本大概率会直接dismount掉)

客户在这样mount的磁盘组上尝试启动库,报ORA-01578错误,无法启动成功

2026-05-20T17:46:07.060794+08:00

Error attempting to elevate LMHB's priority: no further priority changes will be attempted for this process

2026-05-20T17:46:07.647114+08:00

Undo initialization recovery: Parallel FPTR complete: start:26091908 end:26096229 diff:4321 ms (4.3 seconds)

Undo initialization recovery: err:0 start: 26091907 end: 26096229 diff: 4322 ms (4.3 seconds)

[50880] Successfully onlined Undo Tablespace 5.

Undo initialization online undo segments: err:0 start: 26096229 end: 26096576 diff: 347 ms (0.3 seconds)

Undo initialization finished serial:0 start:26091907 end:26096591 diff:4684 ms (4.7 seconds)

Database Characterset is AL32UTF8

No Resource Manager plan active

2026-05-20T17:46:08.734113+08:00

Corrupt block relative dba: 0x004030ee (file 1, block 12526)

Completely zero block found during buffer read

Reread (file 1, block 12526) found same corrupt data (no logical check)

2026-05-20T17:46:08.811455+08:00

Corrupt Block Found

         TIME STAMP (GMT) = 05/20/2026 17:46:07

         CONT = 0, TSN = 0, TSNAME = SYSTEM

         RFN = 1, BLK = 12526, RDBA = 4206830

         OBJN = 37, OBJD = 37, OBJECT = I_OBJ2, SUBOBJECT =

         SEGMENT OWNER = SYS, SEGMENT TYPE = Index Segment

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc  (incident=800708):

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

2026-05-20T05:46:09.047772-04:00

ALTER SYSTEM SET remote_listener=' xff-scan:11521' SCOPE=MEMORY SID='xff2';

2026-05-20T05:46:09.049615-04:00

ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='xff2';

2026-05-20T17:46:09.812271+08:00

*****************************************************************

An internal routine has requested a dump of selected redo.

This usually happens following a specific internal error, when

analysis of the redo logs will help Oracle Support with the

diagnosis.

It is recommended that you retain all the redo logs generated (by

all the instances) during the past 12 hours, in case additional

redo dumps are required to help with the diagnosis.

*****************************************************************

Corrupt block relative dba: 0x004030de (file 1, block 12510)

Completely zero block found during buffer read

Reread (file 1, block 12510) found same corrupt data (no logical check)

2026-05-20T17:46:10.350573+08:00

Corrupt Block Found

         TIME STAMP (GMT) = 05/20/2026 17:46:09

         CONT = 0, TSN = 0, TSNAME = SYSTEM

         RFN = 1, BLK = 12510, RDBA = 4206814

         OBJN = 83, OBJD = 83, OBJECT = DEPENDENCY$, SUBOBJECT =

         SEGMENT OWNER = SYS, SEGMENT TYPE = Table Segment

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc  (incident=800709):

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

2026-05-20T17:46:10.694365+08:00

Corrupt block relative dba: 0x00403000 (file 1, block 12288)

Completely zero block found during validation

Reread of blocknum=12288, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12288, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12288, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12288, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12288, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Corrupt block relative dba: 0x00403001 (file 1, block 12289)

Completely zero block found during validation

Reread of blocknum=12289, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12289, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12289, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12289, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12289, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

………………

Corrupt block relative dba: 0x004030ff (file 1, block 12543)

Completely zero block found during validation

Reread of blocknum=12543, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12543, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12543, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12543, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Reread of blocknum=12543, file=+DATA/xff/DATAFILE/system.257.1186720165. found same corrupt data

Corrupt block relative dba: 0x0040301d (file 1, block 12317)

Completely zero block found during buffer read

Reread (file 1, block 12317) found same corrupt data (no logical check)

2026-05-20T17:46:12.183545+08:00

Corrupt Block Found

         TIME STAMP (GMT) = 05/20/2026 17:46:11

         CONT = 0, TSN = 0, TSNAME = SYSTEM

         RFN = 1, BLK = 12317, RDBA = 4206621

         OBJN = 37, OBJD = 37, OBJECT = I_OBJ2, SUBOBJECT =

         SEGMENT OWNER = SYS, SEGMENT TYPE = Index Segment

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc  (incident=800710):

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

Incident details in: /u01/app/oracle/diag/rdbms/xff/xff2/incident/incdir_800710/xff2_ora_50880_i800710.trc

2026-05-20T05:46:12.371040-04:00

ALTER SYSTEM SET remote_listener=' xff-scan:11521' SCOPE=MEMORY SID='xff2';

2026-05-20T05:46:12.372924-04:00

ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='xff2';

2026-05-20T17:46:13.814346+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

2026-05-20T17:46:13.814407+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

2026-05-20T17:46:13.814442+08:00

Error 604 happened during db open, shutting down database

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc  (incident=800711):

ORA-00603: ORACLE server session terminated by fatal error

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

Corrupt block relative dba: 0x00403097 (file 1, block 12439)

Completely zero block found during buffer read

Reread (file 1, block 12439) found same corrupt data (no logical check)

2026-05-20T17:46:14.259044+08:00

Corrupt Block Found

         TIME STAMP (GMT) = 05/20/2026 17:46:13

         CONT = 0, TSN = 0, TSNAME = SYSTEM

         RFN = 1, BLK = 12439, RDBA = 4206743

         OBJN = 18, OBJD = 18, OBJECT = OBJ$, SUBOBJECT =

         SEGMENT OWNER = SYS, SEGMENT TYPE = Table Segment

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_gen0_48604.trc  (incident=798852):

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

2026-05-20T17:46:13.814346+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

2026-05-20T17:46:13.814407+08:00

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

2026-05-20T17:46:13.814442+08:00

Error 604 happened during db open, shutting down database

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_50880.trc  (incident=800711):

ORA-00603: ORACLE server session terminated by fatal error

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

Corrupt block relative dba: 0x00403097 (file 1, block 12439)

Completely zero block found during buffer read

Reread (file 1, block 12439) found same corrupt data (no logical check)

2026-05-20T17:46:14.259044+08:00

Corrupt Block Found

         TIME STAMP (GMT) = 05/20/2026 17:46:13

         CONT = 0, TSN = 0, TSNAME = SYSTEM

         RFN = 1, BLK = 12439, RDBA = 4206743

         OBJN = 18, OBJD = 18, OBJECT = OBJ$, SUBOBJECT =

         SEGMENT OWNER = SYS, SEGMENT TYPE = Table Segment

Errors in file /u01/app/oracle/diag/rdbms/xff/xff2/trace/xff2_gen0_48604.trc  (incident=798852):

ORA-01578: ORACLE data block corrupted (file

ORA-01110: data file 1: '+DATA/xff/DATAFILE/system.257.1186720165'

2026-05-20T05:46:14.436597-04:00

ALTER SYSTEM SET remote_listener=' xff-scan:11521' SCOPE=MEMORY SID='xff2';

2026-05-20T05:46:14.438492-04:00

ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='xff2';

2026-05-20T17:46:15.486758+08:00

opiodr aborting process unknown ospid (50880) as a result of ORA-603

2026-05-20T17:46:15.498707+08:00

ORA-603 : opitsk aborting process

License high water mark = 423

USER(prelim) (ospid: 50880): terminating the instance due to ORA error 604

2026-05-20T17:46:15.536740+08:00

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

2026-05-20T05:46:16.321597-04:00

ORA-1092 : opitsk aborting process

256个连续的全0坏块,怀疑是2M的数据被dd全空覆盖,这样的情况,也就是怀疑是au=2的后面2M被覆盖(ausize为4M),分析system的数据分布情况
au
这里可以确认system的第24个au(从0开始)在14号盘au 2 上面,也就是数据块起始损坏为block：12288-12543（24M*4/8K[有block 0 需要考虑])，对于这种彻底损坏而且比较靠前的system中block,通过人工构造出来这些block的方式进行修复,在自研的Oracle Recovery Tools和obet工具都有该功能.运气不错,通过这个修复之后,直接expdp导出数据没有大问题,比较完美的恢复了这个故障.

此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。