Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Corrupt block - Bad header found during buffer read

Re: Corrupt block - Bad header found during buffer read

From: <Riyaj_Shamsudeen_at_i2.com>
Date: Fri, 16 Feb 2001 14:16:22 -0800
Message-ID: <F001.002B729A.20010216142157@fatcity.com>

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



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: 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-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: 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).
Received on Fri Feb 16 2001 - 16:16:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US