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: Sukhjit S Bassi <sukhjit_at_interlog.com>
Date: 1997/05/12
Message-ID: <3376A35C.449C@interlog.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
>
>
>

Mark,

I have done this stuff many times...Some insights ...maybe of some use to you ...

Sukhjit_at_interlog.com
www.interlog.com/~sukhjit Received on Mon May 12 1997 - 00:00:00 CDT

Original text of this message

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