Re: Cross platform migration from 10.2.0.4 to 11gR2

  • From: John Thompson <jhthomp@xxxxxxxxx>
  • To: dbmangler@xxxxxxxxx
  • Date: Wed, 7 Jul 2010 10:58:00 -0500

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@xxxxxxxxx> 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
>

Other related posts: