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