Re: Dataguard setup at DR site

From: Howard Latham <howard.latham_at_gmail.com>
Date: Sat, 25 Apr 2009 22:48:20 +0100
Message-ID: <713d96d10904251448t6384a52dwb6de953346bdf7e_at_mail.gmail.com>

DG evolved from 'log shipping' and need not exist now. It does provide extra features and it does TRY and manage
everything for you but you can have a 'data guard' setup without dataguard. I was tld itit sorts out network failures etc for you and probaly the tools it gives you are worth it. I imagine that auditors might prefer a proper DG setup ?

Coments anyone?

2009/4/25 Kumar Madduri <ksmadduri_at_gmail.com>

> ---------- Forwarded message ----------
> From: Kumar Madduri <ksmadduri_at_gmail.com>
> Date: Sat, Apr 25, 2009 at 1:13 PM
> Subject: Re: Dataguard setup at DR site
> To: asif_oracle_at_yahoo.com
> Cc: Oracle-L_at_freelists.org
>
>
> Thank you Asif.
> I read about cascading databases. But my question was, does it really
> matter how the original standby is constructed (in my case I am not
> using DG to build the standby). Even in this case can I cascade from
> my standby to my DR standby (which I am planning to set it up using
> DG). Theoritically it should be fine.
> In that case, can I disable force loggin on production and enable
> force logging on standby only. That way I would minimize any
> performance impact.
> So primary no force logging > standby (using old method of applying
> redo) has force logging . THis is used as source for standby on DR
> site (which will use DR).
>
> Thank you
> - Kumar
>
>
> On Sat, Apr 25, 2009 at 1:03 PM, Asif Momen <asif_oracle_at_yahoo.com> wrote:
> > Dear Kumar,
> >
> >>> Is it possible to use the cascade standby approach in this scenario?
> >
> > Yes, you can have cascaded physical standby databases (I think you can go
> up
> > to 9 cascaded standby databases)
> >
> >>> Based on the real world experience, how much of a performance impact
> >>> would it be if force logging is enabled?
> >
> > The answer is, "it really depends". In an OLTP environment you would gain
> > little to no whereas in a data warehouse env you may have huge gains.
> > You may have nologging operations performed on the primary yet keeping
> your
> > standby database in sync.
> >
> >
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#i1015738
> >
> >
> > Regards
> >
> > Asif Momen
> > http://momendba.blogspot.com
> >
> >
> > --- On Sat, 4/25/09, Kumar Madduri <ksmadduri_at_gmail.com> wrote:
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Howard A. Latham

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

Received on Sat Apr 25 2009 - 16:48:20 CDT