Migrating Oracle 11G DB's from Solaris/HP to New server RHEL 7 with 18C database

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Migrating Oracle 11G DB's from Solaris/HP to New server RHEL 7 with 18C database

Syed Tanweer Ali
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.
Reply | Threaded
Open this post in threaded view
|

Re: Migrating Oracle 11G DB's from Solaris/HP to New server RHEL 7 with 18C database

ErmanArslansOracleBlog
Administrator
From Solaris Sparc / HP UX  to Linux (probably intel)
your sources are Big Endian, your target is however little endian.
So this  is a cross platform migration + you want your target version to be 18C, this means this is also  a migration for upgrade.

There are different methods for doing a cross platform migration of an Oracle Database.
Normally, our options are;

Export / Import to include the use of Datapump facilities. All versions support Export/Import but for Datapump 10.1.0.2 or higher is required
Transportable Tablespaces 10G or Later
RMAN Convert Database functions. 10G or Later
RMAN Duplicate
Streams Replication
Create Table As Select (CTAS)
Dataguard Heterogeneous Primary and Physical Standbys
Oracle Golden Gate (For assistance with Oracle Golden Gate, an SR needs opened with the correct team)

But you are saying that, your source 10g/11G and your target is 18C.
So you want a single operation to perform your cross platform migration + version upgrade.
So, this directs us towards to the pure logical methods.

"XTTS and Export/Import."

Export/Import  is a slow but uncomplicated operation , and it is straight forward. This method lets you migrate cross-platform and to a new release of Oracle in a single step.

"XTTS" - cross platform migration

This is a faster one, but it is a complex/complicated one.

Check your downtime requirements, check your skill, choose your method and create your migration/upgrade strategy..
Reply | Threaded
Open this post in threaded view
|

Re: Migrating Oracle 11G DB's from Solaris/HP to New server RHEL 7 with 18C database

Syed Tanweer Ali
Dear Erman,

Thank you very much for providing the requested information. We appreciate your support as always.

Thanks