expdp ORA-31693 ORA-31617 ORA-19505 ORA-27037
2024-10-12 19:40:48
使用expdp并行导出数据的时候报如下错误:
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_01": system/******** schemas=test directory=expdp_dir dumpfile=test_%u.dmp filesize=10g parallel=4 logfile=expdpfull.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 32.85 GB
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/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-31693: Table data object "test"."WF_HIST" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/home/oracle/dump/test_03.dmp" for write
ORA-19505: failed to identify file "/home/oracle/dump/test_03.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
原因和解决方法:
在rac环境使用并行导出时,系统会尝试同时写文件到rac中的节点。如果导出目录是本地磁盘的话,导出时候就会报错,出现上面的现象。
解决方法:导出的时候添加参数cluster=no
最新文章
- 浅显易懂的理解JavaScript中的this关键字
- 运用 Swing
- Sqli-LABS通关笔录-3
- Linux 技巧:让进程在后台可靠运行的几种方法(转)
- win7激活
- PAT1013. Battle Over Cities(邻接矩阵、邻接表分别dfs)
- HDU5092——Seam Carving(动态规划+回溯)(2014上海邀请赛重现)
- Java笔记-快速失败and安全失败
- PHP __autoload函数知识点
- HDU 1507 Uncle Tom's Inherited Land*
- 【转】Visual Stdio VS 错误 error : 0xC00000FD: Stack overflow. 更改堆栈空间解决栈溢出问题
- 每天来点Java面试题(一)
- (转)[疯狂Java]NIO:Channel的map映射
- GDB 调试多线程多进程
- A Boring Problem UVALive - 7676
- 2017年50道Java线程面试题
- xmlhttprequest 1.0和2.0的区别,from qq前端哥
- kubernetes的CI/CD
- hihocoder 1334 - Word Construction - [hiho一下第170周][状态压缩+DFS]
- Android用shareUserID实现多个Activity显示在同一界面