We did expdp on AIX server with mutliple files using filesetsize=10G parameter and when we are importing into LInux database we are facing below errors:ORA-31693: Table data object "DBO_ACTIONAL_PROD"."ACT_SUBN_STATS_H_" failed to load/unload and is being skipped due to error:ORA-31640: unable to open dump file "/u01/app/oracle/export/utl01p/act04.dmp" for readORA-19505: failed to identify file "/u01/app/oracle/export/utl01p/act04.dmp"ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3 When you are using a cluster database it is possible for datapump workers to start on any of the available nodes unless you specify cluster=N. If the nodes that start the workers do not have access to the datapump directory they will be unable to process the files. This is proved out when you specify cluster=N to remove the other nodes from the equation. Use cluster=N to run the import from a single node of the RAC cluster which has file access.
理解IMPDP ORA-19505、ORA-31640错误
发布日期:2021-09-08 01:44:42
浏览次数:38
分类:技术文章
本文共 2182 字,大约阅读时间需要 7 分钟。
若在Oracle RAC集群数据库中,则可能Data Pump Worker数据泵工作进程在非发起本Expdp的节点上被分配并工作,除非指定了EXPDP参数CLUSTER=NO。 若启动该Workder进程的节点上相应的data pump目录没有合适的权限,则remote node上的Worker将无法正常工作。 可以利用cluster=no参数来Workaround这个由于RAC引起的ORA-19505错误。 [oracle@lab1 ~]$ oerr ora 19505 19505, 00000, "failed to identify file \"%s\"" // *Cause: call to identify the file returned an error // *Action: check additional messages, and check if the file exists 关于EXPDP/IMPDP的CLUSTER参数说明如下: CLUSTER Default: YES Purpose Determines whether Data Pump can use Oracle Real Application Clusters (Oracle RAC) resources and start workers on other Oracle RAC instances. Syntax and Description CLUSTER=[YES | NO] To force Data Pump Import to use only the instance where the job is started and to replicate pre-Oracle Database 11g release 2 (11.2) behavior, specify CLUSTER=NO. To specify a specific, existing service and constrain worker processes to run only on instances defined for that service, use the SERVICE_NAME parameter with the CLUSTER=YES parameter. Use of the CLUSTER parameter may affect performance because there is some additional overhead in distributing the import job across Oracle RAC instances. 关于该ORA-19505更多信息参考以下Note:
转载地址:https://blog.csdn.net/weixin_34310369/article/details/85545897 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!
发表评论
最新留言
哈哈,博客排版真的漂亮呢~
[***.90.31.176]2024年04月12日 21时35分35秒
关于作者
喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!
推荐文章
【题解】牛客 Planting Trees⭐⭐⭐ 【单调队列】
2019-04-26
DCMTK:测试框架内容Frame Content FG类
2019-04-26
DCMTK:Irradiation事件识别测试FG类
2019-04-26
DCMTK:测试文件是否使用DICOM Part 10格式
2019-04-26
DCMTK:根据DICOM第11部分媒体存储应用程序配置文件制作DICOMDIR
2019-04-26
ITK:两个图像的全局配准(BSpline)
2019-04-26
ITK:相互信息仿射
2019-04-26
ITK:转换三角网格为二进制图像
2019-04-26
ITK:使用FFT的归一化相关
2019-04-26
ITK:使用FFT与输入图像的掩码图像进行归一化相关
2019-04-26
ITK:用内核卷积图像
2019-04-26
ITK:颜色归一化相关
2019-04-26
ITK:二进制图像的近似距离图
2019-04-26
Boost:boost::source_location的用法测试程序
2019-04-26
Boost:BOOST_VERIFY_MSG扩展的用法测试程序
2019-04-26
Boost:是否支持sse2指令的测试程序
2019-04-26
Boost:是否支持sse4.1指令的测试程序
2019-04-26
Boost:同步化的测试程序
2019-04-26
Boost:原子API的用法测试程序
2019-04-26
Boost:原子性的用法测试程序
2019-04-26