Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Upgrading Oracle or Start from New


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.
4 Solutions
slightwv (䄆 Netminder) Commented:
If you can, I recommend a clean install and expdp/impdp (datapump exp/imp).
- 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

Devinder Singh VirdiLead Oracle DBA TeamCommented:
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.
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.


Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now