Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bad header found during backing up datafile
Drop the index, create it in another tbs/disk; check if the error(s)
appear during the next RMAN bkp run. If it doesn't then it would confirm
that your problem is real.
> Roger
> I have never received this error (or didn't read the log closely
> enough).
> I think I heard somewhere that is how RMAN handles blocks that are updated
> while it is reading them. I do remember that RMAN's method of handling
> this
> is different from hot backups.
> One thing you might consider is exporting the table. If you can't
> export
> to disk, you could export to /dev/null. Several people on this list have
> mentioned that RMAN doesn't catch all data corruption problems, but I
> think
> (experts correct me if I'm wrong) that export will catch all forms of data
> corruption.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Thursday, August 28, 2003 3:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
>> In our development box, when RMAN is running, I see the following
>> messages only in the alert.log quite often.
>> And it seems to me always happens in the index tablespace.
>> I ran dbverify and validate structure of the whole database
>> with no corruption reported.
>>
>> Any comments?
>>
>>
>>
>>
>>
>> ***
>> Corrupt block relative dba: 0x13c2c44c (file 79, block 181324)
>> Bad header found during backing up datafile
>> Data in bad block -
>> type: 48 format: 1 rdba: 0x3939390a
>> last change scn: 0x3537.31333031 seq: 0x34 flg: 0x38
>> consistency value in tail: 0x791b0602
>> check value in block header: 0x3431, block checksum disabled
>> spare1: 0x4, spare2: 0x31, spare3: 0x330
>> ***
>> Reread of blocknum=181324,
> file=/oracle/DV2/sapdata3/btabi_15/btabi.data15. found valid data
>>
>>
>> Roger Xu
>> Database Administrator
>> Dr Pepper Bottling Company of Texas
>> (972)721-8337
>>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Corniche Park INET: cornichepark_at_cwazy.co.uk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Aug 30 2003 - 05:34:26 CDT