Damage to Ora-01578:oracle data block (file number 46, block number 1101348)

Receive an alert message

Mon May 05 20:08:22 2014

Errors in File/tol/app/oracle/admin/coredb/diag/rdbms/dg_115/coredb/trace/coredb_ora_511.trc (incident=373665):

Damage to Ora-01578:oracle data block (file number 46, block number 1101348)

ORA-01110: Data file: '/tol/oradata/datafile/coredb/user_lesson_log_index08.dbf ' incidentdetails in:/tol/app/oracle/ Admin/coredb/diag/rdbms/dg_115/coredb/incident/incdir_373665/coredb_ora_511_i373665.trc

Bad block in data file

[oracle@dg_115 arch]$ dBV file=/tol/oradata/datafile/coredb/user_lesson_log_index08.dbf

Dbverify:release 11.2.0.1.0-production on Mon 5 20:42:14 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Dbverify-verification Starting:file =/tol/oradata/datafile/coredb/user_lesson_log_index08.dbf

Dbv-00200:block, DBA 194039332, already marked corrupt
CSC (0x0002.5288330a) higher than block SCN (0x0000.00000000)
Page 1101348 failed with check code 6054

Dbverify-verification Complete

Total Pages examined:1205248
Total Pages processed (Data): 0
Total Pages Failing (Data): 0
Total Pages processed (Index): 1185185
Total Pages Failing (Index): 1
Total Pages processed (other): 2126
Total Pages processed (SEG): 0
Total Pages Failing (Seg): 0
Total Pages empty:17937
Total Pages Marked corrupt:1
Total Pages influx:0
Total Pages encrypted:0
Highest block scn:1385346762 (2.1385346762)

Sql> select * from V$database_block_corruption;

file# block# BLOCKS corruption_change# corruptio
---------- ---------- ---------- ------------------ ---------
1101348 1 0 fractured

Rman> blockrecover datafile block 1101348;

Starting recover at 2014-05-05 20:47:07
Using target database control file instead of recovery catalog
Allocated Channel:ora_disk_1
Channel ora_disk_1:sid=2936 Device Type=disk
Finished standby search, restored 1 blocks

Starting Media recovery
Media recovery complete, elapsed time:00:00:01

Finished recover at 2014-05-05 20:47:09

Sql> select * from V$database_block_corruption;

[oracle@dg_115 arch]$ dBV file=/tol/oradata/datafile/coredb/user_lesson_log_index08.dbf

Dbverify:release 11.2.0.1.0-production on Mon 5 20:47:20 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Dbverify-verification Starting:file =/tol/oradata/datafile/coredb/user_lesson_log_index08.dbf


Dbverify-verification Complete

Total Pages examined:1205248
Total Pages processed (Data): 0
Total Pages Failing (Data): 0
Total Pages processed (Index): 1185185
Total Pages Failing (Index): 0
Total Pages processed (other): 2126
Total Pages processed (SEG): 0
Total Pages Failing (Seg): 0
Total Pages empty:17937
Total Pages Marked corrupt:0
Total Pages influx:0
Total Pages encrypted:0
Highest block scn:1385361587 (2.1385361587)

No rows selected