Re: Dataguard switchover

  • From: Jack van Zanen <jack@xxxxxxxxxxxx>
  • To: Howard Latham <howard.latham@xxxxxxxxx>
  • Date: Fri, 3 Apr 2009 19:08:55 +1100

OMG a DBA that takes holidays :-)

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@xxxxxxxxx>

> 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@xxxxxxxxxxxx>
>
>> 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@xxxxxxxxx>
>>
>>> 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

Other related posts: