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 -> Re: Oracle Replication

Re: Oracle Replication

From: Ashok Kapur <afkapur_at_hacemx.hac.com>
Date: 1997/05/12
Message-ID: <3377E727.38C3@hacemx.hac.com>#1/1

aaa wrote:
>
> Recently I have been asked to set up replication between two NT boxes (I
> know, I prefer UNIX too). I am an experienced Oracle DBA but after a few
> hours of trying to get replication to work I had to keep reminding myself
> of this to keep my spirits up. I was hoping someone might have some
> personal insights as to how to get replication working for the first time.
>
> The Primary goal for the systems was to offer some measure of load
> balancing and provide fault tolerance in the event of a single environment
> failure (7x24 operation).
>
> Specifications:
>
> - Replicate all table data between two geographically separated
> environments (T-1 network line).
>
> - If object definitions could be replicated all the better but not
> necessary.
>
> - Updates will occur in either environment simultaneously (volume is
> relatively low 1000 transactions / day / environment).
>
> - The application accessing the database environments would still have to
> be operational in the case of either system going down.
>
> My Approach:
>
> I thought it would be a snap using Oracles replication manager but nothing
> seems to be replicating in the two environments after setting up my Master
> groups. I have repeatedly selected generate objects and resume replication
> with no effect. There aren't even any generated objects showing up in the
> generated objects folder (perhaps a clue).
>
> I read Oracle's Distibuted Systems Volume II: Replicated Data book and BBS
> 2546 article and thought I was religiously following the directions but
> obviously not.
>
> Any personal insights would be appreciated.
>
> Mark
> mlgraham_at_bellsouth.net
>
>
>

I have been able to successfullt setup replication enviromnet using the Replication Manager. The key that I found works best is to replicate one table at a time and to replicate tables in such a way such that subordinate tables are replicated after their parents have been replicated.

Replicating views and procedures works fine by selecting more than one at a time, but for some reason the replciation manager chokes when you try to replicate more than one table at a time.

I generated replciation support for each table as I was replicating it.

Feel free to contact me if I can be of further assistance.

-- 
Ashok F. Kapur    | Galaxy Latin America |
Project Engineer  | (954)958-3373        |
afkapur_at_hacemx.hac.com
Received on Mon May 12 1997 - 00:00:00 CDT

Original text of this message

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