Oracle csc higher than block scn type bad block repair

Source: Internet
Author: User
Tags dba reserved

Although the database is open normally, some tables are exported due to bad blocks in the system. The customer hopes to solve the problem by fixing bad blocks.
Exp-ORA-1578
Bbed check system reports bad blocks
C: \ Users \ FAL> dbv file = D: \ BAIDUYUNDOWNLOAD \ ORADATA \ CHEASDB \ SYSTEM01.DBF
 
DBVERIFY: Release 11.2.0.1.0-Production on Saturday May 14 15:40:55 2016
 
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
 
DBVERIFY-START verification: FILE = D: \ BAIDUYUNDOWNLOAD \ ORADATA \ CHEASDB \ SYSTEM01.DBF
Csc (0x0000. 1f8adab3) higher than block scn (0x0000.00000000)
Page 122146 failed, verification code: 6054
 
 
DBVERIFY-verification completed
 
Total number of checked pages: 252160
Total number of processed pages (data): 178921
Total number of failed pages (data): 0
Total number of processed pages (index): 52576
Total number of failed pages (index): 1
Total number of processed pages (others): 3201
Total number of processed pages (segment): 1
Total number of failed pages (segments): 0
Total number of blank pages: 17462
Total number of pages marked as damaged: 0
Total number of inbound pages: 0
Total number of encrypted pages: 0
Maximum block SCN: 529420540 (0.529420540)
Bbed repairs bad blocks
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,200 2, Oracle Corporation. All rights reserved.
 
*************!!! For Oracle Internal Use only !!! ***************
 
BBED> set blocksize 8192
Blocsize 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 sparejavaskcbh @ 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 = 1, 122146
 
Block Checking: DBA = 4316450, Block Type = KTB-managed data block
Found block already marked specified upted
 
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 Blocks UPT: 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
------------------------------------------------------------------------
010000ee6c 00000200 00003500 2017b3da 8a1f0000 20179a00 030021dd 41000900
0700443d 0600531c c000628b 00000c0 %2c3f 5a1f0300 %ca5e 05002b0a
C0008685 01000080 running 73d7 8a1f0400 200057a2 0500d530 c000a88e 2c000080
2017b3d7 8a1f0a00 01002848 08001101 c00084be 29000080 492e3d7 8a1f0800
0d00d612 06008f0a c000258d 3c000080 11626d8 8a1f0100 1f0063c1 04006007
C0002887 4bda-80 10946d8 8a1f0700 1e005403 0600a707 c000bd8e 40000080
20176bd8 8a1f0a00 0b000c48 08001301 c00084be 41000080 running a2d8 8a1f0600
1b0055e6 0500c508 c0000f8b 23000080 running fad8 8a1f0300 0600ca5e 0500220a
C0008685 34000080 running 40D9 8a1f0800 1300d412 0600900a c000258d 2e000080
201764d9 8a1f0600 0b0092e6 0500c608 c0000f8b 1c000080 10989d9 8a1f0a00
05001d48 08001401 c00084be 05000080 running aed9 8a1f0400 100030a2 0500d730
C000a88e 0e000080 11616da 8a1f0800 1700c712 0600910a c000258d 33000080
201722da 8a1f0200 11000000d 0500930c c000c085 28000080 1162fda 8a1f0200
0800610d 0500940c c000c085 20000080 4154eda 8a1f0700 12003303 0600aa07
C000bd8e 0a000120 0f00b7da 8a1f0a00 13000048 08001501 c00084be 07000220
1e00f5da 8a1f0900 07000b44 0600450f 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 = 1, 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 Blocks UPT: 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 0f8b230000800000 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 running d0500 930cc000 c0852800 00800000
2fda8a1f 02000800 610d0500 940cc000 c0852000 00800000 4eda8a1f 07001200
33030600 aa07c000 bd8e0a00 01200f00 b7da8a1f 0a001300 00480800 1501c000
84be0700 02201e00 f5da8a1f 09000700 0b0000600 109fc000 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 sparejavaskcbh @ 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 = 1, 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 Blocks UPT: 0
Total Blocks Influx: 0
Dbv re-verification, perfect repair for bad blocks
C: \ Users \ FAL> dbv file = D: \ BAIDUYUNDOWNLOAD \ ORADATA \ CHEASDB \ SYSTEM01.DBF
 
DBVERIFY: Release 11.2.0.1.0-Production on Saturday May 14 22:00:06 2016
 
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
 
DBVERIFY-START verification: FILE = D: \ BAIDUYUNDOWNLOAD \ ORADATA \ CHEASDB \ SYSTEM01.DBF
 
 
DBVERIFY-verification completed
 
Total number of checked pages: 259840
Total number of processed pages (data): 181934
Total number of failed pages (data): 0
Total number of processed pages (index): 57381
Total number of failed pages (index): 0
Total number of processed pages (others): 3218
Total number of processed pages (segment): 1
Total number of failed pages (segments): 0
Total number of blank pages: 17307
Total number of pages marked as damaged: 0
Total number of inbound pages: 0
Total number of encrypted pages: 0
Maximum block SCN: 530218225 (0.530218225)
Re-export data after repair

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.