Saturday 1 March 2014

Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01578: ORACLE data block corrupted

+++++
Issue
++++++
While doing sanity in oracle application gettting below error

Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01578: ORACLE data block corrupted (file # 378, block # 559510)
ORA-01110: data file 378: '+ERPTEST1_DATA/erptest1/datafile/apps_ts_tx_data.602.839483887'
ORA-26040: Data block was loaded using the NOLOGGING option

Solution :
--------
begin
apps.wf_local_synch.BULKSYNCHRONIZATION(P_ORIG_SYSTEM=>'ALL',
P_PARALLEL_PROCESSES=>2, P_LOGGING=>'LOGGING', P_RAISEERRORS=>TRUE,
P_TEMPTABLESPACE=>'APPS_TS_TX_IDX');
END;
/

No comments:

Post a Comment