匿名用户expdp 并行导出报错 ORA-31693 ORA-29913 ORA-39068
请教大佬,我的数据库版本是oracle 11.2.0.1,单实例。使用expdp命令导出时,并行度为1时是正常的,超过1会报错。请问是什么原因?有什么办法解决吗?下图是使用不同的并行度,两次导出的过程。
我来答
添加附件
收藏
复制链接
微信扫码分享
在小程序上查看
分享
添加附件
问题补充
3条回答
默认
最新
很大可能是Bug,11.2.0.2 的expdp问题非常多,建议该版本不要用并行,或相同的测试在11.2.0.4上进行测试验证下效果。
评论
有用 0类似于这个 Bug 18447188 - ORA-1 has occured after applying the fix of bug:18163767 (Doc ID 18447188.8) To BottomTo Bottom

Description
Exporting to an External Table can sometimes cause a deadlock.
One of such deadlock has been fixed by bug:18163767 so that deadlocked
operation would be retried. However, after applying the fix for bug:18163767
export session may still fail due to unexpected ORA-1 error occurring during
the retry of the operation after the ORA-60 deadlock.
Rediscovery Notes
You might have encountered this bug if all of following conditions are true.
- you are running multiple export (expdp) commands simultaneously
- expdp uses external table method (access_method=external_table)
- patch to bug:18163767 has been applied
- export session is failing with unexpected ORA-1 error like the following:
------------------------------------------------------------------
exported "TEST"."TEST_TBL22":"TEST_TBL22_P3" 139.4 KB 59 rows
ORA-31693: "Table data object "TEST"."TEST_TBL22":"TEST_TBL22_P4"
failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-39068: invalid master table data in row with PROCESS_ORDER=4:1000001
ORA-00001: unique constraint (SYSTEM.SYS_C001466840) violated
ORA-06512: at "SYS.KUPF$FILE", line 3720
ORA-06512: line 1
------------------------------------------------------------------
Workaround
Re-attemp export, or execute less number of exports at the same time.
重新尝试导出,或同时执行较少数量的导出。
临时解决办法就是再次尝试导出或者不用并行。
评论
有用 0回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏


