Skip to Main Content
  • Questions

  • Moving Oracle DB from one server to another

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Manoj.

Asked: November 13, 2018 - 10:09 pm UTC

Last updated: December 10, 2018 - 3:08 pm UTC

Version: Oracle 11g

Viewed 10K+ times! This question is

You Asked

Hi,

I am having an Oracle 11g database in an AIX linux server. I am planning to move this to a different server with same OS. I will be using same version of Oracle database in target DB as well.
I have multiple schema in source database and in total it will be of size 200 GB.

What is the best option to do this DB transfer/migration with least downtime.? What are the steps I should follow to do this effectively.

If the target server is redhat linux does it make any difference?

Please let me know if any additional information is needed

Thanks in advance

and Chris said...

If you're migrating AIX -> AIX, then you can use Data Guard.

Setup the new server as a standby for the current. Then switch over to it. If you're keeping everything else the same, this is easy.

You can read more about this at:

https://docs.oracle.com/en/solutions/reduce-database-migration-downtime/learn-migrating-oracle-data-guard1.html#GUID-5BD68106-19FC-444F-8E90-25803F1D3474

If you want to go AIX -> Linux, it's a bit more effort. The platforms have different endian formats. So you'll need to do a conversion.

You can read more about transportable tablespaces options to do this at:

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9526802000346654913
https://apex.oracle.com/pls/apex/f?p=202202:2::APPLICATION_PROCESS=downloadFile:::F20225_ID:2081

Rating

  (2 ratings)

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

Comments

AIX to AIX without Data guard

Manoj Kumar, November 15, 2018 - 5:53 pm UTC

Hi,

Thanks for your input. I have just verified that we will be doing AIX to AIX migration without any DB version change. However, we do not have Dataguard enabled in our DB.

Could you please suggest any alternative in this scenario.

Chris Saxon
November 16, 2018 - 3:38 pm UTC

You could use transportable tablespaces (see the links in the original answer) or data pump.

Why not mention cold backup datafile move?

Barbara, December 06, 2018 - 6:56 pm UTC

As pointed out there are a few options. If not changing OS platform why not do a cold backup of the database and move it with a backup controlfile to trace (edited as required) utilized to create the new control files? I believe you have to drop and re-create the repository but other than that it's fairly painless even if you have to do an upgrade.
Chris Saxon
December 10, 2018 - 3:08 pm UTC

Yes, you could try that too.
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 latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.