Heim >Datenbank >MySQL-Tutorial >expdp错误ORA-39029

expdp错误ORA-39029

WBOY
WBOYOriginal
2016-06-07 17:13:582355Durchsuche

源端hp-unix+oracle10g-r204-rac,目标端redhat+oracle10g。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=statistic

ORA-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 2

Job "SYS"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 13:53:52

alert.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 () 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

linux

Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel:Oracle中的高水位(HWM)Nächster Artikel:mysqldump 1449错误解决办法