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.

[Reagan]

Your questions are very basic.

How much free space require in Quality server to Import the PRD client?

Read the point 8 form the SAP note 552711 - FAQ: Client copy

There is any ways to speed up the client import procedure?

Parallelism is not available in export / import. 541311 - CC-INFO: Parallel processes FAQ But there is a TP parameter called PARALLEL. I am not sure whether it will help but you can try. Read this SAP note 1127194 - R3trans import with parallel processes to know more. If that doesn't help then go for the backup and restore method.

Why such amount of redo log files are created during client import?

This is normal and database is designed to work like that.

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...

You may switch the database into no-archive log mode before starting the import.

Regards

RB