Migrating Oracle 11G DB's from Solaris/HP to New server RHEL 7 with 18C database
Posted by Syed Tanweer Ali on Oct 14, 2019; 3:32pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Migrating-Oracle-11G-DB-s-from-Solaris-HP-to-New-server-RHEL-7-with-18C-database-tp7786.html
Dear Erman,
We have some mid-range oracle 10g/11g databases of sizes( 200Gb - 1TB) running on Sun Solaris/HP-UX servers. We have a requirement to migrate and upgrade all this database to New servers RHEL 7 with an 18C database.
We will get new servers with RHEL 7 and oracle 18C installed on it. Could you please let me know the options available for migrating the data to new servers.
1. Can we just use the export/import of schemas/ tables to new servers?
2. OR we should use the TTS option.
Please advise on this.