{Disarmed} Role transition 2007-10-01 - By Senthil Subramanian
Back
Hi Carel-Jan,
Thanks for your valuable input on this.
I did try switching roles on a small 9i test database back in 2002, but
never really implemented in a real production environment.
We have a sound DR solution but never got a chance to test and implement the
role transition.
Now, we have a one-off requirement to switch roles between primary and the
physical standby for couple of days.
Anyway, I will test it and will report back the progress/result.
Thanks,
Senthil.
On 10/1/07, Carel-Jan Engel <careljan@(protected)> wrote:
>
> Hi Senthil,
>
> Role transition is working very well, generally. I've done and seen this
> dozens of times at various sites, varying from Windows, Solaris, Linux to AIX
using all Oracle versions between
> 8.1.7 and 10.2.
>
> The key point is, as you figured already, to test. However, I'd strongly
> advise you to test this on a regular basis, say once per month - once per
> quarter, and not just now because you are going to use it. You really do
> not want to be in a situation where you have to switch or fail over, and
> never have tested it. I've seen a site with a multi million dollar DR
> 'solution', where the dmgmt didn't want to venture a failover during what
> appeared to be a 36 hour outage, because they weren't sure whether they
> would be able to fail back. Of course they never wanted to found a full
> scale test, as requested by the SA/DBA staff. I see other sites where
> switch-overs and failovers are practiced so many time that a real disaster
> is a no-brainer. They faiilover in 5-10 minutes, (after verifying the STB
> site is OK) before even starting to solve the problem on the primary site,
> You wouldn't want an airplane captain to have studying the emergency plans
> when the emergency occurs, wouldn't you. That's why they practice this in
> simulators. Do the same with your DR environment, otherwise it is useless
> and your company might be crashed before you have finished reading the
> manuals.........
>
> Best regards,
>
> Carel-Jan Engel
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
>
> On Sun, 2007-09-30 at 19:59 -0400, Senthil Subramanian wrote:
>
> Hi All,
>
> I would like to know if anyone has tried the role transition between
> primary and the physical standby in a real production environment.
> We have a situation to switch the roles for couple of days.
> The database size is about one terabyte, version 10.2.0.3 64-bit on
> Solaris 8.
> I will be setting up a test bed this coming week.
> Any comments, advices, and suggestions are most welcome.
>
> Regards,
>
> Senthil.
>
>
>
Hi Carel-Jan,<br><br>Thanks for your valuable input on this.<br>I did try
switching roles on a small 9i test database back in 2002, but never really
implemented in a real production environment.<br>We have a sound DR solution
but never got a chance to test and implement the role transition.
<br>Now, we have a one-off requirement to switch roles between primary and the
physical standby for couple of days.<br>Anyway, I will test it and will report
back the progress/result.<br><br>Thanks,<br><br>Senthil.<br><br>
<br><div><span class="gmail_quote">On 10/1/07, <b class="gmail_sendername"
>Carel-Jan Engel</b> <<a href="mailto:careljan@(protected)">careljan@(protected)
.eu</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
Hi Senthil,<br>
<br>
Role transition is working very well, generally. I've done and seen this
dozens of times at various sites, varying from Windows, Solaris, Linux<font
color="#000000"> to </font> AIX using all Oracle versions <font color="
#000000">
between 8.1.7</font> <font color="#000000">and</font> 10.2.<br>
<br>
The key point is, as you figured already, to test. However, I'd stron<font
color="#000000">g</font>ly advise you to test this on a regular basis, say once
per month - once per quarter<font color="#000000">, and not just now because
you are going to use it.
</font>You really do not want to be in a situation where you have to switch or
fail over, and never have tested it. I'v<font color="#000000">e</font> seen
a site with a multi million dollar DR 'solution', where the
<font color="#000000">d</font>mgmt didn't want to venture a failover during
what appeared to be a 36 hour outage, because they weren't sure whether
they would be able to fail back. <font color="#000000">Of course they never
wanted to found a full scale test, as requested by the SA/DBA staff.
</font>I see other sites where switch-overs and failovers are practiced so many
time that a real disaster is a no-brainer. They faiilover in 5-10 minutes,
(after verifying the STB site is OK) before even starting to solve the problem
on the primary site, You wouldn't want an airplane captain to have studying
the emergency plans when the emergency occurs, wouldn't you. That's why
they practice this in simulators. Do the same with your DR environment,
otherwise it is useless and your company might be crashed before you have
finished reading the manuals.........
<br>
<br>
<table cellpadding="0" cellspacing="0" width="100%">
<tbody><tr>
<td>
Best regards,<br>
<br>
Carel-Jan Engel<br>
<br>
===<br>
If you think education is expensive, try ignorance. (Derek Bok)<br>
===
</td>
</tr>
</tbody></table>
<br>
<br>
<br>
On Sun, 2007-09-30 at 19:59 -0400, Senthil Subramanian wrote:<br>
<blockquote type="CITE">
<font color="#000000">Hi All,</font><br>
<br>
<font color="#000000">I would like to know if anyone has tried the role
transition between primary and the physical standby in a real production
environment.</font><br>
<font color="#000000">We have a situation to switch the roles for couple of
days.</font><br>
<font color="#000000">The database size is about one terabyte, version <a
href="http://10.2.0.3" target="_blank" onclick="return top.js.OpenExtLink
(window,event,this)">10.2.0.3</a> 64-bit on Solaris 8.</font><br>
<font color="#000000">I will be setting up a test bed this coming week.<
/font><br>
<font color="#000000">Any comments, advices, and suggestions are most
welcome.</font><br>
<br>
<font color="#000000">Regards,</font><br>
<br>
<font color="#000000">Senthil.</font><br>
</blockquote>
<br>
</div>
</blockquote></div><br>
|
|
