Re: DR implementation using Dataguard ... Best Practices ?

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_at_infosys.com> 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***
>
>

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