David,
It sounds like you had a corruption in memory. I'd
run some thorough diagnostics on the server.
The error was reported because Oracle was requesting
relative dba 0x0a877fd8. The block it received,
however, contained rdba 0x0b801ea2
Oracle records the rdba in the block itself so it can
verify that the block it received is actually the
block it requested.
The fact that analyze table validate structure cascade
didn't report any errors tells me that the block is OK
on disk, but it was corrupted either while or after
being read into memory. Furthermore from the info in
the error message it is only the rdba's that are
inconsistent as the info from the header and the tail
of the block are consistent. Yet another reason why I
suspect a hardware glitch.
HTH,
- Anita
- david hill <david.hill_at_lechateau.ca> wrote:
> Hi Guys
> I Have a funny problem
> in my alert log i got the following errors for about
> 15mins
> ***
> Corrupt block relative dba: 0x0a877fd8 (file 42,
> block 491480)
> Bad header found during buffer read
> Data in bad block -
> type: 6 format: 2 rdba: 0x0b801ea2
> last change scn: 0x0000.17a9d140 seq: 0x1 flg: 0x02
> consistency value in tail: 0xd1400601
> check value in block header: 0x0, block checksum
> disabled
> spare1: 0x0, spare2: 0x0, spare3: 0x0
> ***
> now i found which table was at that block
> analyzed that table with cascade, no errors were
> reported
> i then didi a full table scan, no errors,
> then i did an export of that table no errors were
> reported
> ???????
> what could cause this?
> I'm running on HP-UX 64 bit
> and i did apply the 8.1.7.2.1 patch yesterday, could
> it be related?
> all Oracle tells me is to keep an eye it.
> I was hoping someone could give me a little more
> insight into this or if you
> have experienced any similiar kind of problems with
> corruption that wasn't
> there
>
> Thanks for any Help
>
> David Hill
> DBA
> LeChateau
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: david hill
> INET: david.hill_at_lechateau.ca
>
> 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).
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.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).
Received on Sat Dec 08 2001 - 11:23:20 CST
