-
to do Export backup in a remote machine
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
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
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.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
-
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 .
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
If it is a Windows how about using Terminal services which iam using to manage some of the servers which are located remotely.
-
install oracle server on your machine
and then
exp system/mgr@ file= yadda yadda
Export is not part of the the client toolset
steve
I'm stmontgo and I approve of this message
-
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?
Jeff Hunter
-
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
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
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.
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|