Code to identify Corrupt Datafile

dbv file=/u06/oratest/db/apps_st/data/system09.dbf

DBVERIFY - Verification complete

Total Pages Examined         : 192128
Total Pages Processed (Data) : 71368
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 31797
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1889
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 60601
Total Pages Marked Corrupt   : 26473
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 3848087620 (1388.3848087620)




[oratest@testxpressoracle data]$ dbv FILE=log02a.dbf

DBVERIFY: Release 11.1.0.7.0 - Production on Thu Jul 28 10:29:26 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


DBV-00103: Specified BLOCKSIZE (8192) differs from actual (512)
[oratest@testxpressoracle data]$ dbv FILE=log02b.dbf

DBVERIFY: Release 11.1.0.7.0 - Production on Thu Jul 28 10:29:45 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


DBV-00103: Specified BLOCKSIZE (8192) differs from actual (512)




[oratest@testxpressoracle data]$ dbv FILE=log01a.dbf

DBVERIFY: Release 11.1.0.7.0 - Production on Thu Jul 28 10:30:10 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


DBV-00103: Specified BLOCKSIZE (8192) differs from actual (512)
[oratest@testxpressoracle data]$ dbv FILE=log01b.dbf

DBVERIFY: Release 11.1.0.7.0 - Production on Thu Jul 28 10:30:16 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


DBV-00103: Specified BLOCKSIZE (8192) differs from actual (512)


BACKUP VALIDATE CHECK LOGICAL DATABASE;

backup validate database archivelog all;