-
Title
Post error ORA-01578 ORA-01110 ORA-26040 -
Description
Post stops with the following erors in the event log.
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 -
Cause
ORACLE data block corrupted
-
Resolution
ORA-01578: ORACLE data block corrupted (file # string, block # string)
Cause: The data block indicated was corrupted, mostly due to software errors.
Action: Try to restore the segment containing the block indicated. This may involve dropping the segment and recreating it.
You can get the segment name as follows. From the event log get the file_id and block_id and run the following sql putting in the right file_id and block_idsqlplus> SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME
2 FROM DBA_EXTENTS
3 WHERE FILE_ID = 55 AND 108192 BETWEEN BLOCK_ID
4 AND BLOCK_ID+BLOCKS -1;
SEGMENT_TYPE OWNER||'.'||SEGMENT_NAME
------------------ ------------------------------------------------
INDEX PARTITION TEST.TAB_N1
Alternatively, the error can be ignored by configuring the oramsglist file and the parameter SP_OPO_CONT_ON_ERR.
Here is how you can do it.
1. With Post stopped, go to vardir/data and edit oramsglist file.
2. Increment the number (2 digit number) on the first line by 3.
3. Add a 3 new lines at end of the oramsglist by inserting the numbers 1578 (which corresponds to ORA-01578) ,1110 (which corresponds to ORA-1110), 26040 (which corresponds to ORA-26040)
4. Save the file and exit
5. Go to sp_ctl and activate this paramter to tell Post to ignore the error.
sp_ctrl> set param SP_OPO_CONT_ON_ERR 1
sp_crl> start post
After some time revert back to the original oramsglist
sp_crl> stop post
sp_ctrl>set param SP_OPO_CONT_ON_ERR 0
sp_crl> start post
If you still see errors you will need to drop and recreate the segment