问题描述
客户的Oracle10204 RAC FOR Hp数据库执行EXPDP并行导出时出现了这个错误信息。
导出报错如下:
Export: Release 10.2.0.4.0 - 64bit Production ON Thursday, 12 January, 2012 6:10:00 Copyright (c) 2003, 2007, Oracle. ALL rights reserved. Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production WITH the Partitioning, REAL Application Clusters, Oracle Label Security, DATA Mining AND REAL Application Testing options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": parfile=/home/oracle/backup/moddb_par_mesadmin Estimate IN progress USING BLOCKS method... Processing object TYPE SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation USING BLOCKS method: 72.74 GB Processing object TYPE SCHEMA_EXPORT/USER 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/TABLESPACE_QUOTA Processing object TYPE SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA . . . Processing object TYPE SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object TYPE SCHEMA_EXPORT/TABLE/TRIGGER ORA-31693: TABLE DATA object "MESADMIN"."S_IFCPRODUCT" failed TO LOAD/unload AND IS being skipped due TO error: ORA-29913: error IN executing ODCIEXTTABLEPOPULATE callout ORA-31617: unable TO OPEN dump file "/archive/temp_exp/moddb_exp_mesadmin_3.dmp" FOR wr Processing object TYPE SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-31693: TABLE DATA object "MESADMIN"."PRODUCTHISTORY" failed TO LOAD/unload AND IS being skipped due TO error: ORA-29913: error IN executing ODCIEXTTABLEPOPULATE callout ORA-31617: unable TO OPEN dump file "/archive/temp_exp/moddb_exp_mesadmin_2.dmp" FOR wr Processing object TYPE SCHEMA_EXPORT/JOB Processing object TYPE SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA ORA-31693: TABLE DATA object "MESADMIN"."S_R_WIP" failed TO LOAD/unload AND IS being skipped due TO error: ORA-29913: error IN executing ODCIEXTTABLEPOPULATE callout ORA-31617: unable TO OPEN dump file "/archive/temp_exp/moddb_exp_mesadmin_2.dmp" FOR wr ORA-31693: TABLE DATA object "MESADMIN"."C_FGMSIF_PANELINFO" failed TO LOAD/unload AND IS being skipped due TO error: ORA-29913: error IN executing ODCIEXTTABLEPOPULATE callout ORA-31617: unable TO OPEN dump file "/archive/temp_exp/moddb_exp_mesadmin_5.dmp" FOR wr ORA-31693: TABLE DATA object "MESADMIN"."C_AC_PANEL_GRADE" failed TO LOAD/unload AND IS being skipped due TO error: ORA-29913: error IN executing ODCIEXTTABLEPOPULATE callout ORA-31617: unable TO OPEN dump file "/archive/temp_exp/moddb_exp_mesadmin_2.dmp" FOR wr . . exported "MESADMIN"."S_R_MOVEMENT" 191.2 MB 2070491 ROWS . . . . . exported "MESADMIN"."USERPROFILEATTRIBUTEHISTORY" 0 KB 0 ROWS . . exported "MESADMIN"."RTDRULETRACEHISTORY" 1.627 GB 3812462 ROWS . . exported "MESADMIN"."PRODUCT" 1.057 GB 2593517 ROWS Master TABLE "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file SET FOR SYSTEM.SYS_EXPORT_SCHEMA_01 IS: /archive/temp_exp/moddb_exp_mesadmin_1.dmp /archive/temp_exp/moddb_exp_mesadmin_2.dmp /archive/temp_exp/moddb_exp_mesadmin_3.dmp /archive/temp_exp/moddb_exp_mesadmin_4.dmp /archive/temp_exp/moddb_exp_mesadmin_5.dmp /archive/temp_exp/moddb_exp_mesadmin_6.dmp /archive/temp_exp/moddb_exp_mesadmin_7.dmp /archive/temp_exp/moddb_exp_mesadmin_8.dmp /archive/temp_exp/moddb_exp_mesadmin_9.dmp /archive/temp_exp/moddb_exp_mesadmin_10.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" completed WITH 5 error(s) at 06:22:57复制
专家解答
数据泵的并行度设置为10,同时向10个DUMPFILE中写入数据。在写入时出现ORA-31693、ORA-29913和ORA-31617错误。
发现对于RAC环境而言,Oracle会尝试将并行导出放到两个节点上,而由于DIRECTORY是本地磁盘,且在另外一个节点上没有建立同样的目录,因此打开文件报错的信息。
那么如果想要使用RAC上的并行导出,确保相同的目录在两个节点上同时存在。如果只想在一个节点上执行数据泵的导出那么就不要使用并行方式。
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
【纯干货】Oracle 19C RU 19.27 发布,如何快速升级和安装?
Lucifer三思而后行
605次阅读
2025-04-18 14:18:38
Oracle RAC 一键安装翻车?手把手教你如何排错!
Lucifer三思而后行
605次阅读
2025-04-15 17:24:06
XTTS跨版本迁移升级方案(11g to 19c RAC for Linux)
zwtian
499次阅读
2025-04-08 09:12:48
Oracle数据库一键巡检并生成HTML结果,免费脚本速来下载!
陈举超
483次阅读
2025-04-20 10:07:02
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
465次阅读
2025-04-22 00:20:37
Oracle 19c RAC更换IP实战,运维必看!
szrsu
441次阅读
2025-04-08 23:57:08
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
438次阅读
2025-04-22 00:13:51
【活动】分享你的压箱底干货文档,三篇解锁进阶奖励!
墨天轮编辑部
430次阅读
2025-04-17 17:02:24
火焰图--分析复杂SQL执行计划的利器
听见风的声音
372次阅读
2025-04-17 09:30:30
3月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
362次阅读
2025-04-15 14:48:05
TA的专栏
Java中间件
收录0篇内容
热门文章
一次Connection reset by peer的问题排查
2021-12-07 34119浏览
Java8-Stream: no instance(s) of type variable(s) R exist so that void conforms to R
2021-02-19 32411浏览
nginx: [emerg] "user" directive is not allowed here in /etc/nginx/conf.d/nginx.conf:1
2022-02-15 24307浏览
ORA-00904: "POLTYP": invalid identifier
2019-06-19 12939浏览
PageHelper排坑,处理排序失败: net.sf.jsqlparser.JSQLParserException
2022-05-19 12809浏览