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
<[EMAIL PROTECTED]>
<antoidone@vi cc:
sto.com> Subject: Corrupt block - Bad header found
during buffer read
Sent by:
root@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
___________________________________________________________________________
Visit http://www.visto.com/info, your free web-based communications center.
Visto.com. Life on the Dot.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Antonio Idone
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
