是否可以恢复 Oracle 数据泵主表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/24621217/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
is it possible to recover the Oracle Data Pump master table?
提问by gcardozo
I'm trying to import a few files with a published Oracle Data Pump perl script: dumpinfo.pl
我正在尝试使用已发布的 Oracle Data Pump perl 脚本导入一些文件：dumpinfo.pl
After successfully importing several dump files from the same export process, another file failed with:
从同一个导出过程成功导入多个转储文件后，另一个文件失败：
# impdp system/****** DIRECTORY=RESTORE_DIR DUMPFILE=exp_%u.dmp PARALLEL=8
Import: Release 11.2.0.2.0 - Production on Mon Jul 7 11:40:37 2014
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 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39059: dump file set is incomplete
ORA-39246: cannot locate master table within provided dump files
The script reports that it can't find a master table. Assuming that the master table is lost, there any mechanics for recover it?
脚本报告它找不到主表。假设主表丢失了，有什么恢复的机制吗？
Thanks...
谢谢...
回答by Tagar
ORA-39246 cannot locate master table within provided dump files Cause: Check the export log file and make sure all of the files that were exported are included in the current job. Action: A Data Pump IMPORT or SQL_FILE operation was being performed but not all of the files from the Data Pump export dump file set were included. In particular, the dump file containing the export job's master table was not provided.
ORA-39246 无法在提供的转储文件中找到主表原因：检查导出日志文件并确保导出的所有文件都包含在当前作业中。操作：正在执行数据泵 IMPORT 或 SQL_FILE 操作，但并未包括数据泵导出转储文件集中的所有文件。特别是，没有提供包含导出作业主表的转储文件。
Check that you have all dump files in that directory and they all are accessible to impdp utility. I got this error when our backup team has restored first five dmp files, and two last ones were missing.
检查您是否在该目录中拥有所有转储文件，并且 impdp 实用程序可以访问它们。当我们的备份团队恢复了前五个 dmp 文件，而最后两个文件丢失时，我收到了这个错误。
