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. 根据报错信息确认操作步骤是否正确,以及指定导出文件特定参数是否正确。