We have multiple Oracle servers that have different Log Miner archive locations. When we switchover the servers from one to another, the log archive location may change causing the Debezium source connector to fail. We need to be able to give Debezium multiple locations to look for logs in so that it doesn't fail. 

For example, servers 1 logs to both log_archive_dest_1 and log_archive_dest_3. However, server 2 logs to only log_archive_dest_2. When we switch the primary from server 1 to server 2, Debezium fails.

Implementation ideas

Just a simple list where the log archive destinations and listed by order of precedence should work. There may be a better may to implement it, but that's what I was thinking.

Example: