FTP Dump file Over Network [message #451920] |
Mon, 19 April 2010 00:28 |
AshrafKittaneh26
Messages: 18 Registered: June 2008 Location: UAE
|
Junior Member |
|
|
Dear All,
I have A Daily hot backup using Expdp Command On oracle 10g R2 installed on the Linux server. And I'm trying to move this Dump File to Another directory on Windows server 2003 over network using Ftp script which will be run after the export process finished Automatically.
Any Body Have any Idea How To do that. By the way i want the Ftp script only. or any other idea.
Any help will be appreciated.
thnx.
|
|
|
|
|
|
|
Re: FTP Dump file Over Network [message #451951 is a reply to message #451920] |
Mon, 19 April 2010 03:05 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Apart from all that's being said, the original question is still unanswered. Although it addresses FTP, I guess it is allowed as we talk about moving Oracle files around.
I don't use Linux so - here's a DOS (Windows) + OpenVMS combination version of the same. Export file was on a VMS machine, and we wanted to FTP it to a PC under MS Windows. Both VMS_WINDOWS.BAT and BFTP files are on a PC.
-- VMS_WINDOWS.BAT
-- 111.222.333.444 is IP address of a computer that contains
-- FTP uses information written in a script named BFTP
c:
cd c:\temp
ftp -s:c:\temp\bftp 111.222.333.444
-- BFTP (this file doesn't have any extension)
-- this script "simulates" user's input. Using it, you don't have
-- to type that manually. Comments (right hand column) are NOT
-- part of the script! I wrote them for you, now.
system -- OpenVMS user who "owns" export file
password_here -- password that belongs to a user
cd disk5:[000000] -- go to directory that contains export file
lcd -- change local working directory
binary -- FTP mode should be BINARY
mget baza*.dmp -- get all BAZA*.DMP files over here!
bye -- see you again
As you can see, what we did was GET. Your situation is a little bit different as you'd probably want to PUT a file (from Linux to Windows); I guess that it shouldn't be a problem. My example was just an example, so that you'd see one possible way to do that.
Anyway, there are numerous FTP related sites around so - google a little bit to get familiar with FTP commands. It shouldn't be too difficult to make it work. (However, you'd probably want to FTP much smaller files while testing, not database export file itself!)
|
|
|
|
|
|
Re: FTP Dump file Over Network [message #465715 is a reply to message #452151] |
Thu, 15 July 2010 06:53 |
sanju_chenna
Messages: 5 Registered: June 2010
|
Junior Member |
|
|
i always use DBMS_FILE_TRANSFER.GET_FILE for transfer of dump file
BEGIN
DBMS_FILE_TRANSFER.GET_FILE(source_directory_object =>
'DATA_PUMP_DIR', source_file_name => 'DUMP_FILE.DMP',
source_database => 'dest_LINK', destination_directory_object =>
'DATA_PUMP_DIR', destination_file_name => 'DUMP_FILE.DMP');
END;
/
use can use this link ..please add http at begining ...
//psoug.org/reference/dbms_file_trans.html
[Updated on: Thu, 15 July 2010 06:54] Report message to a moderator
|
|
|