Re: Database upgrade for big database
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: "steve.harville@xxxxxxxxx" <steve.harville@xxxxxxxxx>
- Date: Mon, 27 Aug 2012 18:40:45 -0700 (PDT)
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
Other related posts:
