expdp在rac下parallel并行报错解决
admin
2023-04-17 14:41:33
0

其实这个是个很常见的问题,写下来做纪念吧。
说明:
而在11GR2后EXPDP 和 IMDP的WORKER进程在设置parallel参数时会在多个INSTANCE启动,所以DIRECTORY必须在共享磁盘上,如果没有设置共享磁盘需要指定cluster=no 来防止报错。

今晚是个苦逼的日子明天需要导数据做ogg同步,因为数据量比较大,所以晚上导出,明天白天上班再导入到其它数据库,因此选用expdp做同步工具,可以参考如下博文:
https://blog.51cto.com/1937519/2177360

https://blog.51cto.com/1937519/2177352

刚开始导出时配置:
[oracle@scm02db01 ~]$ cat aaa.txt
dumpfile = app20180919_%U.dmp
logfile = wms20180919.log
directory = orabackup
schemas=wms
parallel=4
include=table:"in(select name from system.exp_table)"
include=FUNCTION
include=PROCEDURE
include=view
include=TRIGGER
include=SEQUENCE
include=SYNONYM
flashback_scn=6093937115518

报如下错误:
[oracle@scm02db01 ~]$ expdp system parfile=aaa.txt

Export: Release 11.2.0.4.0 - Production on Wed Sep 19 21:12:41 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
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
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/**** parfile=aaa.txt
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 143.8 GB
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/PROCACT_INSTANCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-31693: Table data object "app"."T_WH_AAP" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u01/dump_dir/wms20180919_03.dmp" for write
ORA-19505: failed to identify file "/u01/dump_dir/wms20180919_03.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 128
Additional i
ORA-31693: Table data object "app"."T_WH_AAP" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u01/dump_dir/app20180919_04.dmp" for write
ORA-19505: failed to identify file "/u01/dump_dir/app20180919_04.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 128
Addition
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-31693: Table data object "app"."T_WH_APPP" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/s01/dump_dir/wms20180919_03.dmp" for write
ORA-19505: failed to identify file "/s01/dump_dir/wms20180919_03.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 128
Addition
......................................中间省略....................................
Addition
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_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/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
^C
心里惦记着洗澡,忘记了这个是一套rac数据库,而且导出的文件不是在共享存储上,于是立刻按下ctrl +c 终止导出:
Export> kill_job
Are you sure you wish to stop this job ([yes]/no): yes
^CUDE-00001: user requested cancel of current operation

然后添加一句重新导出,一切正常:
cluster=no
完整如下:
dumpfile = app20180919_%U.dmp
logfile = wms20180919.log
directory = orabackup
schemas=wms
parallel=4
cluster=no
include=table:"in(select name from system.exp_table)"
include=FUNCTION
include=PROCEDURE
include=view
include=TRIGGER
include=SEQUENCE
include=SYNONYM
flashback_scn=6093937115518

相关内容

热门资讯

终于了解“悟空黑桃A开挂神器?... 您好:悟空黑桃A这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9752949】很多玩家在这款游...
重磅消息“微乐麻将开挂神器?”... 重磅消息“微乐麻将开挂神器?”(必胜开挂神器)您好,微乐麻将这个游戏其实有挂的,确实是有挂的,需要了...
【今日要闻】“聚友互娱怎么开挂... 网上科普关于“聚友互娱有没有挂”话题很是火热,小编也是针对聚友互娱作*弊开挂的方法以及开挂对应的知识...
终于了解“情怀莆仙真的有挂吗?... 网上科普关于“情怀莆仙有没有挂”话题很是火热,小编也是针对情怀莆仙作*弊开挂的方法以及开挂对应的知识...
【今日要闻】“新老夫子牛牛辅助... 您好:新老夫子牛牛这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款...
终于明白“授权大厅究竟有挂吗?... 您好:授权大厅这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9752949】很多玩家在这款游戏...
【第一消息】“开心游戏真的有挂... 您好:开心游戏这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9752949】很多玩家在这款游戏...
终于了解“万人玩麻将辅助器?”... 家人们!今天小编来为大家解答万人玩麻将透视挂怎么安装这个问题咨询软件客服徽9784099的挂在哪里买...
终于明白“麦穗推筒子开挂器?”... 家人们!今天小编来为大家解答麦穗推筒子透视挂怎么安装这个问题咨询软件客服徽4282891的挂在哪里买...
玩家攻略科普“新金龙炸/金/花... 有 亲,根据资深记者爆料新金龙炸/金/花是可以开挂的,确实有挂(咨询软件...