Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or

RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Mon, 09 Jun 2003 07:48:28 -0700
Message-ID: <F001.005AD8E3.20030609072942@fatcity.com>

  1. Join the 10i beta program
  2. Convert your 9.2 datafiles using the cross-platform transportable tablespaces feature of a dummy 10i instance.

;-)

Or...

Back when one of our system swas at around 200M, we had a C program that dumped table data in parallel by rowid ranges, wrote the streams in SQL*Loader native format to named pipes that were being dd'd with large block sizes across a fast network, to several SQL*Loader processes on the other side using direct/unrecoverable.

We ran several of these at a time. As soon as a table would finish we would kick off the index creation in parallel/unrecoverable mode. The goal was to get both the source and target hosts as close to 100% utilization as possible.

This was Oracle 8.0.5, migrating Compaq Tru64 (DEC OSF to HP-UX 11 64-bit.

The migration took 6 hours. It shouldn't have even taken that long, but we were clumsy in a few ways.

There's a lot involved in a migration. Lots of dependencies and details to think about. I recommend repeated practice runs on test equipment before trying the real thing. There's a lot of blood to be squeezed out of this stone to get the time down and reliability up.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 9 Jun 2003, Goulet, Dick wrote:


> Exp/imp of a 200GB database is possible, but I'd think the time required would be
> the long pole in the tent. I'd say your looking at at least a 4 day weekend at best
> and only if you used direct mode. Someone has hinted that you can simply move the
> datafiles from one box to the other. Well I'd not loose the original system before
> you prove that. My experience with database file from Solaris to HP-UX has been a
> 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x).
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Saturday, June 07, 2003 7:29 AM
> To: Multiple recipients of list ORACLE-L
> ..
>
>
> Hi all:
>
> We are considering migration of an Oracle eBusiness Suite 11.5.8 from
> HP-UX 11.0 to Solaris9.
>
> I'd like to know if anyone has done this and how daunting the task is.
>
> Are there any 3rd Party tools which can help out?
>
> Coming to the conventional approaches:
>
> 1. What do you think of Export/Import of a 200 GB database?
> 1a. How much time will it take?
> 1b. Any strategies for cutting that down?
>
> 2. How does CTAS over dblink compare to Export/Import?
>
> 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to
> Oracle datafiles on Solaris 9. If so we would just need to recreate the
> control files on the target database and we are done.
>
> Any suggestions, pointers, words of wisdom are greatly appreciated...
>
> Thanks & Regards,
> Sashi
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sashidhar Kondareddy
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Goulet, Dick
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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 Mon Jun 09 2003 - 09:48:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US