RE: Oracle database HA on VMWare without using RAC

Thanks Mladen!
Have you had any experience with using VMWare's VMotion feature to provide HA to Oracle databases? We are looking for a cost effective way to provide HA to an Oracle database. RAC, Veritas, GG are all excellent but expensive options. What I don't know is how effective VMotion is in minimizing the outage time for Oracle databases.

Thanks
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mladen Gogala Sent: Saturday, August 1, 2020 3:51 PM
To: oracle-l_at_freelists.org
Subject: Re: Oracle database HA on VMWare without using RAC

Standby database or Golden Gate are rather usual options. Other than that, you can setup a Veritas failover cluster for VMWare:

https://www.veritas.com/content/support/en_US/doc/ka6f10000000CAjAAM

You can do the same thing using MSFT cluster:

https://docs.vmware.com/en/VMware-vSphere/6.0/vsphere-esxi-vcenter-server-601-setup-mscs.pdf

There is also VMWare HA:

https://www.vmware.com/pdf/vmware_ha_wp.pdf

Last, but definitely not least, there is Commvault Live Sync for VMWare. It's sort of standby for VMWare.

https://documentation.commvault.com/commvault/v11/article?p=106002.htm

Virtual machines are disk files. Fail-over clusters move the disk drive to the surviving node and restart the service. There are also hardware based solutions on remote disk replication. Every major SAN vendor (EMC, Hitachi, NetApp) has remote disk replication software, usually for the high end arrays and usually separately licensed. What kind of money are you looking to spend? What is the acceptable switch-over time? Are you looking for the software-only solution, hardware solution or the combination of both? Here is a good article about VMWare high availability:

https://www.nakivo.com/blog/vm-failover-guide/

This is a question for a system architect within your company. The most important question is how much do you want to spend? When you have the $$$ then it's basically testing various commercial solutions, some of which are listed above.

On 7/31/20 11:08 PM, Hameed, Amir wrote: Hi,
I am looking for options/features available in VMWare to provide high-availability to single-instance Oracle databases. If anyone is using VMWare to provide HA solution to their Oracle database, I would appreciate if I could be pointed to the right direction.

Thank you,
Amir

--

Mladen Gogala

Database Consultant

Tel: (347) 321-1217

--

http://www.freelists.org/webpage/oracle-l Received on Sat Aug 01 2020 - 22:35:23 CEST