Skip to Content
avatar image
Former Member

Use Data Pump for OS/DB Migration of ECC system and move out Oracle RAC

I am currently planning the migration of an ECC6.0 EHP 5 Enterprise system from RHEL 5.5 to RHEL 7.3 with concurrent move from Oracle RAC based to standalone & Oracle upgrade from to I would like to use Data Pump instead of R3load (as it is very laborious)and am particularly interested in running the import simultaneously with the export, which I understand is a feature of Data Pump. The db size is around 2.5 tb.

Has anyone done this? I would appreciate any advice, suggestions, or warnings. Also share if there are any risk / limitation with such approach (technical or otherwise)

I have read thru below notes but they do elaborate above points:

1013049- FAQ: oracle data pump

105047- support for oracle function in the SAP environment

976435 - support for oracle datapump in brspace

Regards, Pun

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 08, 2018 at 01:13 PM

    Hi Pun,

    I would recommend you to upgrade source database first, then try backup, restore to do the system copy. I think Rhel 5 to 7 should still be homogeneous system copy.

    Because data pump sounds good, also technically, it should work, however once there is any issue during system copy, you may lack of support, because system copy guide only mentions r3load and backup&restore way to do system copy.

    Best regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2018 at 05:55 PM

    Thanks James for the feedback.

    As shared, we are currently running on Oracle RAC & source DB upgrade (Grid + DB) would require 2.5 -3 Hrs. of additional downtime, which will not be acceptable to business & hence was thinking of using BRSPACE data pump option to perform implicit DB upgrade & migration.

    Considering system copy guide does not explicitly advocates this methodology, I wanted to know from SAP expert community if someone has experienced this & throw some insight on this methodology.

    Kindly further advise.

    Thanks, Puneet M

    Add comment
    10|10000 characters needed characters exceeded