Dataguard Configuration for XPT Services
Posted on 2006-03-28
I am attempting to configure a Dataguard environment which utilises connect time failover, so during a Switchover scenario, clients are able to connect to the New Primary without the need for reconfiguring DNS or change TNSNAMES.ORA on client-side. However in doing so, we can't ship logs back to the Old primary (see below)
So, in the TNSNAMES.ora file we have :
(ADDRESS = (PROTOCOL = TCP)(HOST = trade_t)(PORT = 1563))
(ADDRESS = (PROTOCOL = TCP)(HOST = trade_t_stby)(PORT = 1563))
(SERVICE_NAME = TRADE_T.contact-energy.co.nz)
The idea being that during a SWITCHOVER situation we close the old Primary Listener, therefore closing all connections to the OLD Primary (trade_t). However, as the trade_t_xpt service has registered with the TRADE_T listener, it can't ship logs back from the new primary (trade_t_stby) to the new standby (trade_t).
The actual switchover (and failovers) are working fine.It's just that I want a configuration taht requires a change to DNS or mods to the client tnsnames.ora during any switchover.