Hi to all,
We need to upgrade Oracle Restart instalation (GI + DB) 12.1.0.1 OL6 to version 19c.
Since no direct upgrade from version 12.1.0.1 to version 19c is possible, we considered the option of upgrading to version 12.2.0.1 and then to version 19c.
Тhe upgrade to 12.2 was successful but we had a problem with the operating system upgrade, from version OL6 to version OL7. According to Oracle, in-place upgrade of Oracle Linux from one major release e.g. OL6 to OL[7,8] is neither supported nor recommended. They recommend, notwithstanding limited support for OL6 to OL7 in-place upgrade, fresh installation of the higher release remains the recommended upgrade path.
If we need to go with the installation of a new db server with OL8 and Oracle 19c, which is in your opinion the fastest and easiest procedure for migrating the existing 12.1.0.1 ie.12.2.0.1 database to the new server? Because the database size is around 9TB, database migration with DATA PUMP expdp / impdp I think it will take a lot of time. Is there an easier way to do the migration at data file level? Is it possible with RMAN backup/restrore, RMAN duplicate or with transportable tablespace?
Thanks in advance.