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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On
Behalf Of MacGregor, Ian A. (Redacted sender "ian" for DMARC)
Sent: Monday, August 3, 2020 8:22 AM
To: gogala.mladen@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx; tim.evdbt@xxxxxxxxx
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@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> > on
behalf of Tim Gorman <tim.evdbt@xxxxxxxxx <mailto:tim.evdbt@xxxxxxxxx> >
Sent: Sunday, August 2, 2020 9:38 AM
To: gogala.mladen@xxxxxxxxx <mailto:gogala.mladen@xxxxxxxxx>
<gogala.mladen@xxxxxxxxx <mailto:gogala.mladen@xxxxxxxxx> >;
oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
<oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx> >
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-60
1-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
