Re: Cloud-based Real-Time Site Fail-over

On Mon, 2024-05-27 at 16:37 -0400, Alan Sterger wrote:
> Hello,
>
> Looking for technical solutions (white papers, URLs, pricing...) for
> cloud-based, real-time failover between geographically disparate sites. 
> Client currently utilizes Azure in its Sweden data center.  Application
> is web based with Oracle clients and IIS communicating with a single
> Oracle database (non-CDB).
>
> Some in management are convinced an all Oracle solution would be
> prohibitively expensive and/or not feasible when used with Oracle VPD
> (DBMS_RLS).
>
> Can you shed any light?
>
> -- Alan Sterger
> asterger_at_earthlink.net
> --
> http://www.freelists.org/webpage/oracle-l
>
>

Well, you may call me adventurous, but I would go with the classic standby (not active DG). The problem with the active DG is that it is possible to connect to both databases, the primary and the standby. One relies on redirection from standby to the primary in case of a DML. However, redirection is not available in the public cloud and you mentioned Azure cloud:

https://apex.oracle.com/pls/apex/features/r/dbfeatures/features?feature_id=1093

So, that means that active DG is no good for the public cloud. A normal mounted standby in the maximum availability (meaning synchronous commit) mode will probably do the trick. Depending on the traffic on the primary side, you will probably need a hefty network pipe between the primary and the standby. You can use far sync to reduce the network traffic and increase throughput. RAC is not supported in a non-OCI cloud so the only way is some kind of replication. You can use Golden Gate or SharePlex to create a copy of the database, but the catch is that is necessary to automate fail-over yourself, no DG observer in that case.

-- 
Mladen Gogala
Database SME
https://dbwhisperer.wordpress.com


--
http://www.freelists.org/webpage/oracle-l