联系：手机/微信(+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)
