Grokbase › Groups › Oracle › oracle-l › August 2012
FAQ
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

Search Discussions

  • Steve Harville at Aug 24, 2012 at 7:05 pm ⇧
    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

    http://SteveHarville.com


    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-l
  • Kamus at Aug 26, 2012 at 4:32 pm ⇧
    We did a lot of database migration and upgrade works in the past few years, from 9i to 10g to 11g.
    Yes, the method you mentioned is the best process if source and target has the same platform, incase you can't use Data Guard due to different platform, you can use Goldengate (or MV refresh if has budget concern) to sync data before downtime. In this process, the initial data load is the most difficult part, you have to consider how to split the big tables into little pieces (if unfortunately in your database has some big tables without partition) to make initial works quickly to avoid ORA-1555 error.
    --
    Kamus <kamusis@gmail.com>

    Visit my blog for more : http://www.dbform.com
    Join ACOUG: http://www.acoug.org


    On Saturday, August 25, 2012 at 2:33 AM, Sanjay Mishra 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
    --
    http://www.freelists.org/webpage/oracle-l



    --
    http://www.freelists.org/webpage/oracle-l
  • Steve Harville at Aug 27, 2012 at 5:23 pm ⇧
    Here is the command I used on the new server:
    nohup impdp system/secret NETWORK_LINK=olddb FULL=y PARALLEL=25 &

    Then you can run this to see which parallel process is importing which
    table:

    Impdp system attach

    Import> status

    Import> parallel=30 << 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 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@gmail.com>
    *To:* smishra_97@yahoo.com
    *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 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
    --
    http://www.freelists.org/webpage/oracle-l





    --
    http://www.freelists.org/webpage/oracle-l
  • Sanjay Mishra at Aug 28, 2012 at 1:41 am ⇧
    Thanks Steve.



    ________________________________
    From: Steve Harville <steve.harville@gmail.com>
    To: Sanjay Mishra <smishra_97@yahoo.com>
    Cc: oracle-l <oracle-l@freelists.org>
    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 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@gmail.com>
    *To:* smishra_97@yahoo.com
    *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 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
    --
    http://www.freelists.org/webpage/oracle-l





    --
    http://www.freelists.org/webpage/oracle-l
    --
    http://www.freelists.org/webpage/oracle-l
  • Jared Still at Oct 28, 2012 at 3:24 pm ⇧

    On Fri, Aug 24, 2012 at 11:33 AM, Sanjay Mishra 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.
    A little late ( only a couple months ) on this email, but it seemed
    interesting enough to reply anyway. :)

    We've done this to move a 10g database to Oracle Database Appliance.

    Installing the 10g was unnecessary as I recall - we restored the 10g backup
    on 11g, and applied logs.

    When ready, the database was opened with 'startup upgrade' and the upgrade
    actions were performed.

    I can verify the steps if interested.

    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist
    Oracle Blog: http://jkstill.blogspot.com
    Home Page: http://jaredstill.com
  • Viljo Hakala at Oct 28, 2012 at 8:55 pm ⇧
    Check the following Metalink note for upgrade process:
    Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

    Viljo Hakala
    OCP 10-11g, RAC Expert
    hakala.viljo@gmail.com

    Jared Still <jkstill@gmail.com> kirjoitti 28.10.2012 kello 17.20:
    Installing the 10g was unnecessary as I recall - we restored the 10g backup
    on 11g, and applied logs.
    Did you restore with RMAN 11g?
  • Jared Still at Oct 28, 2012 at 11:44 pm ⇧

    On Sunday, October 28, 2012, Viljo Hakala wrote:

    Jared Still <jkstill@gmail.com> kirjoitti 28.10.2012 kello 17.20:

    Installing the 10g was unnecessary as I recall - we restored the 10g backup
    on 11g, and applied logs.

    Did you restore with RMAN 11g?
    Yes.
    Another team member did this bit, and I just reviewed his docs.
    In a nutshell:

    Restore 10g backup on 11g on ODA
    setup as a standby

    when ready to migrate:
    * shutdown prod database
    * wait for standby to catch up
    * shut down standby
    * open with startup upgrade
    * proceed with standard upgrade steps.

    It all worked quite well.

    HTH

    Jared




    --
    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist
    Oracle Blog: http://jkstill.blogspot.com
    Home Page: http://jaredstill.com


    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 24, '12 at 6:34p
activeOct 28, '12 at 11:44p
posts8
users5
websiteoracle.com

5 users in discussion

Sanjay Mishra: 2 posts Steve Harville: 2 posts Jared Still: 2 posts Kamus: 1 post Viljo Hakala: 1 post

Content

People

Support

Translate

site design / logo © 2021 Grokbase