Debezium with Multiple Oracle Archive Log Destinations

[Rob Davis]

Good afternoon!

We have been working with Debezium and recently stumbled upon an issue with our implementation.

Our Oracle database servers have multiple log destinations (log_archive_dest_1, log_archive_dest_2, log_archive_dest_3, etc.). Every month we switch over the instances to standby DB instances and the archive log destinations may change.

When we switch from instance 1 to 2, the archive destination changes from log_archive_dest_1/3 to log_archive_dest_2.

It looks like there is an option to set the archive log file destination in the Oracle source connector. However, it looks like only destination is allowed.

Is there anyway to specify a list of valid destinations? It sounds like it picks the first destination that results from a query when there is none specified in the parameter.

Thanks for the help!

Justin

[Chris Cranford]

Hi -

Unfortunately the connector currently only supports a single destination name, but I can certainly see making it allow for multiple values in a precedence-driven order. Could you raise a Jira issue [1]?

And just understand, and we'll document it as such, with such a change that setting the property with multiple values and if the DBA team chooses to use a destination that's on that list with a higher precedence without your knowledge, then the connector will use those files, even if that destination has a significantly shorter retention policy. So you may find yourself needing to change the configuration regardless should this come to pass. 

[1]: https://issues.redhat.com/projects/DBZ

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/4fd7c1bf-e463-4569-9ec1-fc7cce24b58bn%40googlegroups.com.

[Rob Davis]

Hey Chris,

I have created the Jira as requested: https://issues.redhat.com/browse/DBZ-9041 .

Thanks!

[Rob Davis]

Hey Chris,

Thanks for working on this!

I have tested this out, and it looks like it's not going to work for our use case. I have created another Jira with some additional details: https://issues.redhat.com/browse/DBZ-9622

I really do appreciate the support and your work on this issue regardless of if you are able to help or not!

Rob

[Chris Cranford]

Hi Rob,

Thanks for the feedback. Let's continue the discussion on the issue, as I left a few comments.

Thanks,
-cc

To view this discussion visit https://groups.google.com/d/msgid/debezium/5a3e5c10-03af-4fc8-a60a-a629d0cd56e0n%40googlegroups.com.