Re: Cross platform migration from 10.2.0.4 to 11gR2

From: John Thompson <jhthomp_at_gmail.com>
Date: Wed, 7 Jul 2010 10:58:00 -0500
Message-ID: <AANLkTikGxbfvxnpk3My3N1gX0Nq5uU7_sSgxXr_LCIg0_at_mail.gmail.com>

We faced almost the exact dilema but had a shorter downtime window of 6 hrs. Because of that, we had to use streams. Using this method, downtime was less than 30 mins. during the switchover.

On Thu, Jul 1, 2010 at 2:47 PM, Jeff Thomas <dbmangler_at_gmail.com> wrote:

> List -
>
> We are in the process of planning a migration of all RAC databases from
> 10.2.0.4 on Solaris SPARC 64-bit to RHEL x86-64 running 11gR2.
>
> Obviously we have an endianess difference which constrains the methods that
> can be used to perform the migration. Furthermore,
> it will be an ASM to ASM migration, which may take the cross-platform
> transportable tablespace feature out of play as my understanding
> is that we would have to use something like DBMS_FILE_TRANSFER over a
> database link to move the datafiles and I'm skeptical
> that we'd get the performance required to meet our (still undefined) SLAs
> (but we'll test this of course.)
>
> So it is starting to look as though data pump is about the only reasonable
> option that we have. Am I wrong?
>
> I'm not sufficiently familiar with say Oracle Streams or Goldengate to
> understand whether these are viable alternatives.
>
> I would appreciate any comments from someone who's been through a similar
> implementation.
>
> Best,
> Jeff
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 07 2010 - 10:58:00 CDT