Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [INSERT INTO SYS.KU$_LIST_FILTER_TEMP_2

Kiran SonawaneJan 7 2016 — edited Jan 14 2016

I getting error while doing datapump export using dblink from read only physical standby database

expdp system/xxx parfile=expdp_xxdr.par

expdp_xxdr.par

directory=datapump

network_link=xxdr

full=y

dumpfile=standby_database.dmp

logfile=standby_database.log

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

Starting "EXPORT"."SYS_EXPORT_TABLE_03": export/******** parfile=expdp_xxdr.par

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [INSERT INTO SYS.KU$_LIST_FILTER_TEMP_2@xxDR (process_order,duplicate,object_schema,object_name,base_process_order,parent_process_order) SELECT process_order,duplicate,object_schema,object_name,base_process_order,parent_process_order FROM "EXPORT"."SYS_EXPORT_TABLE_03" WHERE process_order = :1]

ORA-08176: consistent read failure; rollback data not available

ORA-02063: preceding line from xxdv

ORA-02063: preceding 2 lines from xxDR

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 11259

----- PL/SQL Call Stack -----

object line object

handle number name

0x851c0100 27116 package body SYS.KUPW$WORKER

0x851c0100 11286 package body SYS.KUPW$WORKER

0x851c0100 2135 package body SYS.KUPW$WORKER

0x8981bac0 2 anonymous block

ALTER SESSION ENABLE PARALLEL DML

KUPP$PROC.WHATS_MY_ID

worker max message number: 1000

Full cluster access allowed

Testing ku$_list_filter_temp_2 on remote database

bind variable is: -55

Remote temp filter list stmt is: INSERT INTO SYS.KU$_LIST_FILTER_TEMP_2@xxDR (process_order,duplicate,object_schema,object_name,base_process_order,parent_process_order) SELECT process_order,duplicate,object_schema,object_name,base_process_order,parent_process_order FROM "EXPORT"."SYS_EXPORT_TABLE_03" WHERE process_order = :1

In procedure DETERMINE_FATAL_ERROR with ORA-08176: consistent read failure; rollback data not available