Re: Replication question

Hello Dennis

The only schema changes you need for advance replication is primary key for each table (not a must but preferable).

Quest product, Shareplex, also prefer primary keys. According to Quest (not tested yet) their product use a lot less resources on the source system because AR is implemented via triggers.

The use of stand by against AR is the use of the second database. If you want to use it for queries or even update you need advance replication.
Also, I think that AR will send a lot less data through the network and the same for Quest Shareplex.

Synchronous Vs asynchronous depends on the need for two phase commit or you can live with a slight lag. It also depends on the network. Also, from the docs, asynchronous use more resources in the source system, as it writes the updates to an oracle table, reads them, send them across and then delete them from the tables.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, June 14, 2002 4:58 PM

> We are just starting to look at replication so each manufacturing plant
can
> have their own server. The applications are being developed in-house. I
feel
> the first issue is to analyze each table and decide how it will be
> replicated and what schema changes need to me made to accommodate
> replication. Instead, one of the developers wants to talk to Quest about
> their solution. It seems to me that you need to make the same evaluation
and
> schema changes where needed. If anyone can point me to a white paper on
> schema changes to consider, that would be appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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).