Re: Oracle database HA on VMWare without using RAC

From: Al B. <albert.y.balbekov_at_gmail.com>
Date: Mon, 3 Aug 2020 20:37:02 -0700
Message-ID: <CACKN2vHV9iUgLo0rUKFU+c-6gZ_aVg20oF7-C6EgxQ6c9Fpq8g_at_mail.gmail.com>



One other option may be Standard Edition High Availability. Does not require to license other nodes in a cluster as long as the failover node(s) is used less than 10 days per year.

https://blogs.oracle.com/maa/standard-edition-high-availability-officially-released

On Mon, Aug 3, 2020, 8:31 AM <dimensional.dba_at_comcast.net> wrote:

> Data Guard in either way requires you to license 2 physical Servers for
> Oracle where as VMotion depending on your setup and use could require only
> one physical server being licensed.
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *MacGregor, Ian A. (Redacted sender "ian" for DMARC)
> *Sent:* Monday, August 3, 2020 8:22 AM
> *To:* gogala.mladen_at_gmail.com; oracle-l_at_freelists.org; tim.evdbt_at_gmail.com
> *Subject:* Re: Oracle database HA on VMWare without using RAC
>
>
>
> While DataGuard and FSFO are included in an enterprise license. I do not
> believe "Active" DataGuard is included. It is not necessary to have Active
> DataGuard for FSFO to work; i.e, for the database to failover. It is
> however necessary, for application continuity.
>
>
>
>
> Ian A. MacGregor
> SLAC National Accelerator Laboratory
> Computing Division
> To offer the best IT service at the lab and be the IT provider of choice.
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Tim Gorman <tim.evdbt_at_gmail.com>
> *Sent:* Sunday, August 2, 2020 9:38 AM
> *To:* gogala.mladen_at_gmail.com <gogala.mladen_at_gmail.com>;
> oracle-l_at_freelists.org <oracle-l_at_freelists.org>
> *Subject:* Re: Oracle database HA on VMWare without using RAC
>
>
>
> 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 Tue Aug 04 2020 - 05:37:02 CEST

Original text of this message