Re: switch DG to 64bit with no downtime?
Date: Mon, 26 Mar 2012 09:26:02 -0700
I was hoping there might be some kind of unconventional process similar to doing a rolling upgrade with a logical that would allow all of the 64bit conversion steps to be run on the standby before switchover. However, based on a few offline replies, I'm assuming there is no such pure-DG option; thus my modified question is –
Does anyone have any suggestions of how convert from 32bit to 64 with no more downtime than the usual switchover blip (including ideas that involve extra servers or 3rd party tools)?
As it is an OLTP system, were I to attempt an imp/exp to a 3rd box, by the time it was imported and the 3rd db was converted, the data loss would be far too great…I was also thinking that perhaps I could set up an additional 64bit db and send over the data via Streams, but as per 418755.1, source and downstream sites must have the same bitness. Nonetheless, I’m hoping that someone has a clever method they used or any ideas of how to make this work (no matter how big or small, all are appreciated!)
On Fri, Mar 23, 2012 at 9:24 AM, kathryn axelrod <kat.axe_at_gmail.com> wrote:
> I opened an SR for this as well but haven't gotten anywhere with it yet :)
> I have a primary and physical standby - both 32bit - and want to
> switch them to 64bit with no downtime.
> It's 126.96.36.199, rhel4.0 and thus supported for a 32primary>64standby
> and vice versa so that shouldn't be an issue [note 413484.1]. But the
> actual part of getting the 32's switched is where i'm stuck..
> In hypothetical land, I start with a 32bit standby and 32bit primary
> and two waiting 64bit servers (with installed oracle homes).
> I add a standby to the configuration that runs off the 64bit home
> (though it's a copy of 32bit db data, so it's not fully 64bit yet)..
> Then, come switchover point [note 414043.1], i'd have to:
> shutdown primary
> startup upgrade the standby ..run utlirp ... shutdown/startup
> properly..run utlrp..
> But - as above - in order to convert the db to 64bit, i have to
> 'startup upgrade'/run utlirp - which is in essence downtime. Is there
> any way to fully convert the standby *before* switchover such that the
> only downtime is the blip of switchover?? Or any other way that
> wouldn't involve downtime?
> Thank you!