ORA-39000: bad dump file specification ORACLE 报错 故障修复 远程处理

文档解释

ORA-39000: bad dump file specification

Cause: The user specified a dump file that could not be used in the current job. Subsequent error messages describe the inadequacies of the dump file.

Action: Specify a dump file that is usable for the job.

ORA-39000：导出文件规范错误

描述：ORA-39000表示指定的导出文件规范无效。

官方解释

常见案例

1. 将数据库中的表导出时，指定操作系统上存在的目录错误时，会出现错误提示：

SQL> exp DB_NAME/DB_USER@DB_SID tables=Test_Table file=Test_Dump.dmp log=Test_Dump.lg badfile=Test_BAD.dmp

Export: Release 11.2.0.2.0 – Production on Tue Mar 24 16:09:38 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39000: bad dump file specification

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

2. 指示的log文件格式错误时：

SQL> exp DB_NAME/DB_USER@DB_SID tables=Test_Table file=Test_Dump.dmp log=Test_Dump.log badfile=Test_BAD.dmp

Export: Release 11.2.0.2.0 – Production on Tue Mar 24 16:13:20 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39000: bad dump file specification

ORA-39121: invalid log file type

ORA-39000: bad dump file specification

一般处理方法及步骤

1. 确保操作系统上所指定的目录存在，并具有写入权限。

2. 确认log文件格式为限定的拓展名格式：.log, .bad, .dmp。

3. 根据报错信息确认操作步骤是否正确，以及指定导出文件特定参数是否正确。