ORA-01578: ORACLE data block corrupted
                                                 Last update (2011-04-20 15:18:51)
                                                                                                                   Date added (2010-07-09 12:48:04)

Summary
Alert log show errors like:
ORA-01578: ORACLE data block corrupted (fi le # 26, block # 525385)
ORA-01115: IO error reading block from fil e 26 (block # 86699)
ORA-01110: data file 26: '/oracle/DwhProd/oradata9/DWH01/star_tab04.dbf'  
ORA-27071: unable to seek to desired position in file HPUX-ia64 Error: 9: Bad file number
The contents of alert log in more detail:
Corrupt block relative dba: 0x06880449 (file 26, block 525385)
Bad header found during user buffer read
Data in bad block:
 type: 0 format: 2 rdba: 0xcbc80449
 last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x00000001
 check value in block header: 0xce67
 computed block checksum: 0x0
Reread of rdba: 0x06880449 (file 26, block 525385) found same corrupted data
Fri Jul  9 04:39:36 2010
Corrupt Block Found
         TSN = 13, TSNAME = STAR_TAB
         RFN = 26, BLK = 525385, RDBA = 109577289
         OBJN = 2048395, OBJD = 2048395, OBJECT = PRODUCT_INSTANCE_DIM, SUBOBJECT = P3
         SEGMENT OWNER = SHADOW_DW, SEGMENT TYPE = Table Partition
Corrupt block relative dba: 0x0681d966 (file 26, block 121190)
Bad header found during user buffer read
Data in bad block:
 type: 2 format: 2 rdba: 0x9f01d966
 last change scn: 0x05a1.552aa39d seq: 0x1 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xa39d0201
 check value in block header: 0x854a
 computed block checksum: 0x0
Reread of rdba: 0x0681d966 (file 26, block 121190) found same corrupted data
Fri Jul  9 08:28:41 2010
Corrupt Block Found
         TSN = 13, TSNAME = STAR_TAB
         RFN = 26, BLK = 121190, RDBA = 109173094
         OBJN = 53683, OBJD = 3157756, OBJECT = CUSTOMER_DIM, SUBOBJECT = SYS_P361
         SEGMENT OWNER = SHADOW_DW, SEGMENT TYPE = Table Partition
Corrupt block relative dba: 0x06870006 (file 26, block 458758)
Bad header found during buffer read
Data in bad block:
 type: 2 format: 2 rdba: 0x9f070006
 last change scn: 0x05a1.516c0a66 seq: 0x1 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x0a660201
 check value in block header: 0x7d22
 computed block checksum: 0x0
Reread of rdba: 0x06870006 (file 26, block 458758) found same corrupted data
Fri Jul  9 08:58:11 2010
Corrupt Block Found
         TSN = 13, TSNAME = STAR_TAB
         RFN = 26, BLK = 458758, RDBA = 109510662
         OBJN = 53378, OBJD = 64216, OBJECT = ADDRESS_DIM, SUBOBJECT = SYS_P570
         SEGMENT OWNER = SHADOW_DW, SEGMENT TYPE = Table Partition
Workaround
1. Try to drop the segments that are corrupted.
2. Recreate the object in new tablespace.

*** Other segments stored in the same datafile***
SELECT DISTINCT(owner || ' - ' || segment_name || ' - ' || partition_name || ' - ' || segment_type ) SQL 
FROM dba_extents
WHERE file_id = 26 
AND segment_type NOT IN ('INDEX SUBPARTITION', 'INDEX');
Reviews
Filters
Search