Fwd: Database upgrade for big database
From: Steve Harville <steve.harville_at_gmail.com>
Date: Fri, 24 Aug 2012 15:03:07 -0400
Message-ID: <CAGd4=DTY5oTtH9B0hddaMo-1WiGi_djHWzOTQCknitdad+R8+Q_at_mail.gmail.com>
Hi Sanjay, I recently moved a 2TB database from Linux, Oracle 11.1 to AIX, Oracle 11.2 using impdp with network_link and parallel options. The data was imported in about two hours and the indexes took another 7 hours. There was no downtime but we kept the users off the system while this was happening.
Steve Harville
Date: Fri, 24 Aug 2012 15:03:07 -0400
Message-ID: <CAGd4=DTY5oTtH9B0hddaMo-1WiGi_djHWzOTQCknitdad+R8+Q_at_mail.gmail.com>
Hi Sanjay, I recently moved a 2TB database from Linux, Oracle 11.1 to AIX, Oracle 11.2 using impdp with network_link and parallel options. The data was imported in about two hours and the indexes took another 7 hours. There was no downtime but we kept the users off the system while this was happening.
Steve Harville
Can someone share his experience in upgrading some big databases like 1Tb
> or so from 10g to 11g and also moving them to new server.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 24 2012 - 14:03:07 CDT