91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

expdp在rac下parallel并行報錯解決

發布時間:2020-07-01 12:01:04 來源:網絡 閱讀:1428 作者:春秋小記 欄目:關系型數據庫

其實這個是個很常見的問題,寫下來做紀念吧。
說明:
而在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

向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

余姚市| 肃宁县| 康平县| 湘阴县| 胶南市| 河东区| 乐山市| 莱芜市| 佛坪县| 离岛区| 阳信县| 天津市| 磐安县| 浏阳市| 阜城县| 苏尼特左旗| 抚宁县| 莒南县| 延长县| 育儿| 集安市| 确山县| 轮台县| 鹿泉市| 林口县| 台山市| 咸阳市| 全州县| 平远县| 筠连县| 金溪县| 大港区| 菏泽市| 灵璧县| 白朗县| 永泰县| 海淀区| 南澳县| 东乌珠穆沁旗| 和静县| 郯城县|