Home » RDBMS Server » Backup & Recovery » Remote backup
Remote backup [message #298089] Tue, 05 February 2008 00:18 Go to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Hi...
I have 8i installed on win2k machine. I am using a client XP machine to connect. (have configued net8 easy config connection). I have only installed Developer 6i on client machine. Can I take backup(using EXP/IMP) of database on my client machine. Please guide me through the process.



Thanks

Rzkhan

[Updated on: Tue, 05 February 2008 00:38]

Report message to a moderator

Re: Remote backup [message #298110 is a reply to message #298089] Tue, 05 February 2008 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can I take backup(using EXP/IMP) of database

No, as exp/imp are NOT database backup utilities.

Quote:
Can I [...use...] EXP/IMP on my client machine.

Yes but you will transfer all the data through the network, so take care.

Regards
Michel

[Updated on: Tue, 05 February 2008 00:54]

Report message to a moderator

Re: Remote backup [message #298127 is a reply to message #298089] Tue, 05 February 2008 01:37 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
So the OP would take exp on the server and transfer it to the client via FTP?
Re: Remote backup [message #298128 is a reply to message #298127] Tue, 05 February 2008 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why dump should be on client?

Regards
Michel
Re: Remote backup [message #298129 is a reply to message #298128] Tue, 05 February 2008 01:42 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
I think EXP is the fastest and safest in my situation. So please let me know how can I use EXP on client.

Thanks
Rzkhan

[Updated on: Tue, 05 February 2008 01:43]

Report message to a moderator

Re: Remote backup [message #298130 is a reply to message #298089] Tue, 05 February 2008 01:47 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
OS you want to take export of the remote database from the client?
Re: Remote backup [message #298132 is a reply to message #298130] Tue, 05 February 2008 01:58 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Yes, thats my question.

rzkhan
Re: Remote backup [message #298140 is a reply to message #298129] Tue, 05 February 2008 02:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The same way you use it on server giving a remote connection string as for SQL*Plus.

Regards
Michel
Re: Remote backup [message #298146 is a reply to message #298110] Tue, 05 February 2008 02:39 Go to previous messageGo to next message
srinu2466
Messages: 11
Registered: October 2005
Junior Member
Hi Michel,

you are telling, imp/exp are not backup utilities and these can be used in client. my server is win2000 and client was win2000 professional in client forms6i was installed, but i am unable to use the exp/imp from client. what are the backup utilities.

Best Regards,
Srinivas.
Re: Remote backup [message #298147 is a reply to message #298146] Tue, 05 February 2008 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but i am unable to use the exp/imp from client.

"I am unable" is not an Oracle error.
Most likely you don't have these programs on your client.

Quote:
what are the backup utilities

RMAN, for instance, is Oracle standard one.

Regards
Michel
Re: Remote backup [message #298150 is a reply to message #298089] Tue, 05 February 2008 02:50 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
The same way you use it on server giving a remote connection string as for SQL*Plus.

But what would that remote connection string contain?
How can we use existent tnsnames file to exp in remote database?
Re: Remote backup [message #298152 is a reply to message #298089] Tue, 05 February 2008 02:54 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Is RMAN available with Dev6i?

Re: Remote backup [message #298153 is a reply to message #298089] Tue, 05 February 2008 03:03 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
RMAN is not like exp/imp.
Export put your tables in a binary dump file and RMAN would backup entire datafile.
Rman comes with 8i or higher database.
Re: Remote backup [message #298154 is a reply to message #298147] Tue, 05 February 2008 03:06 Go to previous messageGo to next message
srinu2466
Messages: 11
Registered: October 2005
Junior Member
Hi,

'i unable to use' is not an error, actual error was " 'exp' is not recognized as an intrnal ot external command".

exp userid=scott@ora file=c:\scottbackup.dmp log=c:\scottlog.log

i am using this command in command promt. 'c:\>'

regards,
Re: Remote backup [message #298155 is a reply to message #298089] Tue, 05 February 2008 03:08 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
If I copy RMAN executable to client. would it work fine there?

rzkhan
Re: Remote backup [message #298156 is a reply to message #298150] Tue, 05 February 2008 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can we use existent tnsnames file to exp in remote database?

exp myuser/mypsw@mydb ...

Regards
Michel
Re: Remote backup [message #298158 is a reply to message #298154] Tue, 05 February 2008 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
'i unable to use' is not an error, actual error was " 'exp' is not recognized as an intrnal ot external command".


As I said:
Quote:
Most likely you don't have these programs on your client.



Neither exp nor rman are on dev client.

Quote:
If I copy RMAN executable to client. would it work fine there?

No.

Database backup are made by DBA not developer.

Regards
Michel
Re: Remote backup [message #298161 is a reply to message #298089] Tue, 05 February 2008 03:25 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
How to install these client tools as a part of oracle client?
Re: Remote backup [message #298165 is a reply to message #298161] Tue, 05 February 2008 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Exp/imp are on client/companion CD when you choose administor installation and not developer one (CD and option depend on version).
RMAN is only on Server CD (iirc).

Regards
Michel
Re: Remote backup [message #298167 is a reply to message #298089] Tue, 05 February 2008 03:46 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Could I download CLIENT companion CD software from oracle site?

rzkhan
Re: Remote backup [message #298169 is a reply to message #298167] Tue, 05 February 2008 03:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Remote backup [message #298174 is a reply to message #298089] Tue, 05 February 2008 04:12 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Ok,i tried to do what you said,
from client i issued
C:\ rman target username/pass@SID

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>rman target sys/sys123@orcl

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12535: TNS:operation timed out


I can connect with telnet,ping,tnsping.
I can connect with TOAD also.
The listener.log file on the server says:
ora-12502:listener recieved no connect_data from client.
Thsi is the tnsnames.ora on the client:
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mycomp)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )
....

Even i can't connect with sql*plus
Re: Remote backup [message #298178 is a reply to message #298174] Tue, 05 February 2008 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Even i can't connect with sql*plus

So you can't do it with RMAN either.
It is consistent.
Check TNS_ADMIN environment variable, check registry for this, check associated tnsnames.ora...

ORA-12502: TNS:listener received no CONNECT_DATA from client
 *Cause:  No CONNECT_DATA was passed to the listener.
 *Action: Check that the service name resolved from TNSNAMES.ORA has
 the CONNECT_DATA component of the connect descriptor.


Regards
Michel
Re: Remote backup [message #298191 is a reply to message #298089] Tue, 05 February 2008 05:14 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
You can see in the above post,there is connect_data string in tnsnames file.
So its seems to be a bug in 9i versions.
Re: Remote backup [message #298194 is a reply to message #298191] Tue, 05 February 2008 05:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm not sure posted tnsnames.ora is the correct one.

Regards
Michel
Re: Remote backup [message #298197 is a reply to message #298089] Tue, 05 February 2008 05:25 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mycomp)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER=DEDICATED) 
      (SERVICE_NAME = ORCL)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mycomp)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )



This is the complete tnsnames.ora file.
I don't see any anomalies in it.
If you do then please point out.
Re: Remote backup [message #298201 is a reply to message #298197] Tue, 05 February 2008 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not answer my questions.
If you can connect with toad but not with sqlplus then you have multiple tnsnames.ora.

Regards
Michel
Re: Remote backup [message #298246 is a reply to message #298089] Tue, 05 February 2008 08:03 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Toad does not have its own tnsnames file.
It uses that of the oracle client located in network\admin directory.
This is what i am thinking,if Toad can why can't sqlplus/rman/exp.
Re: Remote backup [message #298251 is a reply to message #298246] Tue, 05 February 2008 08:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
if Toad can why can't sqlplus/rman/exp.

Because they don't use the same connection way.

And you still don't answer my questions about TNS_ADMIN, etc.

Regards
Michel
Re: Remote backup [message #298255 is a reply to message #298089] Tue, 05 February 2008 08:19 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
TNS_ADMIN variable i guess is not set.This should not be a problem as oracle searches in default locations which are existent.
Re: Remote backup [message #298262 is a reply to message #298255] Tue, 05 February 2008 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
TNS_ADMIN variable i guess is not set.

Don't guess, verify, in any place. And post what you tried.

Quote:
This should not be a problem

You can't know without a sure answer to the previous question.

Quote:
as oracle searches in default locations which are existent

You can't know where it searches without a sure answer to the previous question.

Regards
Michel
Re: Remote backup [message #298357 is a reply to message #298089] Tue, 05 February 2008 22:27 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
env | echo $TNS_ADMIN returns null on server.
I can't see any TNS_ADMIN variable set in the windows registry either.
Re: Remote backup [message #298437 is a reply to message #298089] Wed, 06 February 2008 02:05 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
When TOAD and sqlplus uses the same tnsnames files,how could they have different connection ways?
Re: Remote backup [message #298439 is a reply to message #298437] Wed, 06 February 2008 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who say they use the same tnsnames.ora?
Who say how TOAD build its connection string?
For myself, I don't know what TOAD does.

Regards
Michel
Re: Remote backup [message #298482 is a reply to message #298089] Wed, 06 February 2008 03:36 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
ok,forget toad,as i said i checked in the windows client registry ,there is no tns_admin parameter set.
I can tnsping port in the server.
Re: Remote backup [message #298487 is a reply to message #298482] Wed, 06 February 2008 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You know: copy and paste.

Regards
Michel
Re: Remote backup [message #443149 is a reply to message #298089] Sat, 13 February 2010 00:54 Go to previous messageGo to next message
Blaylock
Messages: 6
Registered: February 2010
Location: USA
Junior Member
I want to back up all of my data to my external hard drive at the end of every day, and I started using the Acronis True Image Home software to do so. I made the first backup yesterday, which understandably took a long time. But now I'm running the first daily backup, as a test, and it says it'll take 4 hours to finish!.So due to all these difficulties i quit Acronis & now i am using Magic Backup online service & really it's great .Magic Backup is so easy to use, and so reliable. Unlike other backup products that perform "scheduled" backups during the middle of the night,Magic Backup is always on the lookout for new or changed files that need to be backed up.
Re: Remote backup [message #443162 is a reply to message #443149] Sat, 13 February 2010 01:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This has a light smell of spam.

Regards
Michel

[Updated on: Sat, 13 February 2010 01:43]

Report message to a moderator

Previous Topic: insufficient privilleges..when connecting target
Next Topic: RMAN backup and restore using NFS mount
Goto Forum:
  


Current Time: Sat Dec 03 19:53:31 CST 2016

Total time taken to generate the page: 0.06469 seconds