{Disarmed} Role transition 2007-10-01 - By Carel-Jan Engel
Back
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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8 (See http://UTF-8.ora-code.com)">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.6.1">
</HEAD>
<BODY>
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 CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<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>
</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">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>
</BODY>
</HTML>
|
|
