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 14, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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 "<SCHEMA_NAME>"."SYS_EXPORT_SCHEMA_01": userid=<LOGIN>/********@<SID> SCHEMAS=<SCHEMA_NAME1>,<SCHEMA_NAME2> NETWORK_LINK=<DB_LINK_NAME> DIRECTORY=<DIRECTORY_NAME> LOGFILE=<LOG_NAME>.log COMPRESSION=ALL
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [INSERT INTO SYS.KU$_LIST_FILTER_TEMP_2@<DB_LINK_NAME> (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 "<SCHEMA_NAME>"."SYS_EXPORT_SCHEMA_01" WHERE process_order = :1]
ORA-08176: consistent read failure; rollback data not available
ORA-02063: preceding line from <NAME>
ORA-02063: preceding 2 lines from <DB_LINK_NAME>
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |