|| at Aug 28, 2012 at 1:41 am
From: Steve Harville <email@example.com
To: Sanjay Mishra <firstname.lastname@example.org
Cc: oracle-l <email@example.com
Sent: Monday, August 27, 2012 1:22 PM
Subject: Re: Database upgrade for big database
Here is the command I used on the new server:
nohup impdp system/secret NETWORK_LINK=olddb FULL=y PARALLEL% &
Then you can run this to see which parallel process is importing which
Impdp system attach
Import> parallel0 << this will increase the parallel processes if you want
I had created all the datafiles in the new database and created a db link
named olddb beforehand. The servers were on the same local area network and
the network was the bottleneck.
On Fri, Aug 24, 2012 at 7:55 PM, Sanjay Mishra wrote:
Can you please share some detail on the option used in the impdp ?
Is Parallel allowed for this option to run multiple slaves ?
*From:* Steve Harville <firstname.lastname@example.org
*Sent:* Friday, August 24, 2012 2:46 PM
*Subject:* Re: Database upgrade for big database
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 5 hours. There
was no downtime but we kept the users off the system while this was
On Fri, Aug 24, 2012 at 2:33 PM, Sanjay Mishra wrote:
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.
I had few database running in 10g and has to be moved to new server with
11g. So looking for some suggestion and any URl/Metalink Doc for reference.
One of them can be
1. Create standby server for 10g on new server
2. Install Oracle 11g with all required Paches
3. stop the primary and activate the Standby server
4. Upgrade the Standby server with 11g Software already installed
This process will save in installing Oracle 11g and performing any
datapump export/import and save big downtime to few hours only while
upgrading the environment.
Any more suggestions or reference will be helpful