Block corruption again

From: Jiang, Lu <Lu.Jiang_at_umassmed.edu>
Date: Wed, 28 Dec 2011 14:44:47 -0500
Message-ID: <E456CBDCBA39124DA45560EA116A22E7C83D39E03B_at_MBLEXCH.mbl.org>

Hi all,
I just got a corrupt block again, had fixed a block corruption in a same index file two weeks ago. Don't know why this happened twice in such a sort period.

I tried rman validate and dbverify to detect the corruption, but rman validate did not report any data corruption while dbverify did.

Could anyone shed any light on this?

Thanks,
Lu

The following is the output from rman validate and dbverify.

Using backup validate:

RMAN> backup check logical validate datafile 'F:\ORACLE\ERPPROD\DB\APPS_ST\DATA\A_TXN_IND01.DBF'; Starting backup at 28-DEC-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fnochannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 Finished backup at 28-DEC-11

Using dbverify:

dbv FILE=F:\ORACLE\ERPPROD\DB\APPS_ST\DATA\A_TXN_IND01.DBF FEEDBACK0 Corrupt block relative dba: 0x06426321 (file 25, block 156449) Bad check value found during dbv:
.......
DBVERIFY - Verification complete

Total Pages Examined         : 393216
Total Pages Processed (Data) : 2782
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 93966
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 19301
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 277166
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0
Highest block SCN            : 1326171528 (0.1326171528)

Looks rman validate did not ddetect any data corruption while dbverify did.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 28 2011 - 13:44:47 CST