Printable View
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,
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.
RMan works and can use either transport tablespace or convert datafile option
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.
May I ask how big is the database?
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.Quote:
Originally Posted by matthew00
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.
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?
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.Quote:
Originally Posted by giteshtrivedi
Oracle stops support on HP Itanium.
So what? that is not the point, the point is your statement about Intel processors.Quote:
Originally Posted by giteshtrivedi
As per my thinking, It is not good idea to switch sparc to intel without testing for production, we cannot take any example to compare with our existing production database. All time situation would not same for anything. If you are getting good performance in intel, it doesn't mean I would get same kind of performance. Without testing we cannot judge this thing. While we are going to migrate to HP itantiam then we should need to consider future upgrade of database too because there is no guarantee for not hitting any bug.
I assumed testing was a given no matter the technology involved - not only when the word "intel" is in the mix :rolleyes: