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

[Suhas Kamble]

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

[Suman Pramanik]

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

[Suhas Kamble]

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

[Legacy User]

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

[Legacy User]

We used expdp

[Nick Darlington]

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).