Re: windows to linux...

From: Mladen Gogala <>
Date: Fri, 2 Dec 2016 21:26:26 -0500
Message-ID: <>

On 12/02/2016 03:15 PM, Andrew Kerber wrote:
> Ok. I have been trying to track down the best way to migrate from
> windows to linux. From reading what I can find on the metalink, it
> appears that I cannot just do an rman restore from windows to linux,
> but I can do an active database duplication, is that correct? It
> doesnt really make sense to me that I can do one but not the other.
> This is to ideally, but if necessary I can go
> to
> --
> Andrew W. Kerber
> 'If at first you dont succeed, dont take up skydiving.'

Well, duplicate between platforms is always a problematic issue, but my understanding of the document
Doc ID 1508375.1 is that it is possible. However, for duplicate to work, the versions must be the same. What you really, really want is to do transportable tablespace migration between 11G on Windows and 12c on Linux. The outline of the process is as follows:

  • Create a 12c database on Linux
  • Check all data tablespaces on the original database for being able to transport. You may have to drop materialized views, in order to do that. Materialized views are unexpected hurdle when doing TTS.
  • Take the TTS export, make the tablespaces read only and copy them to Linux. If you can use SAN snapshot, that would be ideal.
  • Run RMAN convert on the copied data files and plug them into your 12c database. All the data is there, but you have avoided the costly upgrade.
  • Re-create MVIEWS that you may have been forced to drop.

That is a rough outline of my favourite procedure. However, I have recently ran into a hurdle with TDE that I am still trying to solve. It looks like the only solutions left are GG and exp/imp.

Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

Received on Sat Dec 03 2016 - 03:26:26 CET

Original text of this message