DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: to do Export backup in a remote machine

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    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

  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    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

  4. #4
    Join Date
    May 2001
    Posts
    736
    If it is a Windows how about using Terminal services which iam using to manage some of the servers which are located remotely.

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  7. #7
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    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

  8. #8
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    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

  9. #9
    Join Date
    Sep 2002
    Posts
    411
    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
  •  


Click Here to Expand Forum to Full Width