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

From: <Jared.Still_at_radisys.com>
Date: Mon, 09 Jun 2003 12:13:45 -0700
Message-ID: <F001.005ADD70.20030609114520@fatcity.com>

This is *exactly* what I would like to do on our SAP systems when we upgrade, since this is the best way to move to LMT's.

Unfortunately for me and a lot of other folks, Windoze don't do that. :(

You can't imagine just how much I wish we were on Solaris.

Jared

Kirtikumar Deshpande <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
 06/09/2003 07:59 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc: 
        Subject:        RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over 

dblink or ..

You may want to review an article, "Cross Platform Migration of a Large Production Database", in
the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG). The author details the procedure he followed to migrtate a 300GB production database from HP-UX to
IBM AIX.

• Kirti
  • "Goulet, Dick" <[EMAIL PROTECTED]> 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]
    >
    

    ---

Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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: 
  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 - 14:13:45 CDT