question to repair "data block corrupted"
- From: Guang Mei <gmei@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 05 Feb 2010 09:55:03 -0500
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » question to repair "data block corrupted" - Guang Mei
