downtime optimization for system copy

[#1]

Hi,

I am planning copy my source database to target database. Here my challenge is the source is a non-compression database and target is a compression database. How can i reach the optimize downtime. My sandbox database is 4TB. It is an system copy-> oracle->source system export-> based on as-abap-> table splitting

I did a system export it took me the system down time of 8 hours with 44 parallel jobs. I took 2 jobs for  r3load process for one cpu ( 22 cpus).

Now for optimizing I am going for table split preparation and I am very new to it. If you have any documents can you please share it to my email.

now I am planning to do table splitting preparation. For this table splitting preparation.

I downloaded the MIGCHECK_2, MIGMON, MIGTIME, ORABRCOPY and SPLIT as it suggested in note: 784118 - System Copy Tools for ABAP Systems

I also found the couple of notes 1875778 - Performance Optimization for System Copy Procedures and 936441 - Oracle settings for R3load based system copy.

I need some more stuff from the experts so i can go ahead and kick off the table splitting preparation.

Note: here my operating system and database are same for source and target.

O.S: Unix and database : oracle.

Thanks in advance.

[ACE-SAP]

Hi

You should read the here under note that provides a more efficient way to prepare table splitting for Oracle.

1043380 - Efficient Table Splitting for Oracle Databases

That post also provide information on that splitting method

Regards

[Former Member]

Hi,

I do found the note, but I used the r3ta option and gave my top 5 tables with number of splits and ran the table split.

ex: cdcls%5

      cdhdr%5.

n did the table split and also did my database instance export both timings took the same time when i did the export