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

Home -> Community -> Mailing Lists -> Oracle-L -> rman and dbv disagree on datafile quality ?

rman and dbv disagree on datafile quality ?

From: Nilo Segura <nilosegura_at_gmail.com>
Date: Fri, 16 Mar 2007 02:31:04 +0100
Message-ID: <4ce989e0703151831w696fd2ffi58b545f6a8d670a5@mail.gmail.com>


Hi!

We have gone through some database corrupt blocks in the last months, and we have seen that in some cases, RMAN and DBV disagree. Running a level 0 backup with RMAN will tell me that I have a bad block on one datafile (the backup will stop at that moment). If I run DBV on the datafile, it will return totally clean, no trace of block corruption. In the view V$DATABASE_BLOCK_CORRUPTION there is nothing. There must be something in the datafile, but rman does not say where it is located the bad block.

In Metalink I have found recipes for bad blocks, reported by both rman and dbv (when they agree), that do not appear in DBA_EXTENTS as being allocated to any database object, but I can not apply those recipes to my case.

So apart from recreating the tablespaces, I have no clue how to get rid or reinitialize those bad blocks. Any way to force rman to log more info on the bad blocks ?

Any idea would be very much appreciated.

ciao.

p.s we run 10.2.0.2 on Red Hat 3.x
--

Nilo Segura
Oracle Support - IT/DES
CERN - Geneva
Switzerland

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 15 2007 - 20:31:04 CDT

Original text of this message

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