RE: Re: dataguard and operators

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 22 Sep 2015 12:28:26 -0400
Message-ID: <071d01d0f553$b5c23a00$2146ae00$_at_rsiz.com>

An essential piece of all this is that switchovers are done frequently enough under routine conditions that there is an acceptably high likelihood of success of the result meaning the end-to-end user experience remains acceptable. You certainly don’t want to be doing a switchover under urgent conditions that is not well practiced under routine conditions.  

Thus, whatever documents exist, each of these operators should do this as training under routine conditions under the watchful eyes of folks who know what they are doing. This also implies that doing this routinely should be well practiced enough to not pose a risk. Only under these conditions is it reasonable to think an operator has a high chance of seamless success from end-to-end even if the database part of the switchover works just fine.  

While he has left the IT field, you might find literature both archived on oracle-l and elsewhere that may be dated in technical details but LOGICALLY COMPLETE if you search for the writings of Carel-Jan Engel on this subject.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ingrid Voigt Sent: Tuesday, September 22, 2015 9:14 AM To: contact_at_soocs.de
Cc: ORACLE-L; howard.latham_at_gmail.com Subject: Aw: Re: dataguard and operators  

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

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

 

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



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

Received on Tue Sep 22 2015 - 18:28:26 CEST