oracle 31640,理解IMPDP ORA-19505、ORA-31640错误

若在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:

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 read

ORA-19505: failed to identify file "/u01/app/oracle/export/utl01p/act04.dmp"

ORA-27037: unable to obtain file status

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

Additional 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.