RE: Moving then migrating database

        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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

    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.


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l