操作系统：AIX 6
数据库版本：RAC 11.2.0.3双节点
执行命令：
expdp / directory=MYDUMP dumpfile=***0402_%U.dmp logfile=***0402.log flashback_scn=12815883891 parallel=4 compression=ALL
报错信息：
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 448 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object “HR”.“COUNTRIES” failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file “/backup/hr.dmp” for write
ORA-19505: failed to identify file “/backup/hr.dmp”
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object “HR”.“DEPARTMENTS” failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file “/backup/hr.dmp” for write
ORA-19505: failed to identify file “/backup/hr.dmp”
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
解决方法：
修改备份命令，增加CLUSTER=N参数后重新执行即可。
MOS相关文档：
DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-31617 ORA-19505 ORA-27037 In a RAC Environment (文档 ID 1597395.1)
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’:
Bug 11677316 - DATA PUMP UNABLE TO OPEN DUMP FILE ORA-31617 ORA-19505 ORA-27037
SOLUTION
- Share/mount the dumpfile destination with all RAC nodes performing the expdp
- OR -
- Use CLUSTER=N during Datapump so it will only run on the node which has the mount point and permissions to write to it.
