RE: Cascading standby creation
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <sbecker6925@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Nov 2012 13:55:48 -0400
I've never done a cascading standby with Oracle's product, so I don't know
the answer to your EM question.
Using roll your own procedures (it is, after all, just recovery unless you
need Active read only), you can instantiate (or re-instantiate) from either
the primary or another standby with recovery temporarily cancelled. If you
don't want to molest the primary and re-instantiation of the upstream
standby is required, you can even do that from the downstream standby as
long as you still have the relevant archive logs to cover any gap if the
downstream standby is behind.
You can also fork shipping and application of changes to multiple
destinations directly without a cascade relationship (but that does involve
more traffic on the network of the primary).
I'll bet someone has the EM answer at their fingertips and relevant "fun
facts to know and tell" about using dataguard for cascaded standby creation.
Good luck. It sounds like you're pursuing something important!
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sandra Becker
Sent: Thursday, November 01, 2012 1:42 PM
To: oracle-l
Subject: Cascading standby creation
Running 11.2.0.2, SLES11
Current set up is primary to a single physical standby. Goal is to set up a
second physical cascading standby.
Questions: Can the cascaded standby be created through EM? If yes, do you
create it from the primary or the first standby?
--
Sandy
Transzap, Inc.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
