Re: dataguard and operators

From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 22 Sep 2015 15:09:04 +0200 (CEST)
Message-ID: <615873581.25885.1442927344824.JavaMail.open-xchange_at_app01.ox.hosteurope.de>

Hi Howard,
i can not think of any valid reason why an operator could not type "switchover to <STDBY>" in DGMGRL. TAF (or FAN) and the corresponding services should be configured correctly anyway so that the application can switch over seamless (disregarding SELECT and DML FAILOVER). I can only think of one rare DG scenario where DGMGRL is not applicable, but this restriction has been lifted with 12c as well.

However if you are already that far - you should ask yourself: Why bother a third person at all? In case of a failure you can also use observer to handle all of this logic automatically.

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> Howard Latham <howard.latham_at_gmail.com> hat am 22. September 2015 um 12:10 geschrieben:
>
> Oracle 11 Redhat 4E
>
> My boss wants scripts /instructions so 'any fool ' can do a dataguard
> switchover. I think that's hard if not impossible as you can't
> predict what is going to happen How many of you have successfully
> handed this over to an operator? And if you have can I see example
> scripts please?
>
> --
> Howard A. Latham

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

Received on Tue Sep 22 2015 - 15:09:04 CEST