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).
Received on Mon Jun 09 2003 - 09:21:55 CDT