RE: Data Guard

I don't understand the 'ease' of DNS-changing. Why hassling with yet another system (The DNS server) if you can arrange the whole thing locally on your database server? I use the multiple listener thing, there's another method using service-registration: let only the services representing the roles of your database be registered at the listener. With both methods all of the failover stuff can be handled at DBA level: no network guys or SA's needed to change the DNS, no flushing of the DNS cache (or even rebooting?) of potentially tens or hundreds of machines needed. The less people involved, the easier and smoother a failover operation will work.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Fri, 2006-04-07 at 13:07 -0400, oracle-l-bounce_at_freelists.org wrote:

> I have no idea if this will work, but many naïve DNS caching systems cache only the first label - that is, if foo.bar has ip 1.2.3.4, it'll cache the mapping from foo.bar->1.2.3.4 . If, however, foo.bar is a CNAME to bar.baz, and bar.baz has the IP 1.2.3.4, it might only cache the foo.bar->bar.baz, not the IP itself. This allows you to change the IP of bar.baz without worrying about the cache expiry.
>
> Never having worked with either of these programs, I can't say if they'll work, but I've used this trick before on a very large scale.
>
> Thanks,
> Matt
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of JayMiller_at_TDWaterhouse.com
> Sent: Friday, April 07, 2006 11:48 AM
> To: oracle-l_at_freelists.org
> Subject: RE: Data Guard
>
> Just an added note if you go the DNS route (which is what we do).
>
> If you use Websphere or Microsoft Transaction Server (or probably most
> others) as a middle-tier connection manager then it will be necessary to recycle the services after the DNS Name is switched since they "thoughtfully" cache the ip address for you. I remember the first time we did a primary/standby switch after implementing the middle tier connection pooling many years ago. I still wake up screaming some nights :)
>
> Oh, if anyone knows a workaround for that I'd love to hear it.
> Basically all we ever got out of Oracle or IBM was "just recycle the services to clear out the cached ip address". It was supposed to be so easy to just switch the DNS name...
>
>
>
> Jay Miller
>

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