| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Corrupt block - Bad header found during buffer read
Hi
I am not sure why this corruption occurred. If you look at the consistent value in tail, it is matching with the block header, meaning the consistency value in tail is 0x96b20602 which is a combination of lower 4 bytes of the last change scn + format + type. This is just one part of the consistency check and there could be someother problems.
Please find out what segment these blocks belong to. Also, it may be worthwhile to check the OS logs for any hardware problem. Let us know what you find. We will go from there. Also, dump the blocks using these commands
alter system dump datafile 60 block 628658;
alter system dump datafile 61 block 323407;
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
"Antonio
Idone" To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
<antoidone_at_vi cc:
sto.com> Subject: Corrupt block - Bad header found
during buffer read
Sent by:
root_at_fatcity.
com
02/16/01
09:05 AM
Please
respond to
ORACLE-L
Hi all,
help me
i have the problem with my database ver. 8.1.5 64 bit
on HP 9000 (datawarehouse with parallel query) i.e:
Current log# 5 seq# 10474 mem# 0: /u2ddsp/oradata/ddsp/redo0301new.rdo
Current log# 5 seq# 10474 mem# 1: /u2ddsp/oradata/ddsp/redo0302new.rdo
***
Corrupt block relative dba: 0x0f0997b2 file=60. blocknum=628658.
Bad header found during buffer read
Data in bad block - type:6. format:2. rdba:0x0f021c8b
last change scn:0x018b.bc5096b2 seq:0x2 flg:0x00
consistancy value in tail 0x96b20602
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0
***
Corrupt block relative dba: 0x0f44ef4f file=61. blocknum=323407.
Bad header found during buffer read
Data in bad block - type:6. format:2. rdba:0x0f41b50d
last change scn:0x018b.bc5096b5 seq:0x2 flg:0x00
consistancy value in tail 0x96b50602
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0
Thank
Antonio
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Antonio Idone INET: antoidone_at_visto.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Feb 16 2001 - 16:16:22 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Riyaj_Shamsudeen_at_i2.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |