Re: Oracle database HA on VMWare without using RAC

From: Tim Gorman <tim.evdbt_at_gmail.com>
Date: Sun, 2 Aug 2020 09:38:39 -0700
Message-ID: <e837e431-9e47-3d3b-2240-e738db8aa748_at_gmail.com>



You can also use [Active] DataGuard with Fast-Start Failover (FSFO) if you have already licensed Enterprise Edition, or open-source Pacemaker/Corosync (PCS) Linux HA clustering if you don't fancy licensing anything for HA, provided you're using Oracle Enterprise Linux.

It is surprising how few failure scenarios RAC is capable of remedying, how many failures are caused by clusterware and RAC, and how many more failures can be prevented with true HA solutions.

On 8/1/2020 12:51 PM, Mladen Gogala wrote:
>
> 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 Sun Aug 02 2020 - 18:38:39 CEST

Original text of this message