is it possible to recover the Oracle Data Pump master table?

oracle oracle11g oracle11gr2 recover datapump
gcardozo picture gcardozo · Jul 8, 2014 · Viewed 12.8k times · Source

I'm trying to import a few files with a published Oracle Data Pump perl script: 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...

Answer

Tagar picture Tagar · Sep 7, 2015

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.

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.

Related questions

Adding columns to existing index in Oracle

I have a relatively large table (81M rows) and an index on it. I want to add a column to the existing index. I searched for it on Google, but I couldn't find a way for it. I've read somewhere …

Read More
truncated LISTAGG string

I'm using Oracle 11g r2 and I need to concatenate strings (VARCHAR2, 300) from multiple rows. I'm using LISTAGG which works great until the concatenated string reaches the limit. At that point I receive a ORA-01489: result of string concatenation is …

Read More
Selecting both MIN and MAX From the Table is slower than expected

I have a table MYTABLE with a date column SDATE which is the primary key of the table and has a unique index on it. When I run this query: SELECT MIN(SDATE) FROM MYTABLE it gives answer instantly. The …

Read More