Oracle-L: RE: Best way to move db from AIX to Solaris

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 28 Mar 2002 07:33:19 -0800
Message-ID: <F001.00435EC4.20020328073319@fatcity.com>

Helmut - There are a couple of methods that might suit your needs:

Because these platforms are not compatible at the binary level, you can't clone the database by copying datafiles.
Export/import will work. Look for FAQs on the Internet for tips on maximizing your speed. If these machines have multiple CPUs, you may want to run multiple export and import sessions. Be sure to turn archiving off on the target machine.
Use a database link to send data over SQL*Net. I have found this to be faster than Import because you are going database to database. Look at the SQL*Net COPY command.

You didn't say how long you can have the database down, but I would recommend that you test the various methods until you are confident you have the method that works the best for you and can complete the task within the available time. And tell the users it will be down longer than you think it will. Users don't get angry if you finish early. Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, March 28, 2002 4:03 AM
To: Multiple recipients of list ORACLE-L

Hi!

We want to migrate an Oracle db (approx. 50 GB) from AIX to Sun Solaris. What would be the best way to achieve this? Export/Import I guess, right?

This is 8.1.7 on Sun Solaris/AIX.

Thanks,
Helmut

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 28 2002 - 09:33:19 CST