Re: Cascading standby creation

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 1 Nov 2012 12:05:25 -0600
Message-ID: <CAJzM94AWPKFBwG5kDo5zvb6bWJLtHLAhBwFzH65CTk6+kK66NA_at_mail.gmail.com>

We don't want the overhead on the primary, hence the idea of using the cascaded standby. The lag on the cascaded standby isn't as important since it won't be used for disaster recovery. The second standby will be used to feed development, QA, and tier2 databases. So if I'm understanding this process correctly, and that's not a given by any means, restore the second standby and set up the log_archive_dest_n correctly on all the databases and I should be in business? Assuming my IT guys get the new server set up correctly so I can actually write to it. I feel like I'm missing a piece here.

Sandy

On Thu, Nov 1, 2012 at 11:55 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> 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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Sandy
Transzap, Inc.


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 01 2012 - 19:05:25 CET