Please advice!

[dba_dada]

Linux Redhat 8 and Oracle 8i or 9i.

I have to build a failover server in read/write environment automatically in
the event of a system failure. This application being business critical,
we would like to have a complete and synchronous on another database located
at another site (the 2 sites are linked via t1).

There would be only one master, and we would have to
switch automatically to the alternate database in case of problem.

I was hoping that you could share
your experiences and approaches to this problem.

Thanks!