I shutdown the database, ran dbverify($ORACLE_HOME/bin/dbv) and it reported
the following block corruption in the respective logfile (as listed below -
1 through 4).
But "select * from v$database_block_corruption;" doesn't return any rows.
Q1. Could you provide me any idea what are the possible cause for these
corruption?
Q2. What is best way to check for such block corruption before I upgrade a
production database?
Q3. Is it possible there might be some corrupt blocks but we don't receive
any complain from anywhere (user or alert log etc.)?
- $ORACLE_HOME/bin/dbv file=/u03/oradata/file_1_ind_idx02.dbf feedback=100
logfile=/<logfile_location>/file_1_ind_idx02.log blocksize=8192
Corrupt block relative dba: 0x0a80271a (file 42, block 10010)
Total Pages Marked Corrupt : 1
2. $ORACLE_HOME/bin/dbv file=/u03/oradata/file_2_data.dbf feedback=100
logfile=/<logfile_location>/file_2_data.log blocksize=8192
Corrupt block relative dba: 0x0a008b02 (file 40, block 35586)
Corrupt block relative dba: 0x0a008b0e (file 40, block 35598)
Corrupt block relative dba: 0x0a008b0f (file 40, block 35599)
Corrupt block relative dba: 0x0a008b10 (file 40, block 35600)
Corrupt block relative dba: 0x0a008b11 (file 40, block 35601)
Corrupt block relative dba: 0x0a008b13 (file 40, block 35603)
Corrupt block relative dba: 0x0a008b15 (file 40, block 35605)
Corrupt block relative dba: 0x0a008b17 (file 40, block 35607)
Corrupt block relative dba: 0x0a008bfa (file 40, block 35834)
Corrupt block relative dba: 0x0a008ee3 (file 40, block 36579)
Total Pages Marked Corrupt : 10
3. $ORACLE_HOME/bin/dbv file=/u03/oradata/file_3_idx01.dbf feedback=100
logfile=/<logfile_location>/file_3_idx01.log blocksize=8192
mdl_ind_medium_idx01.log:Corrupt block relative dba: 0x090075a5 (file 36,
block 30117)
mdl_ind_medium_idx01.log:Total Pages Marked Corrupt : 1
4. $ORACLE_HOME/bin/dbv file=/u03/oradata/file_3_ind_large_idx01.dbf
feedback=100 logfile=/<logfile_location>/file_3_ind_large_idx01.log
blocksize=8192
wip_ind_large_idx01.log:Corrupt block relative dba: 0x02c0f581 (file 11,
block 62849)
wip_ind_large_idx01.log:Corrupt block relative dba: 0x02c0f583 (file 11,
block 62851)
wip_ind_large_idx01.log:Corrupt block relative dba: 0x02c0f586 (file 11,
block 62854)