ORA-01578 and ORA-01110 How to solve the bad block

Source: Internet
Author: User
Tags dba header relative

A case, view trace file found the following error message

D:\oracle\product\10.2.0\admin\dbserver\udump\orcl_ora_5888.trc

Corrupt block relative dba:0x09848269 (file 295529)

Bad header found during buffer read

Data in bad block:

Type:1 Format:5 rdba:0x30322d2d

Last Change Scn:0xfffe.fffefffe Seq:0xfe flg:0xff

spare1:0x0 spare2:0x30 spare3:0x0

Consistency value in tail:0x2d2d3533

Check value in block Header:0xfffe

Computed Block checksum:0x91f9

Reread of rdba:0x09848269 (file, block 295529) found same corrupted data

Fri Dec 27 08:28:08 2013

Corrupt block Found

TSN = Tsname = Hghis

RFN = BLK = 295529, rdba = 159679081

Objn = 119544, OBJD = 119544, OBJECT = emr_monitor_result, subobject =

SEGMENT OWNER = hghis, SEGMENT TYPE = Table SEGMENT

Fri Dec 27 08:54:18 2013

Hex Dump of (file, block 295561) in trace file d:\oracle\product\10.2.0\admin\dbserver\udump\orcl_ora_6796.trc

Corrupt block relative dba:0x09848289 (file 295561)

Bad header found during buffer read

Data in bad block:

type:48 format:0 rdba:0x020cc100

Last Change scn:0xb500.080cc100 seq:0xa5 flg:0xba

Spare1:0x34 spare2:0x2 Spare3:0xb0b8

Consistency value in tail:0x395e3031

Check value in block HEADER:0XCFCB

Block checksum disabled

Reread of rdba:0x09848289 (file, block 295561) found same corrupted data

Fri Dec 27 08:54:19 2013

Corrupt block Found

TSN = Tsname = Hghis

RFN = BLK = 295561, rdba = 159679113

Objn = 119494, OBJD = 119494, OBJECT = sys_lob0000119493c00006$$, subobject =

SEGMENT OWNER = hghis, SEGMENT TYPE = Lob SEGMENT

Fri Dec 27 09:11:20 2013

Hex Dump of (file, block 295563) in trace file d:\oracle\product\10.2.0\admin\dbserver\udump\orcl_ora_5584.trc

Corrupt block relative dba:0x0984828b (file 295563)

Bad header found during buffer read

Data in bad block:

type:71 Format:7 rdba:0x064d0001

Last Change scn:0x3038.43584400 seq:0x31 flg:0x07

spare1:0x44 spare2:0x4c spare3:0x771

Consistency value in tail:0x000a0000

Check value in block header:0x7800

Computed Block Checksum:0xcbf8

Reread of rdba:0x0984828b (file, block 295563) found same corrupted data

Fri Dec 27 09:11:21 2013

Corrupt block Found

TSN = Tsname = Hghis

RFN = BLK = 295563, rdba = 159679115

Objn = 119494, OBJD = 119494, OBJECT = sys_lob0000119493c00006$$, subobject =

SEGMENT OWNER = hghis, SEGMENT TYPE = Lob SEGMENT

Fri Dec 27 09:27:59 2013

According to the above information that 38th data file 295529, 295561, 295563 is bad block, you can use the DBV tool or Rman to check the bad block information

DBV file= "D:\oradata\DATA. DBF "blocksize=8192

Or

Rman Target/

Backup validate check logical database;

SELECT * from V$database_block_corruption;

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.