Thanks for the question, RAM.
Asked: December 15, 2021 - 3:06 pm UTC
Last updated: December 16, 2021 - 5:01 am UTC
Version: 19c
Viewed 1000+ times
You Asked
We need to migrate the database from the windows server to the Linux server from different versions 11g to 19c.
Source: Oracle Product Version:11.2.0.4 Operating System: Microsoft Windows x64 2012 R2 Database Size:1.5TB
Target: Oracle Product Version:19.3.0.0 Operating System: Red Hat Enterprise Linux 8.4 Database Size:1.5TB
Can you suggest a recommended approach(steps) to move the data?
1)Either by export/import or RMAN? If any other alternatives. Kindly suggest.
2)Can you please estimate the time duration of export and import?
3)Can you please estimate the time duration of RMAN? In RMAN migration different OS Platform applicable?
and Connor said...
Windows and Linux have the same endian format, so you can use RMAN to do a cross-platform migration
See MOS note 1401921.1
I would anticipate that is going to be much faster than export/import. Duration will be similar to a full backup and full restore. There is also scope for reducing downtime during the migration
(Note that using RMAN does mean that at the end of the migration exercise you will need to run the upgrade scripts to get from 11 to 19, but the duration of that is not proportional to the size of the database.)
Is this answer out of date? If it is, please let us know via a Comment