Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Custom rolled HA using Oracle SE

Custom rolled HA using Oracle SE

From: Billy <vslabs_at_onwe.co.za>
Date: 17 May 2005 05:45:09 -0700
Message-ID: <1116333909.852702.16200@g49g2000cwa.googlegroups.com>


Would like some comments on how you would tackle the following.

2 nodes running Oracle SE. One to serve as primary and the other as a standby for HA.

Application - batch process (daemonised) doing close to real-time processing, whacking tons of data into Oracle (direct path inserts at over 300 inserts/sec), running on the same node as the primary instance.

As the application resides with the database, it makes failover interesting.. never mind that this is Oracle SE which means no Data Guard.

Okay, so
a) what kind of config would you put together to switch processing (instance & application) over from primary to standby in case of a failure of the primary?
b) how would you keep the two instances in sync?

.. and no, you cannot shoot the hostage in the leg either. ;-)

Specifics. 10G SE as the software, Perl/Perl-DBI as the batch app and RH WS 3 as o/s.

I have some idea on what I want to do witht his, but can do with others' thoughts on it.

--
Billy
Received on Tue May 17 2005 - 07:45:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US