Skip to Main Content
  • Questions

  • Cloning db across two hosts with different OS and db versions.

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Sergei.

Asked: January 26, 2016 - 5:23 pm UTC

Last updated: January 27, 2016 - 2:18 am UTC

Version: 11.2.0.2

Viewed 1000+ times

You Asked

Hi,
I was asked to copy my 11.2.0.2 db running on W2008 server to a new Windows box running W2012R2 and Oracle db 12.1.0.2.0. I would appreciate some input on the best way of accomplishing this task. I understand that I need to either do a full export of the 11g db using expdp or backing it up with RMAN and then either doing imdp or RMAN restore to my 12c db server. I am concerned that the operating system is different between the hosts and the db version is also different.
What is the best way to copy the db and upgrade it to 12c? In what order do I do this?
Thank you very much.
sergei

and Connor said...

As long as the endian formats are the same (which they will be for Windows => Windows) then the datafile formats are compatible, and hence you can use RMAN.

So the most time efficient would probably be (dependent on size)

- rman backup
- copy files across
- rman restore
- upgrade from 11 to 12.

There are more esoteric ways (transportable tablespaces etc) is outage time is an issue.

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks.

Sergei Borisenko, January 27, 2016 - 2:38 pm UTC

Thank you Connor. I'll give it a try. I was told by an oracle employee some time ago that using datapump compresses the database during export and therefore would be a preferred method, but I will follow your suggestion and use RMAN.
Thanks!
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

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.