Thanks Steve. ________________________________ From: Steve Harville <steve.harville@xxxxxxxxx> To: Sanjay Mishra <smishra_97@xxxxxxxxx> Cc: oracle-l <oracle-l@xxxxxxxxxxxxx> 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 table: Impdp system attach Import> status 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. Steve Harville http://SteveHarville.com On Fri, Aug 24, 2012 at 7:55 PM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote: > Steve > > Can you please share some detail on the option used in the impdp ? > Is Parallel allowed for this option to run multiple slaves ? > > Thanks > > ------------------------------ > *From:* Steve Harville <steve.harville@xxxxxxxxx> > *To:* smishra_97@xxxxxxxxx > *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 > happening. > > Steve Harville > > http://SteveHarville.com > > > On Fri, Aug 24, 2012 at 2:33 PM, Sanjay Mishra <smishra_97@xxxxxxxxx>wrote: > > Hi > 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 > > TIA > Sanjay > -- > //www.freelists.org/webpage/oracle-l > > > > > > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l