oracle+块头csc,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坏块修复