Data center migration

[Former Member]

Dear Friends,

I have requirement to move SAP ERP ,BW , HR applications to different datacenters. Source and target have different versions of Oracle , Windows. I would request your suggestions on migration methodology. Whether we can use backup / restore or need to follow SWPM export / import procedure.

Source landscape :

OS : Windows 2012

DB : Oracle 12.2

Target landscape

OS : Windows 2019

DB : Oracle 19C

Thanks,

Ramesh

[Reagan · Accepted solution]

Ramesh If you want to save downtime then consider upgrading the DB to 19c on the source system before you prepare to move the systems to the new DC. If backup and restore is possible between the two DC's then you could follow that. You could get the target system installed already and then take a full backup of the source system and restore it on the target host and enable log shipping from the old DC to the new DC. On the final day you will just apply all the logs and open the database. This way you will save a lot of time.

RB

[Former Member · Accepted solution]

Thanks Reagan!

[Former Member]

Hello Bibin,

Thank you for response.

I have 2 questions. could you please clarify.

1. Source and target windows are different versions (2012 to 2019). Still backup & restore possible ?. As per system copy guide both source and target have same binaries.

2. As per PAM Oracle 12.2 can support Windows 2012, 2016 not 2019. but as per requirement target OS should be windows 2019 and huge downtime required restore + Oracle upgrade + OS upgrade. Please suggest possible minimized downtime alternative.

Thanks,

Ramesh

[former_member506192]

Hi,

This is a homogeneous migration. You can build a shell system at target system with oracle 12.2. Then do a backup and restore. Then upgrade to 19C.

Thanks,

BS

[S_Sriram]

Hi Ramesh.

Have you refered the following blog

https://blogs.sap.com/2020/07/07/oracle-19c-database-upgrade-of-sap-system/

Regards

SS