Re: standby at remote site
Date: Thu, 26 Mar 2009 16:31:11 -0700
Clarification: In case of oracle applications, the additional steps would be to configure these middle tiers to point to the new "primary" by running autoconfig by changing the context_file for db related entries to the new "primary". Are there any other changes? But this assumes that your application tiers are not on the standby site. But if the application tiers are on the standby site as well. How do you manage the appl_top and other code trees. Similar to Data guard for db tier, how is the app tier synched other than a periodic rsync from primary to standby site. Is this the only way or is there any other way to achieve this as well?
On Thu, Mar 26, 2009 at 2:58 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:
> 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"
> 2009/3/27 Niall Litchfield <niall.litchfield_at_gmail.com>
>> 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_at_gmail.com> wrote:
>> > This is a fairly common DR scenario. I would just make sure that you
>> > sufficient bandwidth between the sites to ship the logs. See
>> > some tips on optimizing the redo transport.
>> > --
>> > Jason Heinrich
>> > On Thu, Mar 26, 2009 at 11:08 AM, Kumar Madduri <ksmadduri_at_gmail.com>
>> >> 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
>> >> server) another in a remote location- this would be the DR site.
>> >> to
>> >> get the experience of the list and any areas to watch out for in this
>> >> 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
> 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