ITPub博客

首页 > 数据库 > Oracle > 一次oracle坏块修复

一次oracle坏块修复

原创 Oracle 作者:oracle11111 时间:2025-12-02 13:44:27 0 删除 编辑


数据库 启动报错,600 检查发现是有个坏块,下面是相关的修复步骤,


首先,将文件从asm 拷贝出来,然后将这个块拷贝到了本机。






本机修改这个数据块 


[oracle@zc bbed]$ bbed parfile=./bbed.par


BBED: Release 2.0.0.0.0 - Limited Production on Tue Dec 2 09:11:49 2025


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


************* !!! For Oracle Internal Use only !!! ***************


BBED> set blocksize 8192

BLOCKSIZE      8192


BBED> verify

DBVERIFY - Verification starting

FILE = /home/oracle/bbed/bad.block

BLOCK = 0


Block 0 is corrupt

Corrupt block relative dba: 0x24000000 (file 0, block 0)

Bad header found during verification

Data in bad block:

 type: 6 format: 2 rdba: 0x241bb42c

 last change scn: 0x0000.0e1b.2cc0c27a seq: 0x1 flg: 0x04

 spare3: 0x0

 consistency value in tail: 0xc27a0601

 check value in block header: 0xb31a

 computed block checksum: 0x0



DBVERIFY - Verification complete


Total Blocks Examined         : 1

Total Blocks Processed (Data) : 0

Total Blocks Failing   (Data) : 0

Total Blocks Processed (Index): 0

Total Blocks Failing   (Index): 0

Total Blocks Empty            : 0

Total Blocks Marked Corrupt   : 1

Total Blocks Influx           : 0

Message 531 not found;  product=RDBMS; facility=BBED



上面发现rdba有问题


BBED> p kcbh

struct kcbh, 20 bytes                       @0       

   ub1 type_kcbh                            @0        0x06

   ub1 frmt_kcbh                            @1        0xa2

   ub2 wrp2_kcbh                            @2        0x0000

   ub4 rdba_kcbh                            @4        0x241bb42c

   ub4 bas_kcbh                             @8        0x2cc0c27a

   ub2 wrp_kcbh                             @12       0x0e1b

   ub1 seq_kcbh                             @14       0x01

   ub1 flg_kcbh                             @15       0x04 (KCBHFCKV)

   ub2 c-h-kval_kcbh                          @16       0xb31a

   ub2 spare3_kcbh                          @18       0x0000


BBED> assign rdba_kcbh=0x24000000

Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y

ub4 rdba_kcbh                               @4        0x24000000


改成现在的 ,后面dd 回去的时候还得改回去,



BBED> sum apply

Check value for File 1, Block 1:

current = 0x072d, required = 0x072d


BBED> verify

DBVERIFY - Verification starting

FILE = /home/oracle/bbed/bad.block

BLOCK = 0


Block Checking: DBA = 603979776, Block Type = KTB-managed data block

data header at 0x2557064

kdbc-h-k: the amount of space used is not equal to block size

        used=138 fsc=8645 avsp=957 dtu=9740 dtl=8088 (s3=0, typ=6)

Block 0 failed with check code 6110


DBVERIFY - Verification complete


Total Blocks Examined         : 1

Total Blocks Processed (Data) : 1

Total Blocks Failing   (Data) : 1

Total Blocks Processed (Index): 0

Total Blocks Failing   (Index): 0

Total Blocks Empty            : 0

Total Blocks Marked Corrupt   : 0

Total Blocks Influx           : 0

Message 531 not found;  product=RDBMS; facility=BBED


6110 报错


BBED> modify /x 0000 offset 62

 File: /home/oracle/bbed/bad.block (1)

 Block: 1                Offsets:   62 to  573           Dba:0x00400001

------------------------------------------------------------------------

 00001059 b9242000 1600474c 100005b0 05024745 29000080 1b0e1059 b9240000 

 00000000 00000001 28001400 6200f703 bd03bd03 00002800 bb061808 7509d50a 

 370c9b0d fc0e5910 b7111a13 7514ce15 27178518 e319491b aa1c0c1e f7035905 

 15001600 17001800 19001a00 1b001c00 1d001e00 1f002000 21002200 23002400 

 25002600 2700ffff ffff2e15 d7148014 2914d213 7b132413 cd127612 1f12c811 

 71111a11 c3106c10 1510be0f 670f100f b90e620e 0b0eb40d 5d0d060d af0c580c 

 010c0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 000010b9 00000000 00000000 00000000 00000000 00000000 00000000 

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 


 <32 bytes per line>



