Home » RDBMS Server » Server Administration » Cross Platform Database (SUN TO AIX)
Cross Platform Database [message #603486] Mon, 16 December 2013 23:49 Go to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
Hi Experts

I am doing a POC for cross platform Database migration from Solarix to AIX.
As per Oracle documentations its enough just to convert the datafiles that have system and undo segments.

But today on a very less busy database even without converting the system and undo i was able to bring up the database on AIX .

Of course Cold backup was used.

Do you think this should be a supported approach?
Re: Cross Platform Database [message #603488 is a reply to message #603486] Mon, 16 December 2013 23:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Do you think this should be a supported approach?
why are you asking here and not submitting a Service Request to MOS for official response?
Re: Cross Platform Database [message #603500 is a reply to message #603486] Tue, 17 December 2013 00:51 Go to previous messageGo to next message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
I believe both systems (solaris as well as aix) are "big endians", in that respect you should see no problems.

If you could bring up the database I guess it works.

Have a look at oracle support note : ID 433918.1 (What Is The Best Practice If You Want To Migrate Oracle Database To 10g Release To A Different Operating System? (Doc ID 433918.1))
Re: Cross Platform Database [message #603503 is a reply to message #603500] Tue, 17 December 2013 01:14 Go to previous messageGo to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
Asking MOS.Most likely they will point me out the extract from documentation guide.....
Re: Cross Platform Database [message #603505 is a reply to message #603503] Tue, 17 December 2013 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Maybe but you will not know until you ask and anyway you'll have your answer.

Re: Cross Platform Database [message #603570 is a reply to message #603486] Tue, 17 December 2013 08:20 Go to previous messageGo to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
They did point the extract out of the documentation guide .It says to save time we can only do conversion of datafiles that have undo segments

Cross-Platform Database Migration (across same endian) using RMAN Transportable Database (Doc ID 1401921.1)

but are not able to tell me why is the conversion of system and undo datafiles important?

If the OS is of the same endian,will we still require to convert the same?I ask this because without converting the same i could bring up the database on the target platform.

Re: Cross Platform Database [message #603571 is a reply to message #603570] Tue, 17 December 2013 08:35 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Who can know and tell what Oracle does, in addition to endian conversion, when it converts?
Whatever we can tell you, will you take the risk to not do what Oracle told you to do and possibly screw your database?
In the end, does the answer to your question matter in any way?

Previous Topic: XMLDB
Next Topic: oracle upgrade from 9i to 11g fails with SP2-0714: invalid combination of STARTUP options
Goto Forum:
  


Current Time: Thu Nov 28 23:35:18 CST 2024