| 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
Well, a 1G link is about 1024 times better.
I would discard the db link idea, as it would require quite a bit of extra coding for error checking, as opposed to sqlldr and imp/exp which can catch and log errors for you.
You may want to explore multiple parallel exports, along with multiple parallel imports.
This shouldn't be terribly difficult to setup.
The sqlldr route would work also, though longs/lobs would complicate that. The export/import route is probably simpler, though loading the data is not nearly as fast.
Which you choose may be determined by time constraints.
If only a few tables have long/lob columns, you may investigate a mixture of flat file unloads and exports.
Be sure to load the data without fk constraints or indexes.
For speeding up loads, try digging into the archives at fatcity.com. Kirti Deshpande had an excellent checklist of parameters and techniques used to speed up imports.
It's been in the last couple years.
HTH Jared
On Thu, 2004-02-19 at 02:13, Peter.McLarty_at_mincom.com wrote:
> Content-Type: text/plain; charset="US-ASCII"
> I have since found out the guy who originally quoted me about the link
> specs got his numbers wrong so life will be better, we actually have a 1GB
> Ethernet on a dedicated fibre so bandwidth shouldn't be an issue.
>
> Thanks for the suggestions
>
>
> 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.
>
>
>
>
>
> Connor McDonald <hamcdc_at_yahoo.co.uk>
> Sent by: oracle-l-bounce_at_freelists.org
> 19/02/2004 05:29 PM
> Please respond to
> oracle-l_at_freelists.org
>
>
> To
> oracle-l_at_freelists.org
> cc
>
> Subject
> Re: Migrating 8.1.7 database from one server to another
>
>
>
>
>
>
> Whatever method you go do, that 1Mb thingy in the middle might an issue
> :-)
>
> I'd have a play with each of the options (sqlldr, export) and see which
> files come out best with
> maximal compression. If either alternative comes out with a compressed
> file that still won't
> travel nicely across the link...then its carrier pigeon time with a little
> tape strapped to its
> wing.
>
> Cheers
> Connor
>
> --- 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.
> >
> >
> >
> > --
> > 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
> > -----------------------------------------------------------------
>
> =====
> Connor McDonald
> Co-author: "Mastering Oracle PL/SQL - Practical Solutions" - available now
> web: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: connor_mcdonald_at_yahoo.com
>
> "GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
> and...he will sit in a boat and drink beer all day"
>
>
>
>
>
> ___________________________________________________________
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
>
-- 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 Thu Feb 19 2004 - 09:26:47 CST
 |
 |