Client Import..

[Former Member]

Hi,

We need to perform the client export of PRD (300 client) system and import in QAS (300 client) i.e. quality server.

I have performed the Client export of PRD (300 client) server, which takes 4 hours and creates following two requests..

RT00025 (Client specific) = 9 GB

RX00025 (Texts) = 90 MB

Database is ORACLE on windows server 2008 R2.

Last time when we perform the client export and import procedure, that time client specific request (RT00023) is of 3 GB and it has taken 2 days to complete the client import procedure. Another thing I have seen that, there are huge redo log files created in ORAARCH folder near about 80 GB redo log files during this client import.

  So please advise me on following points..

1. How much free space require in Quality server to Import the PRD client?
2. There is any ways to speed up the client import procedure?
3. Why such amount of redo log files are created during client import?
4. How to reduce this amount of redo log files because this time client export is of 9 GB, so it creates huge amount of redo log files...

Thanks and regards,

Swapnil.

[Former Member]

Dear All,

Thanks for your valuable comments. I will follow and get back to you.

I would like to know that, basically which profile is used while export of Production client i.e. SAP_ALL or SAP_CUST, obviously it depends upon the requirement, but what is your suggestions on this?

SAP_ALL contains all the client specific data. i.e User data, Customizing, Application data.

I have exported the Production client with SAP_ALL profile and the request is created of 9 GB.

If i take export with SAP_CUST, so its obvious the export(request) size is less and it will imported on target client quickly. (Because SAP_CUST contains only Customizing and application data will delete)

But as I said need your suggestions, which profile is preferred in most of companies?

Thanks and regards,

Swapnil..

[Former Member]

It really depends on the usage of target client!

If you want to make a QTY system with same data where you do UAT etc., then you should select SAP_ALL. If you just want to use it as production copy in sync with customization and you create the data on your own then SAP_CUST is fine.

If you want full data, easiest option is to take online backup of Production and restore it in QA which can be done in few hours (Not days).

If you just need customization data, then do client export/import by selecting SAP_CUST which can be done in few hours (Not days).

But do not do client export/import (for bigger clients) with SAP_ALL (Because you have single client in source and target, so it doesn't make sense to do this massive excercise just to get the full data. And you cannot expect system to finish such activity in hours).

Regards,

Nick Loy