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: Bad header found during backing up datafile

RE: Bad header found during backing up datafile

From: Corniche Park <cornichepark_at_cwazy.co.uk>
Date: Sat, 30 Aug 2003 02:34:26 -0800
Message-ID: <F001.005CE298.20030830023426@fatcity.com>


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

Original text of this message

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