Re: windows to linux...
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 2 Dec 2016 21:26:26 -0500
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 11.2.0.4 to 12.1.0.2 ideally, but if necessary I can go
11.2.0.4 to 11.2.0.4.
--
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
Other related posts: