RE: database migration
- From: "Michael Fontana" <mfontana@xxxxxxxxxxx>
- To: <haroon_a_qureshi@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Feb 2009 14:51:57 -0600 (CST)
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@xxxxxxxxx]
Sent: Monday, February 09, 2009 2:44 PM
To: oracle-l@xxxxxxxxxxxxx; 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@xxxxxxxxxxx> wrote:
> From: Michael Fontana <mfontana@xxxxxxxxxxx>
> Subject: RE: database migration
> To: haroon_a_qureshi@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Haroon A. Qureshi
> Sent: Monday, February 09, 2009 2:09 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
