on 07-15-2009 10:47 AM
Hello All,
I am running a system copy from PRD to QAS and the environment is as follows:
OS: Windows server 2003
DB: Oracle 10.2.0.2
ECC 6.0 (Non unicode)
I have started the import but its taking too long time to create the datafile or the phase import ABAP. I can see there is progress but too slow. The import is running for more than 12 hours and the DB size is 302GB. I use SAP tools for system copy
Everything seems to be fine but still no improvement. Is there anything that i should check in particular? Please suggest
Regards,
Anand
Hi Anand,
Have a look at this guide
It's packed full of some really good tips so your next system copy can be completed much faster
Regards,
Olly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How many parallel process did you use?... normally you can use 1 process per CPU.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anand,
Before you start system copy you ran dbstat in source system. At the time of import donu2019t select dbstat, you can execute dbstat after system build from DB13. Check the in which step you are stuck.
Below few process you use for speed up system copy.
1) Deselect DB statistics at the time of import.
2) You can use migration monitor it will speed up your process.
3) You can use distribution monitor it is very faster process.
4) You can use MM and DM both at a time. Only 3 hour it will take where normal copy takes 30 hours for a big db.
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Awaiz and Suman,
Thanks for your time and reply
I have checked with the Network / System admin and confirmed that their part is fine.
Suman - The import is running now and how i could use the migration monitor? Should i stop and start the import again from first and can you let me know the steps if this can be done during the import is running
Regards,
Anand
Is your SAP filesystem on a NFS share ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.