to do Export backup in a remote machine

[pravin]

objective- To take a Export backup from oracle 8.1.7 database
located remote.

I have to access the bin directory of that oracle database from my system itself and take a export dump.

Two questions

Remote export backup is possible . ?
how to do that in my case.

Thanks in advance

[rotem_fo]

Hi,
as i see it, you have 2 options:
1. Install oracle client on your machine and perform the exports direclty to your machine.
2. use dbms_job/at/crontab (depends on the machine running the Oracle server), perform export on the machine and mail/ftp/copy to your computer automatically.

Cheers,
R.

[pravin]

See this is the scenario

I am in US and want to access the oracle database running on one system in India.

In my desktop i have oracle client installed

First i established a VPN connection.

Then thru net configuration assistant i configured the host
name,sid,& service of the remote database and test connection test was successful.

Then i tried to use export Command from the bin directory of my client machine giving the remote username and password it doesnot take it. it says Oracle is not available.

how can i take a remote backup .

[akhadar]

If it is a Windows how about using Terminal services which iam using to manage some of the servers which are located remotely.

[stmontgo]

install oracle server on your machine
and then
exp system/mgr@ file= yadda yadda

Export is not part of the the client toolset

steve

[marist89]

Originally posted by pravin
Then thru net configuration assistant i configured the host
name,sid,& service of the remote database and test connection test was successful.

Can you connect through SQL*Plus?

[pravin]

hi jeff - great to see u , Guru is what i say to u always !!!

Yes i can connect to to sql plus absolutely no problems.

sql > connect test/test@indiatest
connected

Indiatest - service name i gave in the Net configuration Assistant

[pravin]

I got the solution it is working

what is did was

d:\oracle\ora81\bin\exp userid=test/test@indiatest file = ' ' log=' '
owner=test,test1 ;

Just executed at the command prompt at my desktop. started export backup.

Thanks for the help and ur time.

Just learnt now that if u give userid/passwd@SERVICE NAME then it works remotely.

[mike2000]

one addition to this post,

you don't have to install Oracle server on the machine to do exp/imp remotely, all you need is just the Oracle client which already have exp/imp utilities, that's all you need