Home » RDBMS Server » Backup & Recovery » Heterogeneous services (oracle10gR2.3.linux(client->windows 2003 server))
Heterogeneous services [message #384717] Wed, 04 February 2009 23:29 Go to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
how can i use oracle oracle`s heterogeneous services to take the bake up of mysql(non-ORACLE database).Please provide me a list of instructions,steps to follow and if possible with an example.shall i use oracle tools(imp & EXP) to take the back up of mysql
Re: Heterogeneous services [message #384718 is a reply to message #384717] Wed, 04 February 2009 23:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
A shovel is a great tool for making a hole in the ground,
but only when the correct end of the shovel is used against the ground.
You are using the wrong end of Oracle for this task.


Trying to use Oracle to backup MYSQL, is abusing wrong tool for the job.
Use MYSQL utilities or Operating System to backup MYSQL.

[Updated on: Wed, 04 February 2009 23:34]

Report message to a moderator

Re: Heterogeneous services [message #384722 is a reply to message #384718] Thu, 05 February 2009 00:01 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
thanks for your reply.My question is how can i take mysql backup, which is on the remote server?
Re: Heterogeneous services [message #384728 is a reply to message #384717] Thu, 05 February 2009 00:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>My question is how can i take mysql backup, which is on the remote server?
Why are you asking how to take a MYSQL backup in/on an Oracle forum?
I would think a MYSQL forum might provide better responses.

When your only tool is a hammer, all problems look like nails.
A hammer is not best solution for a screw.
Re: Heterogeneous services [message #384733 is a reply to message #384728] Thu, 05 February 2009 00:22 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
sorry for my ignorence.i know how to take backup of mysql.but as a fresher i am asking you that is there any way to get the back up of mysql connecting (mysql DB) through oracle?(Taking mysql backup through oracle?)
regards
SRIRAM
Re: Heterogeneous services [message #384739 is a reply to message #384717] Thu, 05 February 2009 00:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
While both MYSQL & Oracle are RDBMS it is similar to comparing relgions; pick yours.

Simply put religious wars erupt.
They do not mix well or at all.
IMO, it is best to avoid any "interaction".
Re: Heterogeneous services [message #384801 is a reply to message #384717] Thu, 05 February 2009 04:31 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The only way you could take a 'backup' of a MySql database using Oracle HS would be to copy the contents of the MySql Db into Oracle.

There are a set of instructions for setting up Oracle HS here

Oracle tools like IMP and EXP won't touch data across an HS link.
Re: Heterogeneous services [message #385090 is a reply to message #384801] Fri, 06 February 2009 06:43 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thank you JROWBOTTOM.
thanks for your reply.
REGARDS
sriram
Previous Topic: Possible Combinations between RMAN and TDE
Next Topic: Register Database error
Goto Forum:
  


Current Time: Fri Mar 29 01:31:55 CDT 2024