Re: standby at remote site
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Fri, 27 Mar 2009 08:58:40 +1100
Hi
Also gives the opportunity to run the Standby on primary an hour or so
behind in the apply so you can easily recover when a user goes "Oops, silly
me just deleted the record without the where clause and now table is empty.
Let's phone our DBA and see if he can save my butt"
Jack
2009/3/27 Niall Litchfield <niall.litchfield@xxxxxxxxx>
> In addition to jason's remarks i'd add that you'll want to be clear
> about how switchover and failover will happen and how the choice of
> new primary is made. Then test at least switchover and resultant
> application and interface etc performance.
>
> On 3/26/09, Jason Heinrich <jheinrichdba@xxxxxxxxx> wrote:
> > This is a fairly common DR scenario. I would just make sure that you
> have
> > sufficient bandwidth between the sites to ship the logs. See
> >
> http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_DataGuardNetworkBestPractices.pdffor
> > some tips on optimizing the redo transport.
> >
> > --
> > Jason Heinrich
> >
> >
> > On Thu, Mar 26, 2009 at 11:08 AM, Kumar Madduri <ksmadduri@xxxxxxxxx>
> wrote:
> >
> >> Hi List:
> >> We have a standby here but we want to create an additional standby at a
> >> remote location. So 2 standbys. One is in the same location (not the
> same
> >> server) another in a remote location- this would be the DR site. Wanted
> >> to
> >> get the experience of the list and any areas to watch out for in this
> kind
> >> of setup.
> >>
> >> Primary is 2 node rac. Standy is single instance; DB is on 10.2.0.4
> >>
> >> Thank you
> >> Kumar
> >>
> >
>
> --
> Sent from Google Mail for mobile | mobile.google.com
>
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
Other related posts:
