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 <[EMAIL PROTECTED]> 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: [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). __________________________________________________ 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: [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).
