RE: Question on Corrupted blocks

Did you run RMAN validate check logical database? v$database_block_corruption is populated from RMAN.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ashoke Mandal Sent: Wednesday, May 24, 2017 4:11 PM
To: ORACLE-L
Subject: [External] Question on Corrupted blocks

Hello,

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.)?

1. $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)

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)
wip_ind_large_idx01.log:Total Pages Marked Corrupt   : 3

Thanks,
Ashoke

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