Hi,

Am Montag 10 April 2006 18:17 schrieb C'est Pierre:
> On another SuSE maillinglist, I was told about Oracle RAC and I talked
> to our local Oracle DBA. He told me that RAC serves the purpose when
> there's 2 oracle instances, each on a different server, both sharing
> the same storage. That's not our purpose. We want that if the active
> node (server/instance) dies for some reason (network outage, hardware
> failure, etc) the other server takes the lead, launches an oracle
> instance and mounts the storage.

Re-Mounting the storage should not be a problem with any machine having
installed the same rdbms, and beeing configured correctly. You won't need any
clusterware for this. Just use LinuxHA as heartbeat system, and use the
Oracle startup scripts as protected service. As soon as one machine will die,
the other will boot, mount and open the DB. Good combination would be ASM on
raw devices, and a good STONITH device maybe.

Not really an answer to your question, but maybe another way of seeing the
problem:
Have you thought of using Dataguard? It's an Oracle-proprietary replication
for hot/cold setups. But they are not using the same storage, indeed.

Kind regards,
--
Mit freundlichen Grüßen

i.A. Martin Klier
Systemadministration / Datenbanken
-----------------------------------------------------------------
A.T.U Auto-Teile-Unger
Handels GmbH & Co. KG
Dr.-Kilian-Straße 4
D-92637 Weiden i. d. OPf.