中文字幕av专区_日韩电影在线播放_精品国产精品久久一区免费式_av在线免费观看网站

溫馨提示×

溫馨提示×

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

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

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

塘沽区| 通道| 安陆市| 乐东| 瓦房店市| 永年县| 河西区| 巴中市| 青龙| 镇安县| 义马市| 通榆县| 密山市| 遵义市| 峡江县| 临潭县| 洪雅县| 贵定县| 泾川县| 泰兴市| 砀山县| 冷水江市| 曲麻莱县| 昌平区| 天台县| 牡丹江市| 宁海县| 同江市| 浮梁县| 来宾市| 元朗区| 宜良县| 嵩明县| 湖北省| 南投县| 长汀县| 吉林省| 峨眉山市| 勃利县| 汉中市| 沅陵县|