cancel
Showing results for 
Search instead for 
Did you mean: 

Need to skip the Steps in SAPinst while import & export

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Thnks michal,

but we are facing the poblem even we exract the oracle,

can you tel me, in which file we can edit those things in (SAPINST ).

Regards

Babu

Former Member
0 Kudos

Dear Michal,

then you are using an older sapinst and my recommendation is to drive the installation until before the import and save the instdir.

i didnt get whyyou are saying to copy n save the inst dir...

can tell me briefy

Former Member
0 Kudos

i didnt get whyyou are saying to copy n save the inst dir...

Just to be able to repeat the import from that point on. You can always copy the instdir back to repeat it (without the software extraction and stuff).

Cheers Michael

Former Member
0 Kudos

Dear michal,

Thnks for ur reply

correct me if i was wong

you mean to say .. we have to rename the SAPINST_INSTDIR and then again we need to repear the sap inst ????

Regards

Babu

Former Member
0 Kudos

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

nicholas_chang
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

nicholas_chang
Active Contributor
0 Kudos

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

former_member189725
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

nicholas_chang
Active Contributor
0 Kudos

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