Re: Moving then migrating database.
From: David Robillard <david.robillard_at_gmail.com>
Date: Thu, 7 Jun 2012 19:59:57 -0400
Message-ID: <CADH15GinbfLuuZcK5=BL9PHkJnUGHV3sEhTCEwbmLZa7anMX2w_at_mail.gmail.com>
Hello Sandra,
Date: Thu, 7 Jun 2012 19:59:57 -0400
Message-ID: <CADH15GinbfLuuZcK5=BL9PHkJnUGHV3sEhTCEwbmLZa7anMX2w_at_mail.gmail.com>
Hello Sandra,
> 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.
According to documents 1166564.1 and 77523.1 :
"Oracle transportable tablespaces are the fastest way for moving large volumes of data between two Oracle databases".
Since this is one of your goals, I'd suggest you use that feature.
HTH, DA+
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 07 2012 - 18:59:57 CDT