OraFAQ Forum: Backup & Recovery » Heterogeneous services

Home » RDBMS Server » Backup & Recovery » Heterogeneous services (oracle10gR2.3.linux(client->windows 2003 server))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Heterogeneous services [message #384717]

Wed, 04 February 2009 23:29

ramoradba
Messages: 2457
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

Report message to a moderator

Re: Heterogeneous services [message #384718 is a reply to message #384717]

Wed, 04 February 2009 23:33

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

ramoradba
Messages: 2457
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?

Report message to a moderator

Re: Heterogeneous services [message #384728 is a reply to message #384717]

Thu, 05 February 2009 00:09

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.

Report message to a moderator

Re: Heterogeneous services [message #384733 is a reply to message #384728]

Thu, 05 February 2009 00:22

ramoradba
Messages: 2457
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

Report message to a moderator

Re: Heterogeneous services [message #384739 is a reply to message #384717]

Thu, 05 February 2009 00:32

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".

Report message to a moderator

Re: Heterogeneous services [message #384801 is a reply to message #384717]

Thu, 05 February 2009 04:31

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.

Report message to a moderator

Re: Heterogeneous services [message #385090 is a reply to message #384801]

Fri, 06 February 2009 06:43

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Thank you JROWBOTTOM.
thanks for your reply.
REGARDS
sriram

Report message to a moderator

Previous Topic:	Possible Combinations between RMAN and TDE
Next Topic:	Register Database error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 08:05:04 CST 2024