DBV Utility Errors
Hi,
On using "DBV" to verify the integrity of index data files ( 7 files of 2 GB ) on an Oracle 7.3.2.1 running on AIX ver 4 ; I got the following result :
$ dbv FILE=ind01.dbf BLOCKSIZE=4096 FEEDBACK=1000
DBVERIFY - Verification starting : FILE = ind01.dbf
................................................................................
............................................**** row 0: row length 65537 past end of block
**** row 0: row skipped so other stats may be wrong
**** row 1: row offset 31192 out of valid range
**** row 2: overlays existing row; row offset 0; block offset 340
---- end index block validation
Page 444497 failed with check code 1
....................................
............................................
DBVERIFY - Verification complete
Total Pages Examined : 524032
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 509100
Total Pages Failing (Index): 1
Total Pages Empty : 14807
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
$ dbv FILE=ind02.dbf BLOCKSIZE=4096 FEEDBACK=1000
DBVERIFY - Verification starting : FILE = ind02.dbf
.....................................................**** row 0: row offset 0 out of valid range
**** row 1: row offset 0 out of valid range
offset 768
---- end index block validation
Page 53663 failed with check code 1
...........................
................................**** row 0: overlays existing row; row offset 0; block offset 3321
---- end index block validation
Segmentation fault(coredump)
Does this mean that all the index files ( on this machine ) are corrupted ?
2 weeks back I was able to do an entire export dump and was able to import into another machine.
What are the options available to repair the corruption ? Thanks.