errors with EXPDP command
586769Mar 27 2008 — edited Nov 6 2012we have been experiencing problems with our DataPump exports over the last few weeks, and I have been unable to determine the cause of the problem. Any help would be appreciated.
The following command is being used:
expdp system/xxxxxx@ORACLE_SID full=y directory=DUMP_DIR dumpfile=DUMPFILE.PMPlogfile=expdpDUMPFILE.log
The export will run for 30 - 40 minutes, and will then fail with the following errors:
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 1297
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 6983
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 2761
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10804
ORA-02354: error in exporting/importing data
ORA-01891: Datetime/Interval internal error
Job "SYSTEM"."SYS_EXPORT_FULL_56" stopped due to fatal error at 00:41:53
ORA-39014: One or more workers have prematurely exited.
The export files are generally 9-10 GB, and will work for one or two nights, and then fail for 2-3 night. The problem has been consistent, but will occasionally work. We are running Oracle 10g in a 2 server RAC environment, and the export will not work consistently on either server.
Any help or suggestions would be appreciated.
Harlyn