Transporting an Oracle database to another os platform the fastest way

You can use RMAN to transport tablespaces across platforms with different endian formats. You can also use RMAN to transport an entire database to a different platform so long as the two platforms have the same endian format. …

— From “27 Transporting Data Across Platforms” – http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm …

So, in my own words – datafiles (tablespaces) are interchangeable with any operating system having the same endian format. (I don’t know what ‘endian format’ is nor do I care but it’s exmplained here.) …

This is great and enables for exceptionally simple and fast moving of an entire database to another os platform. …

Unfortunately however the oracle documentation does not discuss the scenario that is in the Oracle Metalink document ‘Cross-Platform Database Migration (across same endian) using RMAN Transportable Database’ [ID 1401921.1] where you move your entire database to another platform and performing only a partial (the bare neccesary) rman convert. …

IE;
No need for ‘messing around’ with datapump tablespaces export / import since we want to whole database. …

— hat tip for the Metalink Note is from my esteemed colleague Jeroen Pouwiel – thanks amie. …

Most important statement that I found in this metalink note is; …

It’s default behavior is to perform datafile conversion on all datafiles in the database. However, only datafiles that contain undo data require conversion including all datafiles beloging to SYSTEM tablespace and all UNDO tablespaces.

Below is a complete walktrough of a move (copy) from a database running on a Sun solaris server to a server running AIX doing only a `convert datafile` on the datafiles …

Read more →