Network line switch-over in Oracle Data Guard We have a Primary database with a remote Standby which established using Oracle Data Guard. They can be syncing over a private Wireless Network and a Wired LAN (There are two options as network medium)

Is there any setting in Data Guard to handle network line failure? For example, I want to set wired LAN as main line and when it is not available data guard automatically switch to wireless network.
Sure, you can configure alternate locations.

You may have this now on the primary database:

log_archive_dest_1='location=use_db_recovery_file_dest' -- FRA for local archivelogs 
log_archive_dest_2='service=standby_TNS_wired_network ...'


And you can configure this:

log_archive_dest_1='location=use_db_recovery_file_dest' -- FRA for local archivelogs
log_archive_dest_2='service=standby_TNS_wired_network ... alternate=log_archive_dest_3'
log_archive_dest_3='service=standby_TNS_wireless_network ... alternate=log_archive_dest_2'
log_archive_dest_state_2=enable
log_archive_dest_state_3=alternate


Example 17-3 Defining an Alternate Oracle Net Service Name to the Same Standby Database


LOG_ARCHIVE_DEST_2='SERVICE=stby1_path1 MAX_FAILURE=1 ALTERNATE=LOG_ARCHIVE_DEST_3 DB_UNIQUE_NAME=stdby1'
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_DEST_STATE_3=ALTERNATE
LOG_ARCHIVE_DEST_3='SERVICE=stby1_path2 DB_UNIQUE_NAME=stdby1'