EXPDP遇到的ORA-39005和ORA-39095错误_ora-39005 inconsistent arguments-优快云博客

在使用Oracle的EXPDP工具导出数据时遇到了ORA-39005和ORA-39095错误。错误原因是数据库版本兼容性问题及dump文件空间不足。通过去掉压缩选项并调整导出参数解决了ORA-39005错误，但在导出过程中因空间不足触发了ORA-39095。导出作业在进行中，部分数据已导出。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[oracle@mlydserver22 ~]$ expdp tables=zaodian.WZ_GO_VST_LOG directory=orabak dumpfile=zaodian_22_20120608.dmp compression=all parallel=4

Export: Release 11.2.0.1.0 - Production on Fri Jun 8 17:12:15 2012

Username: wonder
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39005: inconsistent arguments
ORA-39055: The COMPRESSION feature is not supported in version 10.2.0.3.0.

sys@EAGAODB> select comp_id,comp_name,version from dba_registry ;

COMP_ID          COMP_NAME        VERSION
------------------------------ ------------------------------ ------------------------------
EM          Oracle Enterprise Manager      11.2.0.1.0
AMD          OLAP Catalog        11.2.0.1.0
SDO          Spatial         11.2.0.1.0
ORDIM          Oracle Multimedia       11.2.0.1.0
XDB          Oracle XML Database       11.2.0.1.0
CONTEXT          Oracle Text        11.2.0.1.0
ODM          Oracle Data Mining       11.2.0.1.0
EXF          Oracle Expression Filter       11.2.0.1.0
RUL          Oracle Rules Manager       11.2.0.1.0
OWM          Oracle Workspace Manager       11.2.0.1.0
CATALOG          Oracle Database Catalog Views 11.2.0.1.0
CATPROC          Oracle Database Packages and T 11.2.0.1.0
          ypes

JAVAVM          JServer JAVA Virtual Machine   11.2.0.1.0
XML          Oracle XDK        11.2.0.1.0
CATJAVA          Oracle Database Java Packages 11.2.0.1.0
APS          OLAP Analytic Workspace       11.2.0.1.0
XOQ          Oracle OLAP API        11.2.0.1.0

17 rows selected.

sys@EAGAODB> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.3.0

由于这里设置了兼容10.2.0.3.0导致的，此参数为静态参数

去掉压缩特性后重新尝试：

[oracle@mlydserver22 ~]$ expdp tables=zaodian.WZ_GO_VST_LOG directory=orabak dumpfile=zaodian_22_20120608.dmp logfile=zaodian_22_20120608.log parallel=4;

Export: Release 11.2.0.1.0 - Production on Fri Jun 8 17:38:15 2012

Username: wonder
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "WONDER"."SYS_EXPORT_TABLE_01": wonder/******** tables=zaodian.WZ_GO_VST_LOG directory=orabak dumpfile=zaodian_22_20120608.dmp logfile=zaodian_22_20120608.log parallel=4
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10.55 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
. . exported "ZAODIAN"."WZ_GO_VST_LOG":"WZ_GO_VST_201205" 4.324 GB 17250277 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
Job "WONDER"."SYS_EXPORT_TABLE_01" stopped due to fatal error at 17:39:32

查看：

[oracle@mlydserver22 ~]$ expdp attach=SYS_EXPORT_TABLE_01

Export: Release 11.2.0.1.0 - Production on Fri Jun 8 18:05:19 2012

Username: wonder
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_EXPORT_TABLE_01
Owner: WONDER
Operation: EXPORT
Creator Privs: TRUE
GUID: C1F3C2E4E5B045E0E040C578165F5636
Start Time: Friday, 08 June, 2012 18:05:25
Mode: TABLE
Instance: eagaodb
Max Parallelism: 4
EXPORT Job Parameters:
Parameter Name      Parameter Value:
     CLIENT_COMMAND        wonder/******** tables=zaodian.WZ_GO_VST_LOG directory=orabak dumpfile=zaodian_22_20120608.dmp logfile=zaodian_22_20120608.log parallel=4
State: IDLING
Bytes Processed: 4,643,547,320
Percent Done: 41
Current Parallelism: 4
Job Error Count: 0
Dump File: /data1/backup/zaodian_22_20120608.dmp
    bytes written: 4,643,590,144

Worker 1 Status:
Process Name: DW00
State: UNDEFINED

Worker 2 Status:
Process Name: DW01
State: UNDEFINED

Worker 3 Status:
Process Name: DW02
State: UNDEFINED

Worker 4 Status:
Process Name: DW03
State: UNDEFINED
Object Schema: ZAODIAN
Object Name: WZ_GO_VST_LOG
Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 14
Completed Rows: 201,055
Completed Bytes: 52,428,848
Percent Done: 1
Worker Parallelism: 3

Export> status

Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: IDLING
Bytes Processed: 4,643,547,320
Percent Done: 41
Current Parallelism: 4
Job Error Count: 0
Dump File: /data1/backup/zaodian_22_20120608.dmp
    bytes written: 4,643,590,144

Worker 1 Status:
Process Name: DW00
State: UNDEFINED

Worker 2 Status:
Process Name: DW01
State: UNDEFINED

Worker 3 Status:
Process Name: DW02
State: UNDEFINED

Worker 4 Status:
Process Name: DW03
State: UNDEFINED
Object Schema: ZAODIAN
Object Name: WZ_GO_VST_LOG
Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 14
Completed Rows: 201,055
Completed Bytes: 52,428,848
Percent Done: 1
Worker Parallelism: 3