RE: maintaining a backup table on another server

From: <john.armani_at_us.abb.com>
Date: Tue, 20 Mar 2001 06:13:55 -0800
Message-ID: <F001.002D17FA.20010320052027@fatcity.com>

Thanks for the reply Jacques.

I need to insert quite a bit of data (say 300-400 rows), and would like to perform the inserts as the data is collected. I would like to have the two server connections open at once. Otherwise, I would need to buffer the data and update each server separately. The speed factor is critical in this situation.

I am also looking into using "runtime contexts" in a multithreaded application. Not sure if this approach is viable.

John Armani
john.armani_at_us.abb.com

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com> Date: Mon, 19 Mar 2001 11:04:56 -0800 Subject: RE: maintaining a backup table on another server

See my answer below.

> -----Original Message-----
> From: john.armani_at_us.abb.com [mailto:john.armani_at_us.abb.com]
>
> We have a single table that contains audit information, and
> would like to create an identical table on a separate server
> that we will update at the same time we update the primary
> server table. Multiple primary servers could exist throughout
> the system, and a common backup server could be shared by
> multiple primary servers. The inserts, updates, and deletes
> would be done from pro*c library routines that would exist on client
> machines.
>
> A simple solution would be to create a database link to the
> backup table, and whenever we update the primary table we will
> send a second update to the backup table (via the database link).
> This approach works fine as long as the servers are up, but raises
> issues in the case if one or both is down at update time.
>
> What other alternatives can we look into? Is the Parallel
> Server concept an overkill?

If I understand your situation correctly, you want an application to update two tables in two different Oracle databases (that we will call A and B). If you use a database link from A to B, when A is down, this will prevent both updates, which is your concern.
Why not have the application open two different connections - one to A and one to B? I'm pretty sure that it's possible in Pro*C.

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

   Jacques R. Kilchoer
   (949) 754-8816
   Quest Software, Inc.
   8001 Irvine Center Drive
   Irvine, California 92618
   U.S.A.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: john.armani_at_us.abb.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Mar 20 2001 - 08:13:55 CST