Forum Stats

  • 3,816,414 Users
  • 2,259,185 Discussions
  • 7,893,475 Comments

Discussions

Upgrade from 11.2.0.4 to 19.3

grimrand
grimrand Member Posts: 176 Blue Ribbon
edited May 5, 2022 10:14AM in Database Upgrade

I have upgraded an 11.2.0.4 database to 19c on a Solaris server - no errors and all appears OK. connecting to SQLPlus gives :

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Show parameter compat -> 19.3.0


If I run an RMAN export, copy the files to a different server that had a fresh 19c install. (SQLPLus shows results the same as above)

When running the RMAN duplicate command (No target spfile backup location) I get an error when restoring spfile from backup location (autobackup directory)

ora-19690: backup piece release 19.3.0.0 incompatible with oracle release 19.0.0.0


I think that the rman backup is created as 19.3 but the auxiliary may be 19.0 is there a way to force the aux to be 19.3


Regards


Terry

Comments