on 01-22-2012 11:09 AM
Dear All,
We are doing Export & import
We want to minimize the Down time
can any open tell the steps to minimize
And one more thing we extract the oracle to stage directory , but even sapinst also extracting again
I need to skip that phase , where we can skip the Phases
SAP u2013ECC 6.0
O/s u2013 linux
Database Oracle
Regards
Babu
Hi,
besides the table split method, where you create export/import packages, of similiar size, and via paralelism you acelarate the process, another technique is to start the import in the destination server while the export is sitll running,
best regards,
Ricardo Caramona
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
And one more thing we extract the oracle to stage directory , but even sapinst also extracting again
I need to skip that phase , where we can skip the Phases
If sapinst finds the oracle software already installed for that SID, it won't do it (at least the newer sapinst's).
Another possibility is to drive the installation to the point where the import begins. Terminate sapinst just before the import starts, then you can save the instdir (/tmp/sapinst_instdir) and replay the import as often as you like.
Cheers Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
WE are facing another problem now
we did the export of PRD system in10 hours
but in import its taking much time
ie, import abap is taking much time (like for one task completion its taking 4 hrs)
import is very very slow
can any one tell me the parameters need to be change in o/s- database -
Our environment is
O/S suse linux 11
database oracle 11g
sap ECC 6
database size 3 tb
Regards
Babu
Hi Babu,
First of all, have you check the system resouce utilization? CPU, RAM, disk and etc? Is there any bottleneck?
Secondly, how many parallel job have you configured?
For OS parameter, you can follow migration guide or installation guide, for eg: check the ulimit.
How much RAM you assign to oracle? If you perform the migration using sapinst, ensure oracle session and processes is not fully occupied.
How do you define slow in Import Abap? Slow for every table or just particular table? Do you perform table spliltting? As noticed, you DB size is huge.
Thanks,
Nicholas Chang
Daer all,
We did the Export in 8 hours
but when we are performing import its taking huge time
ie( in 6 hours ,22 process completed , total process 523)
Our Envirmoment as follows
SAP details
SAP ECC6.0, Oracle 10.2.0.5, SuSE10 SP3
Database size - 4TB
SAP Kernel 700 Patch 291
Hardware details
IBM x3850 X5 (64 Core CPU & 512GB RAM)
SAP ECC6.0, Oracle 11.2.0.2, SuSE11 SP1
SAP Kernel 700 Patch 291
Hi Babuc,
Have you check what i've suggested earlier?
First of all, have you check the system resouce utilization? CPU, RAM, disk and etc? Is there any bottleneck?
Secondly, how many parallel job have you configured?
For OS parameter, you can follow migration guide or installation guide, for eg: check the ulimit.
How much RAM you assign to oracle? If you perform the migration using sapinst, ensure oracle session and processes is not fully occupied.
You have a very powerful hardware where you can fully utilize them.
Cheers,
Nicholas Chang
Following this link for optimizing the downtime for export/import.
[http://wiki.sdn.sap.com/wiki/display/unicode/Downtime+optimization]
Use package splitting feature , this really helps in reducing the export time and consequently the import time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi ratnajit,
Thanks for the link,
but we are going for H/w migration and oracle /o/S upgradation using export import
existing scenrio - ECC 6 with 10g on linux 10
planning to go for Ecc with 11g on linux 11 with new hard ware
by using export n import (earlier we upgraded to 4.6 to Ecc6 but the table space structure has 4.6 c only )
so we are going for Export . import
can u give me ur sugesions for minumize the downtime
Regads
Babu
Hi Babuc,
The downtime is mainly depends on how powerful is your hardware resources (CPU, RAM, Disk speed, and etc) and size of of your DB.
Fyi, you can set 2 parallel process for 1 CPU core. Also, i would suggest you to perform a test run where you can use MigTime to analyze duration of the export/import process. Based on the result, you can use "sort order" and table splitting to further miminize downtime. Also, monitor the CPU usage during export/import, increase more parallel R3Loads if no CPU & disk bottleneck.
You can download the migtime from:
Additional Components" SYSTEM COPY TOOLS" SYSTEM COPY TOOLS 7.10
Hope it helps,
Cheers,
Nicholas Chang
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.