IMPDP (ORA-31619: Invalid dump file) [message #555809] |
Tue, 29 May 2012 02:07 |
|
I need to recreate/ clone my database to a new machine. The two machine are not connected in the network.
Step 1. (Oracle 10.2.0.5 AIX 64-bit)
expdp username/password@db1 full=y dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_expdp.log job_name=full_exp
Step 2.
FTP dump files to Windows
Step 3. (Oracle 10.1.0.2 Windows 32-bit)
impdp username/password@db1 dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_impdp.log full=y
I got:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "C:\P7DB\fpac052912_dp01.dmp"
Done in AIX:
create directory dp as '/bak'
grant read, write on directory dp to public;
grant exp_full_database to username;
Done in Windows:
create directory dp as 'C:\P7DB\';
grant read, write on directory dp to public;
grant exp_full_database to username;
grant imp_full_database to username;
|
|
|
|
Re: IMPDP (ORA-31619: Invalid dump file) [message #555818 is a reply to message #555811] |
Tue, 29 May 2012 02:49 |
|
1/ The directory must be located in the database server
2/ Do not tell what you did and saw: SHOW US.
3/ Are you sure you did your ftp in BINARY mode?
1. The directory is located in the database server
2. Go to X;
3. I used fireFTP to transfer my dumps. How can I be sure that it was in binary mode?
X:
On the AIX Machine (Oracle 10.2.0.5 AIX 64bit):
I have a database named fpac2, then I performed the following:
0. su - oracle
1. mkdir /bak/dp
2. chown -R oracle:oinstall /bak/dp
3. chmod -R 775 /bak/dp
4. sqlplus sys@fpac2 as sysdba
4.1 create user cpi identified by xxx;
4.2 grant dba to cpi;
4.3 create directory dp as '/bak/dp';
4.4 grant read, write on directory dp to public;
4.5 grant exp_full_database to cpi;
4.6 exit
5. expdp cpi/xxx@fpac2 full=y dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_expdp.log job_name=full_exp
This made 11 dump files. After that I use fireFTP to copy those dump files to my Windows machine.
Then I copy those dump files to my external hdd and paste it on the other machine that is not connected in the network.
On my Windows machine (Oracle 10.1.0.2 Windows 32bit):
I created a database named p7db, then create and run a script for tablespaces (based on the fpac2 database).
1. mkdir C:\p7db
2. sqlplus sys@p7db as sysdba
2.1 create user cpi identified by xxx;
2.2 grant dba to cpi;
2.3 create directory dp as 'C:\p7db';
2.4 grant read, write on directory dp to public;
2.5 grant exp_full_database to cpi;
2.6 grant imp_full_database to cpi;
2.7 exit
3. impdp cpi/xxx@p7db dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_impdp.log full=y
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "C:\P7DB\fpac052912_dp01.dmp"
I saw some discussion related to the ora errors I encountered and some of them are saying "typically exp is higher version than imp", I am now planning to upgrade my oracle software on windows. This is my first time to actually performed data pump so please bear with me. Thanks!
[Updated on: Tue, 29 May 2012 02:51] Report message to a moderator
|
|
|
|
|
|
Re: IMPDP (ORA-31619: Invalid dump file) [message #555829 is a reply to message #555828] |
Tue, 29 May 2012 03:33 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Generally speaking, you should use ASCII mode for pure text documents. Everything else is BINARY (images, executables, MS Word documents, blabla, Oracle export files, ...). If it is a GUI, then there must be some option (toolbar button, checkbox, radio button, whatever) which sets the mode. If you did that from the command prompt, you'd specify binary mode by the same keyword:
M:\>ftp my_ftp_site
Connected to my_ftp_site.
220 my_ftp_site FTP Server (Version 4.2) Ready.
User (my_ftp_site:(none)): system
331 Username SYSTEM requires a Password
Password:
230 User logged in.
ftp> binary
200 TYPE set to IMAGE.
ftp> ascii
200 TYPE set to ASCII.
ftp> ?
Commands may be abbreviated. Commands are:
! delete literal prompt send
? debug ls put status
append dir mdelete pwd trace
ascii disconnect mdir quit type
bell get mget quote user
binary glob mkdir recv verbose
bye hash mls remotehelp
cd help mput rename
close lcd open rmdir
ftp>
|
|
|
|
|