Folks,

We have data centers all over the country. The central site which is a premier site
has the production server. Another premier site houses the standby for the production.
There are eight other non-premier sites where we have basic replication set up.

We have a database on a production server. Also, we have read-only snapshots
on a replication server (basic replication). For the production database, we have
a standby datatabase setup, so in case of a failover, the standby takes over. Now
the problem is that what kind of procedure must be implemented if a replication
server fails? Do the user in the site go to another replication server and get its
information and how? I want to know if there is a way to automatically set up the
replication sites such that the application at site A detects that it's replica is not working
and goes to another site (site B) automatically and gets its information from that
other site(site B).

Thanks,
saigals