Re: Upgrade 9.2 to 11.2 with minimal downtime

From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Wed, 1 Jun 2011 16:23:56 -0700 (PDT)
Message-ID: <3167b8fc-bf92-4915-8f2b-9e3cd6c1b9d4_at_v10g2000yqn.googlegroups.com>



On 2 jun, 00:52, "phil_herr..._at_yahoo.com.au" <phil_herr..._at_yahoo.com.au> wrote:
> You should consider standby or GoldenGate.
>
> Standby doesn't require spending any money. You copy your prod DB to
> the new site, open it as a standby, copy archived redo from prod and
> apply it. When the standby has caught up with prod and you're ready to
> cut over, you shut down prod and open the standby. The outage for the
> cutover can be extremely short; how short depends on how fast you can
> copy archived redo and apply it. You'll need to spend some time with
> the manuals to work out how to do it, though there are step-by-step
> tutorials on the web that will get you started.
>
> GoldenGate does much the same thing, and I believe that it requires
> far less effort to get working. The downside is that (a) you need to
> pay for it, and (b) it doesn't copy certain things, which means that
> your copy DB might not be exactly the same as your prod. For that
> reason, you'll need to figure out whether you can use it. Again, time
> must be spent with the manuals.
>

I don't think standby is an option here; keep in mind that the OP is not only upgrading but also changing platform. And, like you said, GoldenGate doesn't come free. I agree with John that OP should try to figure out why exp/imp takes that long.

--
Jeroen
Received on Wed Jun 01 2011 - 18:23:56 CDT

Original text of this message