The Cross-Region Autonomous Data Guard feature of Oracle Autonomous Database provides data protection and disaster recovery for your database.

If you enable Autonomous Data Guard with a cross-region standby database on your ATP, you can manually construct a new ATP wallet with single connection string containing both the primary and the standby database hostnames. This way, when you failover to a standby ATP database, Visual Builder will be automatically retry and connect to the ATP in the standby region, which then becomes the active database.

For details on how to manually construct a wallet that contains both the primary and the remote database connection strings, see Cross-Region Autonomous Data Guard Notes.

A database connection string in the wallet identifying the primary and standby hostnames might look something like this:

atpsample_tp = (description_list=
 (failover=on) (load_balance=off)
 (description= (retry_count=5)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=g0de0f6e24ce255_atpsample_tp_tp.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))
 (description= (retry_count=5)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.ca-montreal-1.oraclecloud.com))(connect_data=(service_name=g0de0f6e24ce255_atpsample_tp_tp.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes))))