Data pump export backup failed due to below mentioned oracle errors. It was failed due to verification tests failed on temp file: temp01. As a part of solution, I have delete old temporary tablespace and added new temporary tablespace with new temp file.
Data Pump Export Error Logs:
Export: Release 11.2.0.1.0 - Production on Mon Jun 20 11:47:01 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production Starting "SYSTEM"."SYS_EXPORT_FULL_09": system/******** directory=data_pump_bkup dumpfile=full_db_export.dmp logfile=export.log full=y ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [] ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 201: '/u02/oradata/db1/temp01.dbf' ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.KUPW$WORKER", line 8159 ----- PL/SQL Call Stack ----- object line object handle number name 0x1ed213be8 19028 package body SYS.KUPW$WORKER 0x1ed213be8 8191 package body SYS.KUPW$WORKER 0x1ed213be8 8980 package body SYS.KUPW$WORKER 0x1ed213be8 1651 package body SYS.KUPW$WORKER 0x1b97859d0 2 anonymous block ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WO ORA-01187: cannot read from file because it failed verification te ORA-01110: data file 201: '/u02/oradata/db1/temp01.dbf' ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.KUPW$WORKER", line 8159 ----- PL/SQL Call Stack ----- object line object handle number name 0x1ed213be8 19028 package body SYS.KUPW$WORKER 0x1ed213be8 8191 package body SYS.KUPW$WORKER 0x1ed213be8 8980 package body SYS.KUPW$WORKER 0x1ed213be8 1651 package body SYS.KUPW$WORKER 0x1b97859d0 2 anonymous block Job "SYSTEM"."SYS_EXPORT_FULL_09" stopped due to fatal error at 11:
Solution:
Here is article on Delete old temporary tablespace and add new temporary tablespace with new temp file.
Thank you. Stay Tune. 🙂
