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

推荐订阅源

T
Threat Research - Cisco Blogs
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
月光博客
月光博客
V
Vulnerabilities – Threatpost
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
S
Secure Thoughts
Microsoft Azure Blog
Microsoft Azure Blog
Blog — PlanetScale
Blog — PlanetScale
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
T
Tailwind CSS Blog
S
SegmentFault 最新的问题
钛媒体：引领未来商业与生活新知
钛媒体：引领未来商业与生活新知
云风的 BLOG
云风的 BLOG
The Last Watchdog
The Last Watchdog
L
LINUX DO - 热门话题
酷 壳 – CoolShell
酷 壳 – CoolShell
WordPress大学
WordPress大学
AWS News Blog
AWS News Blog
美
美团技术团队
G
Google Developers Blog
宝玉的分享
宝玉的分享
www.infosecurity-magazine.com
www.infosecurity-magazine.com
C
CXSECURITY Database RSS Feed - CXSecurity.com
Recent Commits to openclaw:main
Recent Commits to openclaw:main
I
InfoQ
小众软件
小众软件
Google DeepMind News
Google DeepMind News
P
Privacy & Cybersecurity Law Blog
Stack Overflow Blog
Stack Overflow Blog
Webroot Blog
Webroot Blog
D
DataBreaches.Net
IT之家
IT之家
PCI Perspectives
PCI Perspectives
人人都是产品经理
人人都是产品经理
Hacker News: Ask HN
Hacker News: Ask HN
L
LangChain Blog
SecWiki News
SecWiki News
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
C
Cisco Blogs
T
Threatpost
P
Proofpoint News Feed
Y
Y Combinator Blog
Cloudbric
Cloudbric
T
Tor Project blog
量
量子位
博
博客园_首页
B
Blog
Hugging Face - Blog
Hugging Face - Blog
GbyAI
GbyAI
D
Darknet – Hacking Tools, Hacker News & Cyber Security

博客园 - 惜分飞

使用deepseek进行Oracle恢复,引起重大故障---惜分飞 硬件故障后数据文件大小不对故障处理—Oracle碎片扫描恢复 1.5T MySQL数据库完美恢复---惜分飞 一次断电引起的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阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。