Re: Dataguard switchover

Still I would not document the switchover proces but create a fool proof script that the operator just needs to run in case of emergencies. Switchover would normally not be an emergency and can most of the time wait till you are back from the crypt though.

Failover is the one that is normally used in emergencies. Again you have lots of trouble and an operator has to fix it???

I'd talk to your boss and have a remote DBA company on retainer for just these sort of situations.

Brgds

Jack

2009/4/3 Howard Latham <howard.latham_at_gmail.com>

> because I am the only dba and not being from Krypton I sleep get ill and
> take holidays!
>
> 2009/4/3 Jack van Zanen <jack_at_vanzanen.com>
>
>> Answers have been given
>>
>> Begs the question though.....WHY ask a trained monkey to do the
>> switchover. This looks to me like it should be scripted or a DBA task not a
>> manual job for an operator who may make a typo while connected as SYS, and
>> than what?
>>
>>
>> Brgds
>>
>>
>> Jack
>>
>> 2009/4/2 Howard Latham <howard.latham_at_gmail.com>
>>
>>> Has anyone written a guide for a non dba to do a manual dataguard
>>> switchover on Linux Oracle 11g?
>>>
>>> --
>>> Howard A. Latham
>>>
>>>
>>>
>>
>>
>> --
>> Jack van Zanen
>>
>> -------------------------
>> This e-mail and any attachments may contain confidential material for the
>> sole use of the intended recipient. If you are not the intended recipient,
>> please be aware that any disclosure, copying, distribution or use of this
>> e-mail or any attachment is prohibited. If you have received this e-mail in
>> error, please contact the sender and delete all copies.
>> Thank you for your cooperation
>>
>
>
>
> --
> Howard A. Latham
>
>
>

-- 
Jack van Zanen

-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation

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