We are planning to upgrade from V12 to V14.1
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
How about using RMAN back up
See link for reference
For some reason RMAN is not org standard here, so we are going to take ExportDump-->Import Dump path.
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.
We used expdp
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).