Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MIgrating a huge database from SPARC to Solaris x86

Orna WeismanJun 28 2011 — edited Jun 28 2011
Hi

I am looking for an efficient way to migrate a 12TB very active database from SPARC to Solaris x86.
the version is 10.2.0.4.

The only way I came up with is using transportable tablespace together with Veritas fcdsconv utility:

1. Put the source database in read only mode
2. full export of metadata
3. copy all application datafiles into a new mount point using RMAN convert datafile utility ( in preparation of moving to a different OS with different indianess )
4. import the mount point to the x86 server and mount it there ( using Veritas fcdsconv )
5. Create a new database on the x86 server
6. Plug in the transported datafiles into the new databse
7. import the full export previously taken.

The problem is that the convert RMAN utility is basically creating a new copy of the datafiles and doing it on 12TB of data is a LOT of downtime.

I was wondering if anyone has any experience with that kind of migration ( to a different OS with different indianess ) that he/she can share

thanks
Orna
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2011
Added on Jun 28 2011
20 comments
3,374 views