expdp错误ORA-39029

源端hp-unix+Oracle10g-r204-rac，目标端RedHat+oracle10g。
在目标端使用network_link导出，报错如下：
rm /opt/oradir/expdp.dmp
expdp "sys/oracle as sysdba" directory=oradir network_link=portal95 schemas=rbt dumpfile=expdp.dmp logfile=expdp.log exclude=statisticORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW02" prematurely terminated
ORA-31671: Worker process DW02 had an unhandled exception.
ORA-12801: error signaled in parallel query server
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-29400: data cartridge error
KUP-04038: internal error: kupax-meta1
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 78
ORA-06512: at "SYS.KUPW$WORKER", line 1345
ORA-06512: at line 2Job "SYS"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 13:53:52alert.log
首先看到的错误是：
Thu May 24 13:51:34 2012
The value （30） of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=38, OS id=5089
         to execute - SYS.KUPM$MCP.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS", "KUPC$C_1_20120524135135", "KUPC$S_1_20120524135135", 0）;
kupprdp: worker process DW01 started with worker id=1, pid=39, OS id=5091
         to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS"）;
kupprdp: worker process DW02 started with worker id=2, pid=40, OS id=5096
         to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS"）;
kupprdp: worker process DW03 started with worker id=3, pid=42, OS id=5098
         to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS"）;
kupprdp: worker process DW04 started with worker id=4, pid=43, OS id=5100
         to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS"）;
kupprdp: worker process DW05 started with worker id=5, pid=44, OS id=5102
         to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS"）;
kupprdp: worker process DW06 started with worker id=6, pid=45, OS id=5104
         to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS"）;
kupprdp: worker process DW07 started with worker id=7, pid=46, OS id=5106
         to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS"）;
kupprdp: worker process DW08 started with worker id=8, pid=47, OS id=5108
         to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_05", "SYS"）;
Thu May 24 13:52:15 2012经查，该错误是备份时创建备份主表（Master Table）产生的（使用类似CREATE TABLE <table_name> （<columns_list>） INITRANS 10 MAXTRANS 30语句创建），提示参数MAXTRANS已经被废弃而已，是个bug，略过。
继续往下看：
Memory Notification: Library Cache Object loaded into SGA
Heap size 2048K exceeds notification threshold （2048K）
KGL object name :SYS.KUPC$C_1_20120524135135

Oracle 10g ORA-07445 RAC环境下一个案例Oracle教程：重做日志文件基本维护相关资讯 Oracle高级培训

delete表的数据后恢复（08/30/2012 08:59:58）
使用ASH信息，发现高CPUsession （08/14/2012 07:21:32）
如何阅读Oracle Errorstack Output （08/14/2012 07:15:47）

Oracle Apps Patching:adpatch（（08/16/2012 15:41:37）
话说V$SQL_MONITOR （08/14/2012 07:19:54）
Oracle Apps DBA工具:ADADMIN使用（08/14/2012 07:00:09）

本文评论查看全部评论（0）