simple 2 machine failover configuration

From: Rainer Mager <nospam-rmager_at_vgkk.co.jp>
Date: Tue, 04 Jan 2000 06:50:22 GMT
Message-ID: <OKgc4.6$e8.348@nnrp.gol.com>

Hi all,

I'm in the early stages of setting up an Oracle database. One requirement is that it handles machine failure transparently. To do this 2 Ultra-SPARC 10 machines have been allocated. What I would like to know is what is the best way to do this?

I believe what is necessary is to have both machines always contain the full database with all changes and if one fails the other handles all connections. As I mentioned, this must be transparent to the client side. If, for example, I have a Java JDBC connection to the db and its server fails then the connection closes (of course). I want that client to be able to reestablish a connection to the save server (i.e., same IP) and then continue on without any other client side reconfiguration.

Any insights would be greatly appreciated.

--Rainer

P.S. Please reply here or remove "nospam-" from my address and reply directly. Received on Tue Jan 04 2000 - 00:50:22 CST