migration plan from Sun to Linux

[matthew00]

I don't think this will work but want to make sure.

1. can we have RMAN backup on Solaris and restore to Linux?
2. if we can't clone the database between the two different OS, what is the best way to migration the data beside using EMPDP/IMPDP for the huge database?

Thanks,

[gandolf989]

Have you looked at the transportable table space option?

http://docs.oracle.com/cd/B19306_01/...91/dbxptrn.htm

I haven't tried it myself, but it seems like it should work. You may want to migrate to the same version, then upgrade to a new version of Oracle, if you plan on upgrading.

[opchandani]

RMan works and can use either transport tablespace or convert datafile option

[ebrian]

It really depends on what you mean by Sun, the version of Linux and the version of Oracle. You could potentially use Data Guard or Transport Database.

[PAVB]

May I ask how big is the database?

[matthew00]

700g and they go from Solaris 5.9 to the latest Rh

[PAVB]

700g and they go from Solaris 5.9 to the latest Rh

If you can afford a downtime I would pre-create database and migrate it via expdp/impdp. I've done a 400 Gigs one, expdp/impdp phase in around 8 hours end-to-end.

I would suggest to go for a test run before the actual migration, this way test run would allow for finetuning scripts, have a clear idea of elapsed time and also allow users to validate, test connectivity and functionality.

[giteshtrivedi]

Hi,

expdp/impdp is best solution for platform changing. But I don't understand why are you going to switch from sparc to intel platform for large database?

[PAVB]

...I don't understand why are you going to switch from sparc to intel platform for large database?

Why not? Don't you know about the Intel Itanium based HP Superdome? I have worked supporting a very critical 80,000 execs per second database on such platform.

[giteshtrivedi]

Oracle stops support on HP Itanium.