Post stopped due to ORA-1578, or ORA-600, or ORA-1502 or ORA-08102 (4282491)

Post stopped due to ORA-1578, or ORA-600, or ORA-1502 or ORA-08102

Post gets Oracle errors ORA-01578, ORA-00600, ORA-01502, or ORA-08102.

These errors indicate that Oracle has found data block corruption either on the table or related indexes.

Notice: ORA-01502: index 'xxx.xxx_x' or partition of such index is in unusable state.

06/17/07 04:33 Process exited sp_opst  (for o.ep01-o.rp02 queue ProbQ) [pid = 27733] - exit(1)
06/17/07 04:33 Error: Unexpected Oracle error: ORA-08102: index key not found, obj# 1099412, dba 92342200 (2). (object name: "BOM"."CST_ITEM_COSTS") [sp_opst (for o.ep01-o.rp02 queue ProbQ)/27733]
06/17/07 04:33 Notice: ORA-08102: index key not found, obj# 1099412, dba 92342200 (2). [sp_opst(osp)/27733]

Warning: 15022 - Error posting ODR_UPDATE1 to table LINEAD6.LINE_AD. [sp_opst (for o.SERV-o.SERV queue post_line_a)/15294]
Notice: Oracle error: ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], []. rowid:AAEeTjACSAAAI1lAAs [sp_opst (for o.SERV-o.SERV queue post_line_a)/15294]
Error: 15033 - Failed to execute SQL on table LINEAD6.LINE_AD: ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], []. [sp_opst (for o.SERV-o.SERV queue post_line_a)/15294]"

ORA-01578: ORACLE data block corrupted (file # 55, block # 108192).ORA-01110: data file 55: '/oracle/data04/oradata/test1.dbf'.ORA-26040: Data block was loaded using the NOLOGGING option. (object name: "TEST"."TAB1") [sp_opst (for o.xxx-o.yyyy queue QUEUE1)/15565]
Notice: ORA-01578: ORACLE data block corrupted (file # 55, block # 108192).ORA-01110: data file 55: '/oracle/data04/oradata/test1.dbf'.ORA-26040

Oracle data block corruption on table or indexes causing post process to fail

WORKAROUND:

1. if the data block corruption occurs on the table itself, then disable this table for post 

sp_ctrl> set param SP_OPO_DISABLE_OBJECT_NUM <source object id for this table>

sp_ctrl> start post

Once you rebuild the table, then reset this parameter

sp_ctrl> stop post

sp_ctrl> reset param SP_OPO_DISABLE_OBJECT_NUM

And compare/repair this table to bring it back in sync with source data.

2. If the data block corruption occurs on the index, then rebuild the problem index and restart post

3. For ORA-600 errors, please contact Oracle support.

SP-OPO01006