Link to home
Start Free TrialLog in
Avatar of sdruss
sdruss

asked on

Oracle RAC Upgrade from 11.2.0.3 to 12.2

Thinking about different options to get to Oracle RAC 12.2 database from 11g. I've read Recovery manager can restore a backup taken on an older database version into new version. Is this scenario true and viable for our 2-node, Solaris-10, 11G RAC database to 12.2 environment? I know recovery manager has duplicate and upgrade options. Suspect this method would be more complicated than our current choice to upgrade database in place? Data Pump export/import would also be an option with a complete fresh 12.2 install. Although re-importing our multiple terabyte database would require a while to recover.
SOLUTION
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
an in-place is not the safest solution indeed
it keeps you on the old hardware too

if you have problems with chained rows, practice an "alter move table" + rebuild indexes and provide time for it during the upgrade
Avatar of sdruss
sdruss

ASKER

Appreciate guys, I will have follow-on question regarding moving from Solari-10 to Solaris-11 and upgrade from Oracle 11.2.0.3 to 12.2.  Many thanks for sharing your wisdom!