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

[former_member299422]

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 11.2.0.2 to 11.2.0.4. 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

[JamesZ]

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,
James