Web Technologies

Oracle database migration limitations across platforms

September 2nd, 2011 at 09:09

I was given the task of  moving a database from Linux to Solaris[tm] OE (64-bit). I have done some research work and found the following methods to do it.

Data Pump:

You can use the Date Pump export and import utilities to migrate an Oracle database between platforms and OS environments, but it can be very slow for large systems. Beside that this utility has a bug in 10G R1 which makes this kind of database migration nearly impossible especially for those databases which are using text/domain indexes with BLOB and CLOB data.

RMAN:

For this particular problem RMAN is handy to move databases between Unix/Linux  and Windows based platforms but it does not work when you try to move databases between Solaris[tm] OE (64-bit) and Windows or Linux(x86). But it is possible to move database between Solaris(x86) and Linux/Unix platforms.

Golden Gate:

Oracle GoldenGate is a comprehensive software package for enabling the replication of data in heterogeneous data environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.

From my research Golden Gate is one of those utilities which makes cross platform migration more reliable and can make life easier for Oracle DBAs. More information about Golden Gate.

Comments are currently not open for this post.