RE: Bad header found during backing up datafile

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: Roger Xu
  INET: roger_xu_at_dp7uptx.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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).