I have an Oracle CDC instance that runs great during the day, but stops every evening. I discovered that the Oracle source databases are actually performing offline backups each night, which causes the CDC instance to disconnect. Unfortunately, I am not able to change the way the backups are being performed so I am trying to find a solution within the CDC setup itself. Is there any way to pause the instance if it can't find the source and set it to start up again after a certain amount of time? Or some other way to prevent the instance from completely stopping each time it disconnects.
Thanks for any input!