Remote backup [message #298089] |
Tue, 05 February 2008 00:18 |
rzkhan
Messages: 370 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 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
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 #298146 is a reply to message #298110] |
Tue, 05 February 2008 02:39 |
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 #298150 is a reply to message #298089] |
Tue, 05 February 2008 02:50 |
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 #298153 is a reply to message #298089] |
Tue, 05 February 2008 03:03 |
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 |
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 #298174 is a reply to message #298089] |
Tue, 05 February 2008 04:12 |
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 #298191 is a reply to message #298089] |
Tue, 05 February 2008 05:14 |
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 #298197 is a reply to message #298089] |
Tue, 05 February 2008 05:25 |
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 #298246 is a reply to message #298089] |
Tue, 05 February 2008 08:03 |
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 #298255 is a reply to message #298089] |
Tue, 05 February 2008 08:19 |
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 #298357 is a reply to message #298089] |
Tue, 05 February 2008 22:27 |
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 #298482 is a reply to message #298089] |
Wed, 06 February 2008 03:36 |
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 #443149 is a reply to message #298089] |
Sat, 13 February 2010 00:54 |
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.
|
|
|
|