Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Impdp ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31619: invalid du

Jr.rajJan 4 2015 — edited Jan 4 2015

HI Oracle Gurus,

our Oracle version is 11.2.0.4 RAC.

we have a scheduled job, to take expdp backup. then we transfer that backup to linux(production) to windows(FTP site).

Today i have  transferred dump file from windows(FTP site) to linux( TEST Environment) to restore to the test environment.

FTP transfer was in binary mode only.

i believe file got corrupted while transferring from the unix(production) to windows(FTP SITE).

when i tried to restore the dump file to TEST Environment, getting error.

[oracle@znet-test2 backup1]$ cat person_nov4.par

job_name=person_nov4

directory=backup

dumpfile=DP_prodznet1_PERSON_201411042310_%U.dmp

version=11.2.0.4

logfile=person_nov4.log

cluster=n

exclude=statistics

remap_schema=PERSON:PERSON_TEST

full=y

parallel=4

[oracle@znet-test2 backup1]$  impdp parfile=person_nov4.par

Import: Release 11.2.0.4.0 - Production on Sun Jan 4 14:10:30 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: person_test@testznet

Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "/opt/znax/expdp/backup1/DP_prodznet1_PERSON_201411042310_01.dmp"

Please let me know, if there is any method to recover the dumpfile.

Highly appreciate your help

Thanks in advance

WITH BEST REGARDS,

raj

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2015
Added on Jan 4 2015
2 comments
3,517 views