Oracle Sharded Database Disaster Recovery across data centre in Kubernetes

[viju2008]

Hello,

Is it possible to implement replication of Oracle Sharded Database in Kubernetes for cluster to cluster replication of Oracle Databases on Kubernetes

Scenario:

If we have a Sharded Database in Cluster-1 in Data Centre 1 and if we have to set up a Disaster Recovery of the Sharded Database in Cluster-2 in Data Centre 2 and then replicate the Shards in Data Centre1 using Oracle Data Guard or Oracle Active DataGuard.

All the shards in PR will be replicated to DR. At present we plan to have 1 shard per microservice and all these shards will be replicated to DR. All writes will go to one data centre only. All shards will have 2 replica in PR and a mirror replica in DR . If shard 1 fails in PR, it will failover to replica of the shard in the same data centre. When we switchover to DR we shall work on the Shard Replica in DR. So there will be 3 copies of the data at any point of time (2 in PR and one in DR)

Please inform us if the same is possible using Kubernetes. Please provide the YAML. In case it is not possible , please inform what approaches of switchover from PR to DR are possible in Shard Database for Kubernetes.

Whenever we switch over to DR, the applications in Data Centre 2 will access the DataCentre 2 DB which would have all the data as it is being synced by Oracle DataGuard.