impdp遭遇ORA-39029、ORA-31671、ORA-06512
o
[oracle@rac1 ~]$ impdp \/ as sysdba \ directory=expdp dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog REMAP_TABLESPACE=wxlun:wxlun_DATA REMAP_SCHEMA=wxlun:wxlun0402Import: Release 11.2.0.3.0 - Production on Thu Apr 2 10:46:29 2015Copyrig
[oracle@rac1 ~]$ impdp \'/ as sysdba \' directory=expdp dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog REMAP_TABLESPACE=wxlun:wxlun_DATA REMAP_SCHEMA=wxlun:wxlun0402 Import: Release 11.2.0.3.0 - Production on Thu Apr 2 10:46:29 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_FULL_01": "/******** AS SYSDBA" directory=expdp dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog REMAP_TABLESPACE=wxlun:wxlun_DATA REMAP_SCHEMA=wxlun:wxlun0402 Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"wxlun0402" already exists ------用户已创建，报错忽略 Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ---下面开始报错--- ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name "DW00" prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc) ORA-06512: at "SYS.KUPW$WORKER", line 1838 ORA-06512: at line 2 ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order] ORA-19505: failed to identify file "/u01/oracle/expdp/wxlun0402.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9001 ----- PL/SQL Call Stack ----- object line object handle number name 0x17c15e530 20462 package body SYS.KUPW$WORKER 0x17c15e530 9028 package body SYS.KUPW$WORKER 0x17c15e530 4185 package body SYS.KUPW$WORKER 0x17c15e530 9725 package body SYS.KUPW$WORKER 0x17c15e530 1775 package body SYS.KUPW$WORKER 0x172f16550 2 anonymous block ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 3 with process name "DW00" prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc) ORA-06512: at "SYS.KUPW$WORKER", line 1838 ORA-06512: at line 2 ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order] ORA-19505: failed to identify file "/u01/oracle/expdp/wxlun0402.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9001 ----- PL/SQL Call Stack ----- object line object handle number name 0x17c15e530 20462 package body SYS.KUPW$WORKER 0x17c15e530 9028 package body SYS.KUPW$WORKER 0x17c15e530 4185 package body SYS.KUPW$WORKER 0x17c15e530 9725 package body SYS.KUPW$WORKER 0x17c15e530 1775 package body SYS.KUPW$WORKER 0x172f16550 2 anonymous block ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 5 with process name "DW00" prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc) ORA-06512: at "SYS.KUPW$WORKER", line 1838 ORA-06512: at line 2 ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order] ORA-19505: failed to identify file "/u01/oracle/expdp/wxlun0402.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9001 ----- PL/SQL Call Stack ----- object line object handle number name 0x17c15e530 20462 package body SYS.KUPW$WORKER 0x17c15e530 9028 package body SYS.KUPW$WORKER 0x17c15e530 4185 package body SYS.KUPW$WORKER 0x17c15e530 9725 package body SYS.KUPW$WORKER 0x17c15e530 1775 package body SYS.KUPW$WORKER 0x172f16550 2 anonymous block ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 7 with process name "DW00" prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc) ORA-06512: at "SYS.KUPW$WORKER", line 1838 ORA-06512: at line 2 ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order] ORA-19505: failed to identify file "/u01/oracle/expdp/wxlun0402.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9001 ----- PL/SQL Call Stack ----- object line object handle number name 0x17c15e530 20462 package body SYS.KUPW$WORKER 0x17c15e530 9028 package body SYS.KUPW$WORKER 0x17c15e530 4185 package body SYS.KUPW$WORKER 0x17c15e530 9725 package body SYS.KUPW$WORKER 0x17c15e530 1775 package body SYS.KUPW$WORKER 0x172f16550 2 anonymous block ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 9 with process name "DW00" prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc) ORA-06512: at "SYS.KUPW$WORKER", line 1838 ORA-06512: at line 2 ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order] ORA-19505: failed to identify file "/u01/oracle/expdp/wxlun0402.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9001 ----- PL/SQL Call Stack ----- object line object handle number name 0x17c15e530 20462 package body SYS.KUPW$WORKER 0x17c15e530 9028 package body SYS.KUPW$WORKER 0x17c15e530 4185 package body SYS.KUPW$WORKER 0x17c15e530 9725 package body SYS.KUPW$WORKER 0x17c15e530 1775 package body SYS.KUPW$WORKER 0x172f16550 2 anonymous block ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 11 with process name "DW00" prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc) ORA-06512: at "SYS.KUPW$WORKER", line 1838 ORA-06512: at line 2 ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_01" WHERE process_order between :3 AND :4 【本文来自鸿网互联 (http://www.68idc.cn)】AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order] ORA-19505: failed to identify file "/u01/oracle/expdp/wxlun0402.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9001 ----- PL/SQL Call Stack ----- object line object handle number name 0x17c15e530 20462 package body SYS.KUPW$WORKER 0x17c15e530 9028 package body SYS.KUPW$WORKER 0x17c15e530 4185 package body SYS.KUPW$WORKER 0x17c15e530 9725 package body SYS.KUPW$WORKER 0x17c15e530 1775 package body SYS.KUPW$WORKER 0x172f16550 2 anonymous block Import> exit ^ [oracle@rac1 ~]$ logout
登录后复制
由于是在Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS报的错，错误和统计信息有关，网上介绍说是一个bug，impdp时加上EXCLUDE=STATISTICS，导入后手动收集统计信息。
尝试如下，导入完成：
[oracle@rac1 ~]$ impdp \'/ as sysdba \' directory=expdp dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog REMAP_TABLESPACE=wxlun:wxlun_DATA REMAP_SCHEMA=wxlun:wxlun0402 EXCLUDE=STATISTICS Import: Release 11.2.0.3.0 - Production on Thu Apr 2 12:52:04 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Master table "SYS"."SYS_IMPORT_FULL_02" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_FULL_02": "/******** AS SYSDBA" directory=expdp dumpfile=wxlun0402.dmp logfile=wxlun0402.impdplog REMAP_TABLESPACEwxlun:wxlun_DATA REMAP_SCHEMA=wxlun:wxlun0402 EXCLUDE=STATISTICS Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"wxlun0402" already exists Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/COMMENT Job "SYS"."SYS_IMPORT_FULL_02" completed with 1 error(s) at 13:26:19
登录后复制
本站声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
AI Hentai Generator
免费生成ai无尽的。
热门文章
R.E.P.O.能量晶体解释及其做什么（黄色晶体）
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳图形设置
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
刺客信条阴影：贝壳谜语解决方案
2 周前
By DDD
R.E.P.O.如果您听不到任何人，如何修复音频
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25：如何解锁Myrise中的所有内容
4 周前
By 尊渡假赌尊渡假赌尊渡假赌
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
热门话题
主板上的数字音频输出接口-SPDIF OUT
Jan 14, 2024 pm 04:42 PM
主板上SPDIFOUT连接线序最近我遇到了一个问题，就是关于电线的接线顺序。我上网查了一下，有些资料说1、2、4对应的是out、+5V、接地；而另一些资料则说1、2、4对应的是out、接地、+5V。最好的办法是查看你的主板说明书，如果找不到说明书，你可以使用万用表进行测量。首先找到接地，然后就可以确定其他的接线顺序了。主板vdg怎么接线连接主板的VDG接线时，您需要将VGA连接线的一端插入显示器的VGA接口，另一端插入电脑的显卡VGA接口。请注意，不要将其插入主板的VGA接口。完成连接后，您可以
btc交易app怎么安装注册？
Feb 21, 2025 pm 07:09 PM
本篇文章将详细介绍如何安装和注册比特币交易应用。比特币交易应用允许用户管理和交易比特币等加密货币。文章逐步指导用户完成安装和注册过程，包括下载应用程序、创建账户、进行身份验证和首次存款。文章的目标是为初学者提供清晰易懂的指南，帮助他们轻松进入比特币交易的世界。
欧易交易所下载官方入口
Feb 21, 2025 pm 07:51 PM
欧易，又称OKX，是一个全球领先的加密货币交易平台。文章提供了欧易官方安装包的下载入口，方便用户在不同设备上安装欧易客户端。该安装包支持 Windows、Mac、Android 和 iOS 系统，用户可根据自己的设备类型选择相应版本下载。安装完成后，用户即可注册或登录欧易账户，开始交易加密货币和享受平台提供的其他服务。
全球数字货币交易十大APP推荐（2025货币交易软件排名）
Mar 12, 2025 pm 05:48 PM
本文推荐全球十大数字货币交易APP，涵盖币安(Binance)、OKX、火币(Huobi Global)、Coinbase、Kraken、Gate.io、KuCoin、Bitfinex、Gemini和Bitstamp。这些平台在交易对数量、交易速度、安全性、合规性、用户体验等方面各有特色，例如币安以其高交易速度和广泛服务闻名，而Coinbase则更适合新手用户。选择适合自己的平台需要综合考虑自身需求和风险承受能力。 了解全球主流数字货币交易平台，助您安全高效进行数字资产交易。
虚拟币三大龙头app是哪三个？
Mar 04, 2025 pm 08:51 PM
虚拟货币市场蓬勃发展，众多交易平台应运而生。本文将介绍虚拟货币领域的三大龙头应用程序，它们以出色的用户体验、强大的安全性和丰富的功能而著称。这些应用程序包括币安（Binance）、芝麻开门（gate.io）和 欧易（okx），它们为投资者提供了便捷、安全的途径，可以购买、出售、交易和跟踪虚拟货币。
数字货币app交易软件哪个最好用 数字货币交易软件大盘点
Mar 07, 2025 pm 06:45 PM
没有单一“最好用”的数字货币交易App，选择取决于个人需求。1. OKX功能强大，币种丰富；2. Binance流动性高，交易类型多样；3. Gate.io提供质押挖矿等独特功能；4. Huobi Global界面友好，多语言支持；5. Kraken注重安全性；6. Coinbase适合新手，注重用户教育。 选择时需考虑安全性、流动性、手续费、功能、用户体验等等因素。
十大虚拟数字币交易平台2025排名 虚拟币app交易所前十排名
Feb 21, 2025 pm 09:03 PM
本文介绍了 10 个主流的加密货币交易所，涵盖了它们的成立时间、服务范围、安全性、流动性、交易费用等基本信息。这些交易所包括：OKX、Binance、Gate.io、Bitget、Coinbase、Huobi、KuCoin、Crypto.com、Gemini 和 Kraken。
数字货币交易平台2025
Mar 04, 2025 pm 07:06 PM
本文根据全球信息，整理了全球领先的虚拟数字货币交易平台排名，包括Binance（币安）、OKX、Gate.io、Huobi（火币）、Coinbase、Kraken、Crypto.com、bitget、KuCoin和Bitstamp等。这些平台在用户数量、交易量、交易品种、安全性、合规性等方面各有特色，例如币安以其庞大的用户群和广泛的交易选择着称，Coinbase则以其在美国市场的领先地位和易用性而闻名。 选择合适的交易平台需要根据自身需求，权衡安全性、费用、交易品种等因素。
