Oracle failover cluster on Windows 2xxx FCI

Hi,
I think you are talking about Oracle Fail Safe: https://docs.oracle.com/cd/E67869_01/#
It can do HA on Microsoft Failover Cluster in all Oracle Edition. But deprecated in 19c (even if still supported) so there is not a great future.
Franck.

so there is not a great future. 

what ? not good for the future ? so we should only use RAC instead ? what other cluster solution oracle offer?

Hi,
Yes, Oracle is pushing more features on RAC and then will probably desupport this in the future.
If you can accept a few minutes of RTO in case of failover, Oracle has also Data Guard which protects better because the database is replicated. This is in Enterprise Edition. For Standard Edition there's a similar possibility with an additional product: https://dbvisit.com/our-solutions/dbvisit-standby

so it seems we should not use that as RAC do the same thing and now it is just the licensing issue? how many nodes for a RAC included in oracle enterprise edition ?

This will depend on how many nodes/cores (units), the RAC will be running ;-)

https://flashdba.com/2013/09/18/the-real-cost-of-oracle-rac/

and then will probably desupport this in the future.

This is true for RAC on SE2 -> This will definetely end :-(
But for EE, RAC goes on and on and on.....

If you can accept a few minutes of RTO in case of failover, Oracle has also Data Guard which protects better because the database is replicated.  

but data guard only try to replicate to DR site, right?

and this is the existing license we have .


so this is part of the HA too and primary site use failed safe? and how many oracle nodes we can have using failed safe?

@marrowyung : Don't let this slip into some kind of duplicate of your other question here!!

https://www.experts-exchange.com/questions/29199895/Oracle-RAC-license.html

yeah, but here include oracle fail safe too and Franck in this loop.

Just don't mix them up!
This one's here is about "Oracle failover cluster on Windows 2xxx FCI", the other one is about "Oracle RAC license"...

Hi, Data Guard can be set as automatic failover, and then provide HA. This is called FSFO.

Franck  ,
tks.

it seems an oracle instance with fail safe as a 2 nodes FCI as a HA solution and to DR site we use active data guard should be the only solution for my questions ?

Data Guard is probably sufficient. No need for the Active Data Guard option. 

yeah, but we have active data guard license. then just simply use it,

the most important part is fail safe as we don't have RAC license, and we are not going to buy it, so fail safe is included in the EE license and it seems the only way to setup HA in a 2 x nodes active/passive failover instance?

then we setup data guard on top of it. right ?

hi,

any idea on what is the source of fail safe installation? included in the binary of oracle 19c ?

seems this installation page do not have oracle universal installer! then how can I use installer to install fail safe !


https://docs.oracle.com/cd/E67869_01/OFSIG/introduction-and-preinstallation-checklist.htm#OFSIG117

Btw: Oracle Fail Safe is deprecated with Oracle Database 19c!! 

you mean this feature is not going to available in 19c ? or it just do not have support?

I am checking with fail safe installation source , any idea? or it already included in the oracle 19c installation binary ?

https://www.oracle.com/database/technologies/software-packager-installer.html

or

https://www.oracle.com/database/technologies/dotnet-odacdev-downloads.html

Certification

If you wonder about the release notes saying, Fail Safe 4.2.1 is support with Oracle Database 12.2, then this refers to 12.2.0.1, 18c and 19c.

ok, this means Fail Safe 4.2.1 can work with 19c as well, tks.

Yes

tks both.

Just to add: Failsafe is still supported. The future of it for future versions will depend on whether Oracle has important customers with it. But given that SQL Server is moving towards Linux, the competition with windows platform is less important than the Failsafe was introduced. So it will probably disappear in the future, but not short-term...

Failsafe is still supported 

this means still have patches..?

But given that SQL Server is moving towards Linux, the competition with windows platform is less 

I think oracle never complete with SQL serve on Windows platform, right?

So it will probably disappear in the future, but not short-term... 

I hope our client buy oracle RAC license.

one thing, is this fail safe convertible to RAC?

>> one thing, is this fail safe convertible to RAC?
No, you need to re-install. But the database is independent.

tks man.

any practical/still real installation guide for fail safe 4.2?

Apart from the official docs, https://docs.oracle.com/cd/E67869_01/OFSIG/installing-ofs.htm#OFSIG118, there are only few (if any) resources on the web :-(

there are only few (if any) resources on the web :-( 

that's why I come and ask, very very few as we should RAC instead.

https://docs.oracle.com/cd/E67869_01/OFSIG/installing-ofs.htm#OFSIG118,  

is not that good at all sorry. 

please help on this:
https://www.experts-exchange.com/questions/29201816/setup-active-data-guard-between-2-x-nodes-Oracle-19c-failed-safe-cluster-on-Windows-with-a-standalone-oracle-19c.html#questionAdd

hi,

when we try to install fail safe we see this error message;


any idea ?

and we did check cluster log and I am not sure if this is related:

Cluster network name resource 'TBISDBSP' encountered an error enabling the network name on this node. The reason for the failure was:
 'Unable to obtain a logon token'.

 The error code was '1787'.

 You may take the network name resource offline and online again to retry.

and this one:

Cluster network name resource 'Cluster Name' encountered an error enabling the network name on this node. The reason for the failure was:
 'Unable to obtain a logon token'.

 The error code was '-1073741717'.

 You may take the network name resource offline and online again to retry.

Sorry, not really my topic anymore from there :-(
I'd have to google, too...

ahaa

Ouch, sorry no idea. It is a really old product - the install screen has the look of the 8i installer 🤷‍♂️

ok