How To Handle Corrupt Block Problem In OSM Schema DB Instance
(Doc ID 1934081.1)
Last updated on AUGUST 15, 2024
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |