question to repair "data block corrupted"

From: Guang Mei <gmei_at_prospectiv.com>
Date: Fri, 05 Feb 2010 09:55:03 -0500
Message-ID: <4B6C3147.1090306_at_prospectiv.com>



Oracle 10g on Linux. I got

ERROR at line 1:

ORA-01578: ORACLE data block corrupted (file # 36, block # 74946)
ORA-01110: data file 36: '/d30/oradata/ES_DEV/USER_DATA/ES_DEV_udata_05.dbf'
ORA-06512: at "SYS.DBMS_STATS", line 13313
ORA-06512: at "SYS.DBMS_STATS", line 13659
ORA-06512: at "SYS.DBMS_STATS", line 13737
ORA-06512: at "SYS.DBMS_STATS", line 13696
ORA-06512: at line 1

and I ran the below query, found the corrupted block pointing to an index. I rebuild the index online and ran the below sql again and found nothing (which means the new index is at different blocks) :

select owner, segment_name, segment_type from dba_extents where file_id = 36 and 74946 between block_id and block_id + blocks -1;

But now when I ran dbv (see result below) the block is still marked corrupted, do I need to do anything now? Does oracle "automatically" fix/repair the block when it is written next time? or does it need to be repaired now? BTW, we do not use RMAN.
Thanks.

dbv file=/d30/oradata/ES_DEV/USER_DATA/ES_DEV_udata_05.dbf BLOCKSIZE=16384

DBVERIFY: Release 10.2.0.2.0 - Production on Fri Feb 5 09:24:35 2010

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

DBVERIFY - Verification starting : FILE = /d30/oradata/ES_DEV/USER_DATA/ES_DEV_udata_05.dbf Page 74946 is marked corrupt
Corrupt block relative dba: 0x090124c2 (file 36, block 74946) Bad check value found during dbv:
Data in bad block:
 type: 6 format: 2 rdba: 0x090124c2
 last change scn: 0x0003.821f8499 seq: 0x1 flg: 0x04  spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x84990601
 check value in block header: 0xfb19
 computed block checksum: 0xd1b1

DBVERIFY - Verification complete

Total Pages Examined         : 131072
Total Pages Processed (Data) : 106403
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 16137
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1428
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 7103
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0
Highest block SCN            : 3597512876 (3.3597512876)
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 05 2010 - 08:55:03 CST

Original text of this message