expdp与ORA-39147异常

最新推荐文章于 2021-04-14 16:31:25 发布

congzhijian2497

最新推荐文章于 2021-04-14 16:31:25 发布

阅读量335

点赞数

文章标签：数据库

今天发现crontab中一个数据泵导出任务出现异常，错误信息如下。

[oracle@w1]$ /apps/oracle/admin/msh/expdp_tb_affirm_weather.sh

Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 27 November, 2009 18:01:51

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_02 for user MSUSER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39147: cannot migrate Data Pump queue table ownership to this instance

[@more@]

每天工作很正常，为什么突然出现故障了呢？先根据错误号查一下信息。

[oracle@w1 ~]$ oerr ora 39147
39147, 00000, "cannot migrate Data Pump queue table ownership to this instance"
// *Cause: There are active Data Pump jobs running on another instance in a
// RAC. All concurrent, active Data Pump jobs must be run on the same
// instance.
// *Action: Start this job on the same instance where other active Data Pump
// jobs are running, or wait until they finish.

这个故障时在RAC架构中的一个bug。如果在不同的instance上，同时做expdp或impdp操作会触发上诉bug.。
一个解决办法是，避免在两个instance上部署数据泵操作。

数据库环境为：
Oracle版本：10.2.0.4
OS: HP-UX 11i
DB架构：2节点的RAC

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22927800/viewspace-1029158/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22927800/viewspace-1029158/