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.

> What U know is the only possible....cause Standby is not a OPEN Database
for read/write unless.

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.

> U need to check with Replication requirements cause Standby won't be able
to write anyting cause it cannot run DDL statements

> U might have a look at Oracle Strems which is a based on AQ

======================================================
HTHU

Ankur Shah
Oracle DBA
DHR-GA



----- Original Message -----
From: "Darryl Jones" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Tuesday, April 20, 2004 12:51 PM
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