Oracle data recovery problem-CodePudding

, a group of data backup way is to use expdp multi-threaded fast backup, backup a table out multiple DMP file, the file name with % U.d mp named automatically, when I back, found that 01. DMP file is a 300 k a. DMP file, other. DMP file size is more than 10 G, open the 01. DMP file, find inside is in XML format,
Then use impdp file recovery, error recovery: 01. DMP file is invalid, skip the first file from the second error recovery: backup file is not complete,
Backup statement: expdp system/* * * * directory=exp_dir schemas=j1_c dumpfile=0% U.d mp logfile=20. The log \
The parallel compression will=16 filesize=100 g=all VERSION=COMPATIBLE

Statement: impdp system/* * * * directory=exp_dir schemas=j1_c dumpfile=0% U.d mp

Before, table space, user authorization, file directory and file permissions have been created, the Internet also found a lot of ways, is bad to use, is there anything that's where I didn't pay attention to?

For each great god give directions!!!!!

CodePudding user response:

Behind what's wrong?
If only to restore a table, parameters can be specified tables

CodePudding user response:

To connect to the database after began to report errors: ORA - 39000: dump file specification error, ORA - 31619 dump "I: \ c01 DMP" null and void, the first file is much smaller than other files, this don't understand,

CodePudding user response:

@ sych888
To connect to the database after began to report errors: ORA - 39000: dump file specification error, ORA - 31619 dump "I: \ c01 DMP" null and void, the first file is much smaller than other files, this don't understand,

CodePudding user response:

reference 1st floor sych888 response:

behind what's wrong?
If only to restore a table, you can specify tables parameter

CodePudding user response:

Look at the version are consistent

Specify the specific version try
http://blog.itpub.net/30162081/viewspace-1800106/