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文档,找到了解决方法
参考
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)