Clarity

Expand all | Collapse all

V12 TO V14 upgrade involve Oracl 10g to Oracle 11g upgrade

Jump to Best Answer
  • 1.  V12 TO V14 upgrade involve Oracl 10g to Oracle 11g upgrade

    Posted 12-11-2014 12:00 PM

    We are planning to upgrade from V12 to V14.1

     

     

    Environment is

    Current : Clarity V12.1.1 with Oracle 10g on AIS+WAS

    TOBE: Clarity V13.3 or v14.1 with Oracle 11g on Tomcat

     

     

    We are planning to have Oracle 11g installed on destination server and restore DB backup from current clarity system onto the destination server.

     

     

    Our DBA raised a concern that Cold backup from oracle 10g can not be restored onto 11G.

     

    Has anybody come across this situation and what was done to achieve this?

     

    The option I as Non-DBA person think of are

    1. Install Oracle 11g on source server and convert the DB to oracle 11g (Duplicate copy) and take backup of this copy and restore it onto new server.

    2. Take Export and do import (Not sure if this does all that is needed to make sure the database will be up and running without any issues with Clarity application)

    3. There must be some option so that Server B with 11g can Pull the entire data from Server B running 10g



  • 2.  Re: V12 TO V14 upgrade involve Oracl 10g to Oracle 11g upgrade

    Broadcom Employee
    Posted 12-11-2014 12:38 PM

    How about using RMAN back up

     

    See link for reference

     

    https://taliphakanozturken.wordpress.com/2012/07/20/how-to-restore-10g-rman-backup-to-11g/

     

    Regards

    Suman



  • 3.  Re: V12 TO V14 upgrade involve Oracl 10g to Oracle 11g upgrade

    Posted 12-18-2014 01:34 PM

    For some reason RMAN is not org standard here, so we are going to take ExportDump-->Import Dump path.



  • 4.  Re: V12 TO V14 upgrade involve Oracl 10g to Oracle 11g upgrade

    Posted 12-21-2014 10:00 PM

    You may want to try:

         1. Install Fresh copy of 11g

         2. Export DB from 10g

         3. Import DB into 11g

    This is what we did for our upgrade, which is working fine for us.

     

    Thanks,

    Bhanu



  • 5.  Re: V12 TO V14 upgrade involve Oracl 10g to Oracle 11g upgrade

    Posted 12-21-2014 10:01 PM

    We used expdp



  • 6.  Re: V12 TO V14 upgrade involve Oracl 10g to Oracle 11g upgrade
    Best Answer

    Posted 01-23-2015 04:00 PM

    Importing either a 'datapump' (impdp/expdp) or 'traditional' (imp/exp) backup from Oracle 10g to Oracle 11g is fine, it's in the other direction (11g to 10g) that isn't allowed.  Just make sure they are schema backups and not full database (sys/system/sysaux/etc.) ones.

     

    RMAN's real purpose is for disaster recovery of a complete Oracle system including non-schema files and data, in case you lose it for example and are faced with a reinstall/rebuild, and not really the best tool for this job (migrations/upgrades).