Remote Database Backup

Hi everyone

Do you have any idea how I can make a backup for a remote database? (preferrably using a command in the command line, or with a stored procedure...)

I hope the question isn't too silly, but I haven't found a clear answer for this problem yet.

Thank you.

Without the information which DBMS you are using and an explanation what you understand by "remote database" this question cannot be answered.

Oracle's EXP utility can do a backup from any server that can be reached from your workstation, so that would qualify as "remote backup" for my understanding (the same is true for Postgres' pg_dump utility)

Thanks for the answer. Sorry for the lack of details.

I am talking about an Oracle database, and by "remote" i mean located on a different machine (but in the same network - so i have access to it).

The thing is, I need this to work preferrably from the command line.

So, assuming the ip is x.x.x.x, and the port is yyyy, and the username is user and the password is pwd, how can I connect by the EXP utility you mentioned earlier to a database on this remote machine?

Thank you again.

The same way you connect using SQL*Plus (e.g. exp user/password@server). You'll need to setup an entry in tnsnames.ora

Details about tnsnames.ora are here:
http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96581/tnsnames.htm#496765

Details about the EXP utilitiy are here:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1013411

Thanks.

Note that there is a specific Oracle forum here at Devshed