Network line switch-over in Oracle Data Guard
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'