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 >