Best way to migrate & upgrade an Oracle database to an other server
Hello,
We are using Oracle 12.1 Entreprise edition hosted in RedHat 7.9 physical machines on a RAC cluster environment.
We want to upgrade to 19c and migrate to new physical server RedHat 9.
We would like to keep the 12.1 source environment unmodified.
Databases are more than 1To with BLOB datas.
We cannot use DBUA to upgrade in place 12.1 to 19.
We cannot setup a 12.1 database in the target environment because target env is running in RedHat 9.
We never tried transportable tbs.
We never tried pluggable transport, but is it possible to plug a 12.1 pdb to a 19 cdb (and then upgrade it) ?
Regarding this facts, are we really stuck using EXPDP / IMPDP ?