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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
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