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: Migrating 8.1.7 database from one server to another

Re: Migrating 8.1.7 database from one server to another

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 18 Feb 2004 21:43:57 -0800
Message-Id: <1077169436.11042.46.camel@poirot>


Peter,

I think more information is needed to make any suggestion.

For instance, you are limited by a 1m WAN link.

What's not mentioned is the time frame for the move.

Is this a production system?

Is there a short time limit on the downtime allowed for switching to the new system?

40 Gig over a 1 Meg link will take 91 hours at optimal efficiency, so count on it taking twice that long, which is about 8 days.

You can see where timing comes into play.

Will it be the same version of Oracle?

Are there any LONG columns in the data?

You need to duplicate this environment to come up with an optimal solution, as it will take some testing.

Jared

On Wed, 2004-02-18 at 20:50, Peter.McLarty_at_mincom.com wrote:
> Content-Type: text/plain; charset="US-ASCII"
> Hi
>
> I have a database on one system AIX 4.3 and moving to a Solaris 9 server
> databases are separated by a 1Mb WAN link
>
> Database is physically around 40GB don't know what is the actual data but
> would be pretty close to the 40GB
>
> What would be the best way to migrate this data
>
> Options
> sqlloader
> export import
> db link
>
>
> All ideas taken into consideration
>
> Cheers
>
>
>
> --
> =================================================
> Peter McLarty E-mail: Peter.Mclarty_at_mincom.com
> Technical Consultant WWW: http://www.mincom.com
> APAC Technical Services Phone: +61 (0)7 3303 3461
> Brisbane, Australia Mobile: +61 (0)402 094 238
> Facsimile: +61 (0)7 3303 3048
> =================================================
> "Whatever you can do or dream you can, begin it.
> Boldness has genius, power and magic in it, begin it now."
> Goethe 1749 -1832
> =================================================
> Mincom "The People, The Experience, The Vision"
>
> =================================================
>
> This transmission is for the intended addressee only and is confidential
> information. If you have received this transmission in error, please
> delete it and notify the sender. The contents of this e-mail are the
> opinion of the writer only and are not endorsed by the Mincom Group of
> companies unless expressly stated otherwise.
>
>



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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Feb 18 2004 - 23:43:57 CST

Original text of this message

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