BBED> sum apply

Check value for File 1, Block 1:

current = 0x5b41, required = 0x5b41


BBED> verify

DBVERIFY - Verification starting

FILE = /home/oracle/bbed/bad.block

BLOCK = 0


Block Checking: DBA = 603979776, Block Type = KTB-managed data block

data header at 0x2579064

kdbc-h-k: the amount of space used is not equal to block size

        used=138 fsc=0 avsp=957 dtu=1095 dtl=8088 (s3=0, typ=6)

Block 0 failed with check code 6110


DBVERIFY - Verification complete


Total Blocks Examined         : 1

Total Blocks Processed (Data) : 1

Total Blocks Failing   (Data) : 1

Total Blocks Processed (Index): 0

Total Blocks Failing   (Index): 0

Total Blocks Empty            : 0

Total Blocks Marked Corrupt   : 0

Total Blocks Influx           : 0

Message 531 not found;  product=RDBMS; facility=BBED



BBED> assign kdbh.kdbhavsp=7950;       

sb2 kdbhavsp                                @110      7950


BBED> sum apply

Check value for File 1, Block 1:

current = 0x47f2, required = 0x47f2




BBED> verify

DBVERIFY - Verification starting

FILE = /home/oracle/bbed/bad.block

BLOCK = 0


Block Checking: DBA = 603979776, Block Type = KTB-managed data block

data header at 0x2579064

kdbc-h-k: avsp(7950) > tosp(957)

Block 0 failed with check code 6128


DBVERIFY - Verification complete


Total Blocks Examined         : 1

Total Blocks Processed (Data) : 1

Total Blocks Failing   (Data) : 1

Total Blocks Processed (Index): 0

Total Blocks Failing   (Index): 0

Total Blocks Empty            : 0

Total Blocks Marked Corrupt   : 0

Total Blocks Influx           : 0

Message 531 not found;  product=RDBMS; facility=BBED


 



BBED> assign kdbh.kdbhtosp=7950;    

sb2 kdbhtosp                                @112      7950



BBED> sum apply

Check value for File 1, Block 1:

current = 0x5b41, required = 0x5b41


BBED> verify

DBVERIFY - Verification starting

FILE = /home/oracle/bbed/bad.block

BLOCK = 0


Block Checking: DBA = 603979776, Block Type = KTB-managed data block

data header at 0x259b064

kdbc-h-k: space available on commit is incorrect

        tosp=7950 fsc=0 stb=40 avsp=7950

Block 0 failed with check code 6111


DBVERIFY - Verification complete


Total Blocks Examined         : 1

Total Blocks Processed (Data) : 1

Total Blocks Failing   (Data) : 1

Total Blocks Processed (Index): 0

Total Blocks Failing   (Index): 0

Total Blocks Empty            : 0

Total Blocks Marked Corrupt   : 0

Total Blocks Influx           : 0

Message 531 not found;  product=RDBMS; facility=BBED



BBED> assign kdbh.kdbhtosp=7990;

sb2 kdbhtosp                                @112      7990


BBED> sum apply

Check value for File 1, Block 1:

current = 0x5b79, required = 0x5b79


BBED> verify

DBVERIFY - Verification starting

FILE = /home/oracle/bbed/bad.block

BLOCK = 0



DBVERIFY - Verification complete


Total Blocks Examined         : 1

Total Blocks Processed (Data) : 1

Total Blocks Failing   (Data) : 0

Total Blocks Processed (Index): 0

Total Blocks Failing   (Index): 0

Total Blocks Empty            : 0

Total Blocks Marked Corrupt   : 0

Total Blocks Influx           : 0

Message 531 not found;  product=RDBMS; facility=BBED


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69924215/viewspace-3104112/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Flashback Archive
请登录后发表评论 登录
全部评论

注册时间:2019-05-19

  • 博文量
    81
  • 访问量
    90383