Re: database migration
Date: Tue, 10 Feb 2009 08:50:35 -0800 (PST)
Message-ID: <587679.79341.qm_at_web54304.mail.re2.yahoo.com>
Thanks for the feedback.� Since we are moving from AIX to Linux,� I can't use transportable tablespaces without doing a convert or RMAN.� So I'm forced to use export/import datapump.�
Michael,
There are a number of documents on metalink regarding using exp/imp with named pipes.�
Haroon
- On Tue, 2/10/09, Howard Latham <howard.latham_at_gmail.com> wrote: From: Howard Latham <howard.latham_at_gmail.com> Subject: Re: database migration To: mfontana_at_enkitec.com Cc: "Milton, Eric" <Eric.Milton_at_ihs.com>, oracle-l_at_freelists.org Date: Tuesday, February 10, 2009, 10:02 AM
I did a migration from NT to Linux The DB was approx 600gig.
I used transportable tablespaces. The physical copy was what slowed me down it took approx 18 hours.
The other problem was test windows. Do yourself a favour and beg borrow or steal a box / disk array you can practice on!.
Howard Latham
2009/2/10 Michael Fontana <mfontana_at_enkitec.com>
Are you talking about using datapump and pipes?
I am not familiar with using pipes with traditional export/import. �If
it's possible, can you please reference an article or manual that details
this method?
Thanks!
-----Original Message-----
From: Milton, Eric [mailto:Eric.Milton_at_ihs.com]
Sent: Monday, February 09, 2009 5:47 PM
To: mfontana_at_enkitec.com; haroon_a_qureshi_at_yahoo.com;
oracle-l_at_freelists.org
Subject: RE: database migration
�In a situation where I did not want to write scripts I used a pipe to
export/import with performance that was exceptional. You should be able to
use many of the standard exp/imp commands. The time on a slow Unix box,
slow, to move 10,000,000 rows in a 26 column table, was about 15 minutes.
One very nice feature is the "tiny" amount of disc space you need.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Michael Fontana
Sent: Monday, February 09, 2009 1:52 PM
To: haroon_a_qureshi_at_yahoo.com; oracle-l_at_freelists.org
Subject: RE: database migration
I would definitely be engaging Oracle support to assist with your
migration, or at least offer suggestions and best practice methodologies
since Oracle applications are involved. �We found this out when doing an
Oracle BI and datawarehouse migration!
There are many differences in patch sets and release levels of Oracle
applications and supporting database between your platforms. �You may also
have to consider what might be running during a phased migration on the
source that could impact timings (IE - you are migration DB3 while DB1 and
DB2 are doing heavy batch processing and they slow it down).
I have heard of some people having success with logical sql-apply
methodologies for migrating databases across platforms, but have no
experience with it.
Hopefully we have started the ball rolling and you'll get some other
valuable responses.
-----Original Message-----
From: Haroon A. Qureshi [mailto:haroon_a_qureshi_at_yahoo.com]
Sent: Monday, February 09, 2009 2:44 PM
To: oracle-l_at_freelists.org; Michael Fontana
Subject: RE: database migration
Thanks Michael. �We are running Oracle Applications 11.5.9 and are moving
to new dell servers with 2 dual core CPUs with 32gb of memory running
Oracle Enterprise linux 4.7. �it is a 10g database (10.2.0.4).
Your initial impression about timing is correct. �we are on an aggressive
schedule and don't have the time to write the scripts and test them out.
however, if we had a ball park idea of what the savings would be, if any,
of using rman vs expdp/impdp, we may be able to justify the extra time
spent on it.
the readonly issue is a big concern, depending on how long it will take to
export the db or use rman to move it over. �we are also planning on moving
to ASM during the migration.
Thanks in advance for your help.
Haroon
- On Mon, 2/9/09, Michael Fontana <mfontana_at_enkitec.com> wrote:
> From: Michael Fontana <mfontana_at_enkitec.com>
> Subject: RE: database migration
> To: haroon_a_qureshi_at_yahoo.com, oracle-l_at_freelists.org
> Date: Monday, February 9, 2009, 2:28 PM
> There are just too many variables to give you a ballpark
> figure. � What is
> the configuration of your current implementation versus
> your target
> hardware? �What version(s) of products are you currently
> running?
>
> My initial impression of your statement about not having
> enough time is
> that you're going to have to test out your scripts and
> methodologies
> regardless of any estimates you might collect from external
> sources. �You
> simply have to include timing these "rehearsals"
> you'll be doing to give
> yourself a fair chance of being able to predict the
> actuals.
>
> Be prepared for some extended downtime - the rman convert
> methodology
> requires that the source tablespaces are in READONLY mode
> during the
> backup process. �If there are any relationships between
> objects within
> them, they'll all have to be in that mode for the
> duration.
>
> This is pretty much the case with expdp/impdp as well,
> although your
> mileage may vary!
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Haroon A. Qureshi
> Sent: Monday, February 09, 2009 2:09 PM
> To: oracle-l_at_freelists.org
> Subject: database migration
>
> Hello,
>
> We are doing a database migration from AIX to Linux. �Our
> database is
> 600gb. �Has anyone used the rman convert database method to
> migrate the
> database? �Do you have any timings you can share,
> especially compared to
> expdp/impdp? �Unfortunately, I don't have the luxury of
> time to try it out
> myself.
>
> Thanks in advance!
> Haroon
> --
> http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- Howard A. Latham -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 10 2009 - 10:50:35 CST