Datapump Export of DG Standby Database using Network Link fails with ORA-08176 ORA-02063 ORA-06512 errors (Doc ID 2097898.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The data pump export fails with the following errors

Export: Release 12.1.0.2.0 - Production on Wed Jan 13 20:38:28 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": userid=system/********@frfpmdb SCHEMAS=STS,FPMG NETWORK_LINK=FRFPM DIRECTORY=EXPORT_DIR LOGFILE=export_FRFPM_20160113.log COMPRESSION=ALL
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [INSERT INTO SYS.KU$_LIST_FILTER_TEMP_2@FRFPM (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 "SYSTEM"."SYS_EXPORT_SCHEMA_01" WHERE process_order = :1]
ORA-08176: consistent read failure; rollback data not available
ORA-02063: preceding line from FRFPMDB
ORA-02063: preceding 2 lines from FRFPM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11254
----- PL/SQL Call Stack -----
object line object
handle number name
0x126748898 27119 package body SYS.KUPW$WORKER
0x126748898 11281 package body SYS.KUPW$WORKER
0x126748898 2135 package body SYS.KUPW$WORKER
0x10a746f98 2 anonymous block
ALTER SESSION ENABLE PARALLEL DML
ALTER SESSION ENABLE PARALLEL DML
KUPP$PROC.WHATS_MY_ID
KUPP$PROC.WHATS_MY_ID
worker max message number: 1000
Full cluster access allowed
Testing ku$_list_filter_temp_2 on remote database 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms