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