RAC单个节点执行expdp提示ORA-31693 ORA-31617 ORA-19505 ORA-27037错误

1.在RAC单节点执行expdp，出现ORA-31693 ORA-31617 ORA-19505 ORA-27037错误

 

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

 

2.查找解决方案 

在MOS上使用关键字“expdp ORA-27037”查找文章：

DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-31617 ORA-19505 ORA-27037 In a RAC Environment (文档 ID 1597395.1)

 

1. Share/mount the dumpfile destination with all RAC nodes performing the expdp 

- OR - 

2. Use CLUSTER=N during Datapump so it will only run on the node which has the mount point and permissions to write to it.

 

修改备份命令，增加CLUSTER=N参数后重新执行：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

oracle@cwgsdb1:/backup$ expdp directory=dir_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2 CLUSTER=N Export: Release 11.2.0.4.0 - Production on Thu Oct 25 17:18:54 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Username: system Password:  Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02":  system/******** directory=dir_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2 CLUSTER=N  Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 448 KB . . exported "HR"."COUNTRIES"                            6.367 KB      25 rows . . exported "HR"."DEPARTMENTS"                          7.007 KB      27 rows . . exported "HR"."EMPLOYEES"                            16.80 KB     107 rows . . exported "HR"."JOBS"                                 6.992 KB      19 rows . . exported "HR"."JOB_HISTORY"                          7.054 KB      10 rows . . exported "HR"."LOCATIONS"                            8.273 KB      23 rows . . exported "HR"."REGIONS"                              5.476 KB       4 rows 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 Master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:   /backup/hr.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at Thu Oct 25 17:19:21 2018 elapsed 0 00:00:13

 

问题顺利解决。