RAC expdp备份失败

最新推荐文章于 2024-10-01 22:53:33 发布

布丁很胖

最新推荐文章于 2024-10-01 22:53:33 发布

阅读量645

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/li66934791/article/details/83348573

版权

当在多节点RAC环境中使用expdp进行数据导出时，由于dump文件目的地未被所有节点共享，导致ORA-31693和ORA-31617错误。解决方法包括：确保所有节点都能访问到dump文件的挂载点，或者在执行expdp时使用CLUSTER=N参数，使得导出操作只在有权限的节点上运行。

摘要由CSDN通过智能技术生成

问题描述

报错信息如下

ORA-31693: Table data object "DYESBDB55_GXT"."WF_ACTINSTANCE" failed to load/unload and is being skipped due to error:

ORA-31617: unable to open dump file "/bak/expdpbak/DYESBDB55_GXT_04.dmp" for write

ORA-19505: failed to identify file "/bak/expdpbak/DYESBDB55_GXT_04.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

解决方案

CAUSE

The problem occurs when Datapump Export is being performed on a multi-node RAC where the dumpfile destination is not shared to all nodes for access. Since multiple nodes will be running the Datapump job, ALL nodes must have access to the mount point where the dump file will be written.

The issue is addressed in the following bug report which was closed with status 'Not a Bug':