联系：手机/微信(+86 17813235971) QQ(107644445)
标题：obet修复csc higher than block scn类型坏块
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
最近有客户数据库报ORA-01092 ORA-01578错误导致数据库无法open
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
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 # 2123)
ORA-01110: data file 1: '+DATADG/orcl/datafile/system.270.1015415183'
Process ID: 239325
Session ID: 1599 Serial number: 7
通过dbv检查确认是csc higher than block scn故障
DBVERIFY: Release 11.2.0.4.0 - Production on Sat Feb 7 03:47:12 2026
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = +DATADG/orcl/datafile/SYSTEM.270.1015415183
DBV-00200: Block, DBA 4306619, already marked corrupt
csc(0x0006.d75a14f4) higher than block scn(0x0000.00000000)
Page 2123 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 : 1
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 3613010282 (6.3613010282)
对于这样的故障,最近把他整合到了obet工具中,执行命令为repair blkscn [block x]进行修复
C:\Users\XFF>dbv file=H:\TEMP\SYSTEM01.DBF
DBVERIFY: Release 11.2.0.4.0 - Production on 星期日 2月 8 11:07:51 2026
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - 开始验证: FILE = H:\TEMP\SYSTEM01.DBF
csc(0x0012.a0d783c4) higher than block scn(0x0000.00000000)
页 241 失败, 校验代码为 6054
DBVERIFY - 验证完成
检查的页总数: 325120
处理的页总数 (数据): 99921
失败的页总数 (数据): 1
处理的页总数 (索引): 34013
失败的页总数 (索引): 0
处理的页总数 (其他): 174241
处理的总页数 (段) : 1
失败的总页数 (段) : 0
空的页总数: 16945
标记为损坏的总页数: 0
流入的页总数: 0
加密的总页数 : 0
最高块 SCN : 2698836688 (18.2698836688)
使用obet修复csc higher than block scn 故障
OBET> set filename H:\TEMP\SYSTEM01.DBF
filename set to: H:\TEMP\SYSTEM01.DBF
OBET> set block 241
block set to: 241
OBET> set mode edit
mode set to: edit
OBET> repair blkscn
Repairing SCN for block 241...
Current block SCN information:
scn_base: 0x00000000 (0)
scn_wrap: 0x0000 (0)
Block 1 reference information:
hdr_base: 0xA0DCE449 (2698830921)
hdr_wrap: 0x0012 (18)
Current block CSC information:
csc_base: 0xA0D783C4 (2698478532)
csc_wrap: 0x0012 (18)
Calculated values:
blkcsc: 80007889860 (0x00000012A0D783C4)
blkscn: 0 (0x0000000000000000)
blkscn < blkcsc, SCN repair required.
New SCN values to write:
new_scn_base: 0xA0DCE448 (2698830920)
new_scn_wrap: 0x0012 (18)
Confirm SCN repair operations:
File: H:\TEMP\SYSTEM01.DBF
Block: 241
Operations:
1. Write new scn_base (0xA0DCE448)
2. Write new scn_wrap (0x0012)
Confirm? (Y/YES to proceed): y
[Undo information saved - use 'undo' command to restore original values]
Verification after SCN repair:
1. scn_base: 48E4DCA0 (expected: 48E4DCA0)
2. scn_wrap: 1200 (expected: 1200)
3. seq_kcbh: 0x01 OK
Block 241 SCN repair completed successfully.
Execute tailchk apply and sum apply for this block.
OBET> tailchk apply
Confirm applying tailchk:
File: H:\TEMP\SYSTEM01.DBF
Block: 241
Offset in block: 8188 (file offset: 0x001E3FFC)
Original value: 0x01060000
New value: 0x010648E4
Confirm? (Y/YES to proceed): y
Verification successful: Stored tailchk matches calculated value (0x010648E4).
Tailchk applied successfully.
OBET> sum apply
Confirm applying checksum:
File: H:\TEMP\SYSTEM01.DBF
Block: 241
Offset in block: 16 (file offset: 0x001E2010)
Original value: 0xAD0F
New value: 0x63AF
Confirm? (Y/YES to proceed): y
Verification successful: Stored checksum matches calculated value (0x63AF).
Checksum applied successfully.
dbv验证该错误已经修复
C:\Users\XFF>dbv file=H:\TEMP\SYSTEM01.DBF
DBVERIFY: Release 11.2.0.4.0 - Production on 星期日 2月 8 11:11:12 2026
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - 开始验证: FILE = H:\TEMP\SYSTEM01.DBF
DBVERIFY - 验证完成
检查的页总数: 325120
处理的页总数 (数据): 99921
失败的页总数 (数据): 0
处理的页总数 (索引): 34013
失败的页总数 (索引): 0
处理的页总数 (其他): 174241
处理的总页数 (段) : 1
失败的总页数 (段) : 0
空的页总数: 16945
标记为损坏的总页数: 0
流入的页总数: 0
加密的总页数 : 0
最高块 SCN : 2698836688 (18.2698836688)
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。