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

最新推荐文章于 2024-10-05 15:25:14 发布

转载最新推荐文章于 2024-10-05 15:25:14 发布 · 927 阅读

CC 4.0 BY-SA版权

原文链接：http://blog.itpub.net/31394774/viewspace-2217567/

本文解决了一个在Oracle RAC环境中使用expdp进行数据导出时遇到的ORA-31693、ORA-31617、ORA-19505和ORA-27037等错误的问题。通过调整命令参数，特别是加入CLUSTER=N选项，确保导出操作只在一个有权限写入指定目录的节点上运行。

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参数后重新执行：

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

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

问题顺利解决。