Skip to Main Content
  • Questions

  • Migrate the database from the windows server to the Linux server from different versions 11g to 19c

Breadcrumb

Question and Answer

Connor McDonald

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 10K+ times! This question is

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
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.