csc higher than block scn类型坏块修复
惜分飞发表于 2016-05-14 15:01:51
联系：手机(13429648788) QQ(107644445)
标题：csc higher than block scn类型坏块修复
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
数据库虽然正常open了，但是由于system有坏块，导致数据库导出有部分表报错，客户希望通过修复坏块完美解决该问题
bbed检查system报坏块
C:\Users\FAL>dbv file=D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF DBVERIFY: Release 11.2.0.1.0 - Production on 星期六 5月 14 15:40:55 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. DBVERIFY - 开始验证: FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF csc(0x0000.1f8adab3) higher than block scn(0x0000.00000000) 页 122146 失败, 校验代码为 6054 DBVERIFY - 验证完成 检查的页总数: 252160 处理的页总数 (数据): 178921 失败的页总数 (数据): 0 处理的页总数 (索引): 52576 失败的页总数 (索引): 1 处理的页总数 (其他): 3201 处理的总页数 (段) : 1 失败的总页数 (段) : 0 空的页总数: 17462 标记为损坏的总页数: 0 流入的页总数: 0 加密的总页数 : 0 最高块 SCN : 529420540 (0.529420540)
bbed修复坏块
C:\Users\FAL>bbed password=blockedit filename=D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF
BBED: Release 2.0.0.0.0 - Limited Production on Sat May 14 15:37:01 2016
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> set blocksize 8192
BLOCKSIZE 8192
BBED> set block 2
BLOCK# 2
BBED> map
File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0)
Block: 2 Dba:0x00000000
------------------------------------------------------------
Data File Header
struct kcvfh, 360 bytes @0
ub4 tailchk @8188
BBED> set block 122147
BLOCK# 122147
BBED> map
File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0)
Block: 122147 Dba:0x00000000
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 3720 bytes @20
struct kdxle, 32 bytes @3740
b2 kd_off[188] @3772
ub1 freespace[1534] @4148
ub1 rowdata[2442] @5682
ub4 tailchk @8188
BBED> p kcbh
struct kcbh, 20 bytes @0
ub1 type_kcbh @0 0x06
ub1 frmt_kcbh @1 0xa2
ub1 spare1_kcbh @2 0x00
ub1 spare2_kcbh @3 0x00
ub4 rdba_kcbh @4 0x0041dd22
ub4 bas_kcbh @8 0x00000000
ub2 wrp_kcbh @12 0x0000
ub1 seq_kcbh @14 0xff
ub1 flg_kcbh @15 0x04 (KCBHFCKV)
ub2 chkval_kcbh @16 0x6cee
ub2 spare3_kcbh @18 0x0000
BBED> verify
DBVERIFY - Verification starting
FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF
BLOCK = 122146
Block Checking: DBA = 4316450, Block Type = KTB-managed data block
Found block already marked corrupted
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
BBED> set offset 8188
OFFSET 8188
BBED> map
File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0)
Block: 122147 Dba:0x00000000
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 3720 bytes @20
struct kdxle, 32 bytes @3740
b2 kd_off[188] @3772
ub1 freespace[1534] @4148
ub1 rowdata[2442] @5682
ub4 tailchk @8188
BBED> d
File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0)
Block: 122147 Offsets: 8188 to 8191 Dba:0x00000000
------------------------------------------------------------------------
ff060000
<32 bytes per line>
BBED> set mode edit
MODE Edit
BBED> m /x 01 offset 14
File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0)
Block: 122147 Offsets: 14 to 525 Dba:0x00000000
------------------------------------------------------------------------
0104ee6c 00000200 00003500 0000b3da 8a1f0000 00009a00 030021dd 41000900
0700443d 0600531c c000628b 010000c0 00002c3f 5a1f0300 0000ca5e 05002b0a
c0008685 01000080 000073d7 8a1f0400 200057a2 0500d530 c000a88e 2c000080
0000b3d7 8a1f0a00 01002848 08001101 c00084be 29000080 0000e3d7 8a1f0800
0d00d612 06008f0a c000258d 3c000080 000026d8 8a1f0100 1f0063c1 04006007
c0002887 4b000080 000046d8 8a1f0700 1e005403 0600a707 c000bd8e 40000080
00006bd8 8a1f0a00 0b000c48 08001301 c00084be 41000080 0000a2d8 8a1f0600
1b0055e6 0500c508 c0000f8b 23000080 0000fad8 8a1f0300 0600ca5e 0500220a
c0008685 34000080 000040d9 8a1f0800 1300d412 0600900a c000258d 2e000080
000064d9 8a1f0600 0b0092e6 0500c608 c0000f8b 1c000080 000089d9 8a1f0a00
05001d48 08001401 c00084be 05000080 0000aed9 8a1f0400 100030a2 0500d730
c000a88e 0e000080 000016da 8a1f0800 1700c712 0600910a c000258d 33000080
000022da 8a1f0200 1100450d 0500930c c000c085 28000080 00002fda 8a1f0200
0800610d 0500940c c000c085 20000080 00004eda 8a1f0700 12003303 0600aa07
c000bd8e 0a000120 0f00b7da 8a1f0a00 13000048 08001501 c00084be 07000220
1e00f5da 8a1f0900 07000b44 0600650f c000968d 05000120 0f0004db 8a1f0300
<32 bytes per line>
BBED> sum apply
Check value for File 0, Block 122147:
current = 0x6cee, required = 0x6cee
BBED> verify
DBVERIFY - Verification starting
FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF
BLOCK = 122146
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
BBED> m /x c1da8a1f offset 8
File: D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF (0)
Block: 122147 Offsets: 8 to 519 Dba:0x00000000
------------------------------------------------------------------------
c1da8a1f 00000104 ee6c0000 02000000 35000000 b3da8a1f 00000000 9a000300
21dd4100 09000700 443d0600 531cc000 628b0100 00c00000 2c3f5a1f 03000000
ca5e0500 2b0ac000 86850100 00800000 73d78a1f 04002000 57a20500 d530c000
a88e2c00 00800000 b3d78a1f 0a000100 28480800 1101c000 84be2900 00800000
e3d78a1f 08000d00 d6120600 8f0ac000 258d3c00 00800000 26d88a1f 01001f00
63c10400 6007c000 28874b00 00800000 46d88a1f 07001e00 54030600 a707c000
bd8e4000 00800000 6bd88a1f 0a000b00 0c480800 1301c000 84be4100 00800000
a2d88a1f 06001b00 55e60500 c508c000 0f8b2300 00800000 fad88a1f 03000600
ca5e0500 220ac000 86853400 00800000 40d98a1f 08001300 d4120600 900ac000
258d2e00 00800000 64d98a1f 06000b00 92e60500 c608c000 0f8b1c00 00800000
89d98a1f 0a000500 1d480800 1401c000 84be0500 00800000 aed98a1f 04001000
30a20500 d730c000 a88e0e00 00800000 16da8a1f 08001700 c7120600 910ac000
258d3300 00800000 22da8a1f 02001100 450d0500 930cc000 c0852800 00800000
2fda8a1f 02000800 610d0500 940cc000 c0852000 00800000 4eda8a1f 07001200
33030600 aa07c000 bd8e0a00 01200f00 b7da8a1f 0a001300 00480800 1501c000
84be0700 02201e00 f5da8a1f 09000700 0b440600 650fc000 968d0500 01200f00
<32 bytes per line>
BBED> p kcbh
struct kcbh, 20 bytes @0
ub1 type_kcbh @0 0x06
ub1 frmt_kcbh @1 0xa2
ub1 spare1_kcbh @2 0x00
ub1 spare2_kcbh @3 0x00
ub4 rdba_kcbh @4 0x0041dd22
ub4 bas_kcbh @8 0x1f8adac1
ub2 wrp_kcbh @12 0x0000
ub1 seq_kcbh @14 0x01
ub1 flg_kcbh @15 0x04 (KCBHFCKV)
ub2 chkval_kcbh @16 0x6cee
ub2 spare3_kcbh @18 0x0000
BBED> sum apply
Check value for File 0, Block 122147:
current = 0x7364, required = 0x7364
BBED> verify
DBVERIFY - Verification starting
FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF
BLOCK = 122146
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
dbv再次验证，坏块完美修复
C:\Users\FAL>dbv file=D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF DBVERIFY: Release 11.2.0.1.0 - Production on 星期六 5月 14 22:00:06 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. DBVERIFY - 开始验证: FILE = D:\BAIDUYUNDOWNLOAD\ORADATA\CHEASDB\SYSTEM01.DBF DBVERIFY - 验证完成 检查的页总数: 259840 处理的页总数 (数据): 181934 失败的页总数 (数据): 0 处理的页总数 (索引): 57381 失败的页总数 (索引): 0 处理的页总数 (其他): 3218 处理的总页数 (段) : 1 失败的总页数 (段) : 0 空的页总数: 17307 标记为损坏的总页数: 0 流入的页总数: 0 加密的总页数 : 0 最高块 SCN : 530218225 (0.530218225)
通过修复之后重新导出数据
参考相似篇章:file 1 block 128 corrupted/坏块恢复—system rollback坏块修复