Upgrading Oracle or Start from New

Posted on 2011-05-12
Last Modified: 2012-12-25

I have been tasked with upgrading the oracle database from Oracle 10g to 11g, but I am not sure what is the best way to go about doing that.  A little background first, currently oracle 10g is on a Windows 2003 x32 server and I am suppose to move it to a new server the OS is 2008 x64.  So should I:

A.  From a backup tape restore the current 10g dbf's and then proceed to upgrade it to 11g from there or

B.  Would it be better to start from scratch doing a clean install of 11g on the 2008 server and placing the dbf's accordingly

The only reason why I am asking this is I have never done an upgrade like this before so any assistance will help.
Question by:mekkattiljj
    LVL 76

    Accepted Solution

    If you can, I recommend a clean install and expdp/impdp (datapump exp/imp).
    LVL 23

    Assisted Solution

    - since its on a new server,i would suggest a clean install of 11g
    - do rman backup on 10g
    - then do a restore on the 11g

    LVL 15

    Assisted Solution

    by:Devinder Singh Virdi
    Best part of importing back is that you can control total number of extents of tables, therefore you will get good performance.
    Whatever  method you are going to select, take backup of dba_tables, dba_indexes, dba_tab_partitions, dba_extents etc tables to see the difference in order to analyze performance or object level difference.
    You may see some performance concern.
    LVL 1

    Assisted Solution

    I did many migrations like this and the best way and easy is with schema expdp/impdp.

    Not nedd to RMAN configuration.
    Fast than exp/imp.
    Can't use cold backup.
    No need to archive mode enable.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Want to promote your upcoming event?

    Attending an event? Speaking at a conference? Or exhibiting at a tradeshow? Easily inform your contacts by using a promotional banner in your email signature. This will ensure your organization’s most important contacts are in the know.

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now