Is there a possibility to have 2 databases in production (clone to each other) & application can auto-switch to 2nd database if the first is made down for some changes so that users do not experience any outage.
We are using Websphere for App server and Oracle 19c for Database
@KevinZheng_GCS I don't see any option of using an alternate server in the Websphere as mentioned in the URL above. However, it seems no such facility exists at WAS. Rather It may be achieved by using a load-balanced JDBC connection string from DB end where one DB can be failed over to another in case of any issue.