Aw: Re: dataguard and operators
From: Ingrid Voigt <giantpanda_at_gmx.net>
Date: Tue, 22 Sep 2015 15:13:48 +0200
Message-ID: <trinity-a0e9010a-0249-4690-be01-4c88bf6fb409-1442927628017_at_3capp-gmx-bs71>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 22 2015 - 15:13:48 CEST
Date: Tue, 22 Sep 2015 15:13:48 +0200
Message-ID: <trinity-a0e9010a-0249-4690-be01-4c88bf6fb409-1442927628017_at_3capp-gmx-bs71>
The operator needs SYSDBA for that (still on Oracle 11) - we don't give that out lightly.
Observer: That's an option, yes.
Regards,
Ingrid
Gesendet: Dienstag, 22. September 2015 um 15:09 Uhr
Von: "Stefan Koehler" <contact_at_soocs.de>
An: ORACLE-L <oracle-l_at_freelists.org>, howard.latham_at_gmail.com
Betreff: Re: dataguard and operators
Von: "Stefan Koehler" <contact_at_soocs.de>
An: ORACLE-L <oracle-l_at_freelists.org>, howard.latham_at_gmail.com
Betreff: Re: dataguard and operators
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
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