Darryl,

Can you explain what you hope to accomplish by having B as a primary to
C that isn't accomplished by having B & C as standbys for A? That may
help us come up with some options.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Darryl Jones [mailto:[Email Address Removed]
Sent: Tuesday, April 20, 2004 10:51 AM
To: LazyDBA.com Discussion
Subject: Would like to get some Primary Standby Replication

Hi All,

I was hoping somebody could give me some inputs and how to do the
following:
I have (3) Node on a Network. A, B, C

1) We would like to have node A as the primary and then have node B as
the standby node and then Node B be the Primary Node to Node C. This
would need to be done simultaneously. Is this possible or just wishful
thinking. Yes, we know that we can have Node A as primary and both B & C
as standby that would not statisfy our needs.

2) Or is it possible to have Node A as primary Node B has Standby and
then have Master Replication from Node B to Node C.

Thanks you for any knowledge you can bring to this dicussion.
Darryl Jones



Oracle LazyDBA home page