Live_Exceptions_Baseline job is failing with ORA-01578 error (Legacy KB ID CNC TS30583 )

Products

• CA eHealth

Issue/Introduction

This error can appear after a database load is done on this system.  This is because blocks go corrupt if the objects being recovered during load have nologging on them, which is the case with the eHealth indexes.  

Using the following query to confirm that the datafile number mentioned in the error is for NH_INDEX.

    select file#, name from v$datafile;

The ORA-01578 error message will not persist, because the block will not be accessed again after a brief period.  If there is a concern that this needs to be fixed immediately (for example, if error being seen repeatedly due to some job run ad hoc just after the load), then the following command can be run to resolve the issue:

    nhiDbMaint -rebuildAllIndexes

This command can take a long time to run, so it is generally not advised to run it.

Related Issues/Questions:
 Live_Exceptions_Baseline job is failing with ORA-01578 error
Oracle errors seen after database load

Problem Environment:
Error:"ORA-01578: ORACLE data block corrupted (file # n, block # 123456)"
eHealth


(Legacy KB ID CNC TS30583 )

Environment

Release: LHBASC99000-6.2-eHealth-Live Health Upgrade Elements
Component: