expdp遇到报错ORA-39095: Dump file space has been exhausted

51 篇文章 1 订阅
16 篇文章 0 订阅

expdp导出的时候遇到报错 ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes,第一反应是磁盘空间不够了,但看了下系统还有几百G空间,而这个dump文件一共就10几G。一脸懵逼,为啥会有这种报错...

[oracle@CONAN-DB ~]$ expdp dumpuser DIRECTORY=DATA_PUMP_DIR schemas=CONAN dumpfile=CONAN_191025.dmp logfile=CONAN_191025.log parallel=4

Export: Release 12.1.0.2.0 - Production on Fri Oct 25 18:41:51 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
Password: 

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "dumpuser"."SYS_EXPORT_SCHEMA_01":  dumpuser/******** DIRECTORY=DATA_PUMP_DIR schemas=CONAN dumpfile=CONAN_191025.dmp logfile=CONAN_191025.log parallel=4 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 15.58 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
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
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
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
Job "DUMPUSER"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at Fri Oct 25 18:43:45 2019 elapsed 0 00:01:45

搜索mos文档,找到了解决方法

CAUSE

When using one dumpfile or a number less than parallelism value, several slave processes wait for the file locked by the other process to write. And so we are not benefiting from the parallelism anyway.Sometimes the slave process locking the file does not release the lock after finishing as it's supposed to release the lock when the dump process ends, and it'll not end cause the other processes are waiting to write to the file. 

SOLUTION

o  Use a number of dump files equal to, or more than the parallelism value.

- OR -

o  Don't use PARALLEL clause.

参考

Parallel Export Fails With Error ORA-39095 If There Are Less Specified Files Than Slaves (Doc ID 433391.1)

另外还有几篇导致该报错的原因文档介绍,若不符合上文描述可以参考

DataPump Export (EXPDP) Error ORA-39095 Dump File Space Has Been Exhausted(Doc ID 559692.1)
DataPump Export (EXPDP) Error ORA-19510 Failed To Set Size Of 1676609 Blocks For File and ORA-39095(Doc ID 1347092.1)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

Hehuyi_In

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值