Re: DR implementation using Dataguard ... Best Practices ?
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Mon, 9 Jun 2008 16:52:57 -0400
Hi,
I would recommend to review the Best Practices from Oracle Corp itself -
starting from here:
http://download.oracle.com/docs/cd/B19306_01/server.102/b25159/configbp.htm#HABPT00203
Specifically there is a system event DB_ROLE_CHANGE which helps to
transition a SERVICE between primary/standby database upon switchover or
failover. With proper tnsnames.ora, listing both primary and standby hosts
and service name (not sid or global name) role transition will be _almost_
transparrent to clients.
Trick with DNS change works, but there is a downside to it - DNS cache has
to be cleaned out upon role transition or you have to reduce TTL for A
record which puts an additional load to DNS server(s).
--romas
On 6/9/08, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote:
>
> Folks
>
>
>
> A production Site is looking to Deploy Dataguard(with RAC) as its DR
> Solution.
>
>
>
> Can Hostname / IP Address of DR machines be kept same as production? ... is
> it an advisable practice?
>
>
>
> Other Best Practices pls?
>
>
>
> Cheers & Thanks V much
>
>
>
>
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
> for the use of the addressee(s). If you are not the intended recipient, please
> notify the sender by e-mail and delete the original message. Further, you are
> not
> to copy, disclose, or distribute this e-mail or its contents to any other
> person and
> any such actions are unlawful. This e-mail may contain viruses. Infosys has
> taken
> every reasonable precaution to minimize this risk, but is not liable for any
> damage
> you may sustain as a result of any virus in this e-mail. You should carry out
> your
> own virus checks before opening the e-mail or attachment. Infosys reserves the
> right to monitor and review the content of all messages sent to or from this
> e-mail
> address. Messages sent to or from this e-mail address may be stored on the
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>
>
Other related posts:
