| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Migrating 8.1.7 database from one server to another
Content-Type: text/plain; charset="US-ASCII"
This is a trial run to determine these exact issues, for an eventual
migration so we are effectively emulating this as a trial run could be we
will need a different approach like drive the export on a tape to the
other location.
Old server isn't the fastest animal around and that is all the bandwidth we have, so leaving that aside which is the best way for speed create sqlloader files for the move and transport those for loading
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. Jared Still <jkstill_at_cybcon.com> Sent by: oracle-l-bounce_at_freelists.org 19/02/2004 01:43 PM Please respond to oracle-l_at_freelists.org To Oracle-L Freelists <oracle-l_at_freelists.org> cc Subject Re: Migrating 8.1.7 database from one server to another 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:Received on Thu Feb 19 2004 - 00:37:57 CST
> 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 ----------------------------------------------------------------- -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. 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. -- Binary/unsupported file stripped by Ecartis -- -- Err : No filename to use for decode, file stripped. -- Type: image/jpeg ---------------------------------------------------------------- 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 -----------------------------------------------------------------
 |
 |