Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: {Disarmed} Role transition

Re: {Disarmed} Role transition

From: Senthil Subramanian <>
Date: Mon, 1 Oct 2007 21:55:53 -0400
Message-ID: <>

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.



On 10/1/07, Carel-Jan Engel <> 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 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.

Received on Mon Oct 01 2007 - 20:55:53 CDT

Original text of this message