Skip to Main Content
  • Questions
  • migrating database among platforms of different endianness

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, sanjiv.

Asked: April 26, 2017 - 6:57 am UTC

Last updated: April 26, 2017 - 8:07 am UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Greetings,
I am trying to migrate a whole database from windows to aix based platform. The endianess of these OS are small and big consecutively. I have done just the tablespace migration using datapump utility and rman conversion of datafiles.
My question is,
1> can i use the rman backup of windows and use the backup for restore and recover in aix as with the platforms having same endianness?
2> is only the tablespace migration of users and examples tablespace possible?
3> what would be the best procedure for me to follow?
Note:: The newly created database should have same dbid and dbname as of source database.

Regards,
Sanjiv Ranjit

and Connor said...

I went through a similar process.

My blog notes on it here

https://connormcdonald.wordpress.com/2015/06/06/cross-platform-database-migration/

but the full details can be found by searching MOS for cross-platform database upgrade. There's a series of notes and detailed walkthroughs on the process



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.