cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Client Import..

Former Member
0 Likes
1,944

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.

View Entire Topic
Former Member
0 Likes

Dear Nick and Gaurav,

Yes we have only one client in PRD.

Sure I will read the note 68896, but what steps should I take for current situation, Production client export is completed and need to import it in Quality.

Thanks and regards,

Swapnil..

former_member182657
Active Contributor
0 Likes

Hi Swapnil,

Generally if client size is more we prefer to opt system refresh/copy activities to reduce downtime.For import procedure kindly check SCN doc Step by Step guide for client export import - Basis Corner - SCN Wiki

Regards,

Gaurav

S_Sriram
Active Contributor
0 Likes