RE: Moving then migrating database
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: "sbecker6925@xxxxxxxxx" <sbecker6925@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 Jun 2012 14:57:04 +0000
Sandra,
Was many moons ago that I worked on a database moving from HP-UX/Oracle
9.2 to AIX/Oracle 10.2 and it was in the 1+tb range. My SA at the time came up
with bonding a few multiport network cards together and using a dedicated 1GB
switch. The datafile move took something like 3 hours using multiple OS
process sessions to move them.
Richard Goulet
Senior Oracle DBA/NA TEAM Lead
PAREXEL International
T 978.495.4127
This communication, including any attachments, is intended only for the person
or entity to which it is addressed and may contain confidential material. Any
review, retransmission, distribution or other use of this information by
persons or entities other than the intended recipient is prohibited. If you
received this in error, please destroy any copies, contact the sender and
delete the material from any computer. Thank you.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sandra Becker
Sent: Wednesday, June 06, 2012 10:15 AM
To: oracle-l
Subject: Moving then migrating database
Currently:
OS: SLES10
Oracle: 10.2.0.5
Moving to:
OS: SLES11
Oracle: 11.2.0.2 (the latest version for zLinux when we began
migrating)
We purchased a new IBM mainframe and faster storage. I now have to move all my
databases to the new VMs and storage and upgrade them to 11gR2. I have already
moved a small production database (50G) without any problems.
I now have to move the next one which is 850G. The problem is copying the
datafiles to the new storage before the upgrade--taking too much time. I then
need to move the next one that is 1.5T. Again, just copying the datafiles will
require more downtime than my current window. My SAs have not come up with any
method for moving the files faster. I know there are tools out there, but we
don't seem to have any. I see my options as telling my boss I need a bigger
window or come up with a better method to move the database before I begin the
upgrade.
Question: Will the following work?
1. Using last level 0 backup of the database, restore it to the new
VM/storage a few days before the actual migration date.
2. Using the incremental backups taken daily, run the restores on the
new VM/storage.
3. On the migration date:
- shutdown the database
- run a final incremental backup
- restore the final incremental to the new VM/storage
- upgrade the database to 11g
I do have a sandbox database I can practice with to get timings, script
everything, document to the nth degree, etc. I just don't want to go down a
rat hole if this isn't at all feasible.
Thank you for your input.
--
Sandy
Transzap, Inc.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
