How To Handle Corrupt Block Problem In OSM Schema DB Instance (Doc ID 1934081.1)

Last updated on AUGUST 17, 2017

Applies to:

Oracle Communications Order and Service Management - Version 7.0.3 to 7.2.4 [Release 7.0.0 to 7.2]
Information in this document applies to any platform.
Review relevance March 16, 2016

Goal

Sometimes there are DB block corruption problems happening in OSM DB instance, how do we handle this problem in general?

Below is a real life exmple -

In DB alert file, corrupt block (bad block) problems are found,

Tue Oct 07 15:39:55 2014
Hex dump of (file 267, block 2005351) in trace file /oradb/OSMDB/orabin/diag/rdbms/osmdb/OSMDB/trace/OSMDB_m001_21982.trc
Corrupt block relative dba: 0x42de9967 (file 267, block 2005351)
Bad header found during validation
Data in bad block:
 type: 6 format: 2 rdba: 0x42de9964
 last change scn: 0x0c22.7c0548c1 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x48c10601
 check value in block header: 0x293e
 computed block checksum: 0x0
Reread of blocknum=2005351, file=/oradb/OSMDB/oradata6/large_data_new10.dbf. found same corrupt data
Reread of blocknum=2005351, file=/oradb/OSMDB/oradata6/large_data_new10.dbf. found same corrupt data
Reread of blocknum=2005351, file=/oradb/OSMDB/oradata6/large_data_new10.dbf. found same corrupt data
Reread of blocknum=2005351, file=/oradb/OSMDB/oradata6/large_data_new10.dbf. found same corrupt data
Reread of blocknum=2005351, file=/oradb/OSMDB/oradata6/large_data_new10.dbf. found same corrupt data
Checker run found 1 new persistent data failures

Tue Oct 07 23:36:57 2014
Hex dump of (file 255, block 2831774) in trace file /oradb/OSMDB/orabin/diag/rdbms/osmdb/OSMDB/trace/OSMDB_ora_21619.trc
Corrupt block relative dba: 0x3feb359e (file 255, block 2831774)
Bad header found during validation
Data in bad block:
 type: 6 format: 2 rdba: 0x3feb359b
 last change scn: 0x0c22.7c108115 seq: 0x1 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x81150601
 check value in block header: 0x4fb6
 computed block checksum: 0x0
Reread of blocknum=2831774, file=/oradb/OSMDB/oradata6/large_data_new06.dbf. found same corrupt data
Reread of blocknum=2831774, file=/oradb/OSMDB/oradata6/large_data_new06.dbf. found same corrupt data
Reread of blocknum=2831774, file=/oradb/OSMDB/oradata6/large_data_new06.dbf. found same corrupt data
Reread of blocknum=2831774, file=/oradb/OSMDB/oradata6/large_data_new06.dbf. found same corrupt data
Reread of blocknum=2831774, file=/oradb/OSMDB/oradata6/large_data_new06.dbf. found same corrupt data


Tue Oct 07 23:41:11 2014
Hex dump of (file 258, block 3145451) in trace file /oradb/OSMDB/orabin/diag/rdbms/osmdb/OSMDB/trace/OSMDB_ora_21046.trc
Corrupt block relative dba: 0x40affeeb (file 258, block 3145451)
Bad header found during validation
Data in bad block:
 type: 6 format: 2 rdba: 0x40affee8
 last change scn: 0x0c22.7c0548c1 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x48c10601
 check value in block header: 0xc377
 computed block checksum: 0x0
Reread of blocknum=3145451, file=/oradb/OSMDB/oradata6/large_data_new09.dbf. found same corrupt data
Reread of blocknum=3145451, file=/oradb/OSMDB/oradata6/large_data_new09.dbf. found same corrupt data
Reread of blocknum=3145451, file=/oradb/OSMDB/oradata6/large_data_new09.dbf. found same corrupt data
Reread of blocknum=3145451, file=/oradb/OSMDB/oradata6/large_data_new09.dbf. found same corrupt data
Reread of blocknum=3145451, file=/oradb/OSMDB/oradata6/large_data_new09.dbf. found same corrupt data

Searching for tables affected gets following results



File_ID   Block_no   Tablespace_name  Segment_type         Segment_name                   Partition_name
========================================================================================================
267     2005351     LARGE_DATA_NEW    TABLE SUBPARTITION  OM_ORCH_COMPLETION_DEPENDENCY  SYS_SUBP12380
258     3145451     LARGE_DATA_NEW    TABLE SUBPARTITION  OM_HIST$ORCH_DEPENDENCY        SYS_SUBP12332
255     2831774     LARGE_DATA_NEW    TABLE SUBPARTITION  OM_HIST$FLOW                   SYS_SUBP11969

 





Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms