How to failover to an oracle OCI database connection on Synapse?

Question

Hello -

We have a setup like this:

1. Azure over VPN connects to Oracle OCI database
2. Create a Linked service like for on DR database (oCI database)
3. I need to failover when I can Oracle OCI database failover from DR to primary database.

How can I make sure all azure pipelines are working and connection between these two databases.

Oracle OCI have different hostname and service name so have to be a separate linked service.

Please can you help!

Thanks

Answer 1

@Xhevahir Mehalla ,

Welcome to Microsoft Q&A platform and thanks for posting your query here.

To ensure that your Azure pipelines are working and the connection between the two databases is maintained after a failover from DR to primary database, you can follow these steps:

1. Create two separate linked services in Azure Data Factory, one for the DR database and one for the primary database. Make sure to use the correct hostname and service name for each linked service.
2. Create two separate datasets in Azure Data Factory, one for the DR database and one for the primary database. Use the appropriate linked service for each dataset.
3. Create your pipeline in such a way that if an activity using the DR dataset fails , the next activities are connected using skip conditional path and the entire pipeline fails.

To handle failover from DR to primary database, you can monitor the status of the DR database using Azure Monitor . When the DR database fails over to the primary database, you can receive an alert.

I hope this helps! Let me know how it goes. Thankyou