Hi,
I am establishing a Data Guard environment configured to work in asynchronous mode between two far sites.
Between the site there are 2 network lines: The main line has 10Gb bandwidth, and the backup line has 1Gb bandwidth.
Regularly the main line should be used.
When this line will fail I want the connection to switch to the backup line - automatically.
I thought about using the following configuration:
on the primary
tnsnames.ora
standby =
(DESCRIPTION=
(LOAD_BALANCE=off)
(FAILOVER=on)
(ADDRESS=
(PROTOCOL=tcp)
(HOST=stndby_host_main)
(PORT=1521))
(ADDRESS=
(PROTOCOL=tcp)
(HOST=stndby_host_backup)
(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=stndby)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
the ip of stndby_host_main will direct me to the standby server via the main 10g line
the ip of stndby_host_backup will direct me to the same standby server via the backup 1g line
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prmry_host_main )(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = prmry_host_backup )(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
on the standby
tnsnames.ora
primary =
(DESCRIPTION=
(LOAD_BALANCE=off)
(FAILOVER=on)
(ADDRESS=
(PROTOCOL=tcp)
(HOST=prmry_host_main)
(PORT=1521))
(ADDRESS=
(PROTOCOL=tcp)
(HOST=prmry_host_backup)
(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=prmry)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
the ip of prmry_host_main will direct me to the primary server via the main 10g line
the ip of prmry_host_backup will direct me to the same primary server via the backup 1g line
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stndby_host_main )(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = stndby_host_backup )(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
My question is:
How to enable automatic fail back to the main line when it is back, and abandon the backup line.
Thanks
Yossi