One of the interesting questions I've got during the seminar was related to the possibility to migrate a terabyte database from a little endian machine to a big endian machine, using an ASM diskgroup to transfer the data.
Unfortunately ASM diskgroups are not cross platform enabled. There is no problem to mount the same diskgroup on multiple servers at the same time, provided that the OS system for all the servers is the same. You can also unmount the ASM disks from one server and mount them into another, but still it is required to have the same OS to be able to work with the diskgroup on the new server.
The alternative solution is to use Cross-Platform Transportable Tablespaces (XTTS). There are several possible strategies to accomplish the migration of a terabyte database using XTTS. On this post I'm presenting and example of how this technology is implemented, step by step
« MAA Seminar in Istanbul: Using a Physical Standby For Read/Write Testing and Reporting | Main | How to generate series of AWR reports »
MAA Seminar in Istanbul: using Cross Platform Transportable Tablespaces into ASM
TrackBack
TrackBack URL for this entry:
http://blogs.oracle.com/mte1521/mt-tb.cgi/4296
Search All Blogs
Google Search
About This Entry
This page contains a single entry from the blog posted on December 31, 2007 1:52 AM.
The previous post in this blog was MAA Seminar in Istanbul: Using a Physical Standby For Read/Write Testing and Reporting.
The next post in this blog is How to generate series of AWR reports.
Many more can be found on the main index page or by looking through the archives.
Comments (1)
This is so impressive. Thank you.
Posted by TRT | January 2, 2008 6:26 PM
Posted on January 2, 2008 18:26