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).
