Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi Peter,
Your Database is now at a size that a Remote client copy is going to take a very long time. I would recommend using the Client Export with Tx SCC8 then import with Tx STMS_IMPORT and completing with Tx SCC7.
Remote client copies are dependent on the Database Size, Network speed and System Resources.
Regards
| | | ---------------Original Message---------------
From: Peter2009
Sent: Monday, October 18, 2010 12:54 PM
Subject: Problem with slow remote client copy
Hi Gurus,
I'm using SAP ECC6, ORACLE 10.2.0 and HPUX B.11.23. These configurations are the same for both PRD and QAS systems.
I'm currently in the midst of executing a remote client copy from PRD to QAS system. Current PRD database size is about 390GB. Previously I had done the same process and it took about 2 days to complete. That was about 6 months ago and the database size might be smaller.
Now, with the database size increased, I'm performing the same task again, but this time, the copying process has been running about 3 days already and has yet to complete. Initially I was having some issues with the tablespace being full, but it has been fixed.
I had observed from the client copy screen, it shows that there are 54915 tables and 54908 is already done. Please see below.
Sample info:
Statistics for this Run
- No. of Tables 54908 of 54915
- Deleted Lines 217919510
- Copied Lines 346665360
My questions are:
1) Why is it taking so long to complete the process? 3 days and still going? Is this normal? Is there anything else that I should check and monitor apart from archive log and table space?
2) Is there a way to improve this copying process? Is there any alternative or a better way of doing so?
Would appreciate for any of your help and advice.
Thank you.
Cheers. |
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  D. Caddick
SAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Related Content Most Popular White Papers
In the Spotlight  _.____.__ |
Mark as helpful
