question to repair "data block corrupted"
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-lReceived on Fri Feb 05 2010 - 08:55:03 CST