Client Export /Import method

[Former Member]

Dear All,

I will plan to do client copy from PROD to QA .

pls find the details :

we have 2 client in PROD .

one is for preprod client (for BI testing purpose).

second is for Actual prod client .

Below things i need to clarify.

1, I required to take a copy whole data from actual PROD Client to QA ,let me know which profile is prepared .

2, What are the things i have to check before performing Client copy PRD to QA . (Both QA side as well as PROD side).

3, PROD DB size is 450GB , let me know how long i will take to complete the Client copy .

we are using AIX , Oracle 10G and ECC6.0.

Kindly advise

Edited by: satheesh0812 on Dec 22, 2010 12:19 PM

[Former Member]

Answered

[Former Member]

Client export has been completed ,usr/sap/trans file system on QA needs to be upgrade as same PROD for Client Import process ?

[Former Member]

Dear all ,

Client export got completed , let me know i need to adjust usr/sap/trans space as same as PROD on QA before Client import ?

Kindly suggest as well let me what are steps i have to follow after Client export successfully....

any link or similar thread pls

Regards

Edited by: satheesh0812 on Jan 19, 2011 6:30 PM

[sunny_pahuja2]

Hi,

>

> 1, I required to take a copy whole data from actual PROD Client to QA ,let me know which profile is prepared .

>

SAP_ALL profile.

> 2, What are the things i have to check before performing Client copy PRD to QA . (Both QA side as well as PROD side).

>

Make sure you do this activity when there is less load on the system. Use export/import method for client copy.

> 3, PROD DB size is 450GB , let me know how long i will take to complete the Client copy .

> we are using AIX , Oracle 10G and ECC6.0.

There is no standard timeliness for client copy. It depends on the system resources available and performance of the system. In order to increase the speed of import in your quality system, you can de-activate archiving and once client import will finish then activate it again.

Thanks

Sunny

[Former Member]

>>we have 2 client in PROD .

Not a good idea to have two clients in production.

There are client copy profiles, you have to select the accrete profile as per your requirement and has the description.

You have two options:

remote client copy (I will not advise as your DB is 450 GB)

Client export / import

For client export / import, make sure you have sufficient freespace under /usr/sap/trans.

also make sure you have sufficient freespace on your QA system or extend you QA DB as same as prod.

Time is depend on your H/W CPU, memory, HDD speed. I think client export should finish in 4-5 hours and may vary on client profile.

[Former Member]

Dear Sunil ,

Thanks for your mail .

>>we have 2 client in PROD .

Not a good idea to have two clients in production ---> Still BI is not golive and testing also done in Preprod Client , anyway after golive of BI , we will delete Preprod Client .

There are client copy profiles, you have to select the accrete profile as per your requirement and has the description --> shall i gohead with SAP_all or SAP_EXPA (bcoz i want complete data of Actual PROD Client to QA)

You have two options:

Client export / import --> With your advise i can gohead Client export / import

For client export / import, make sure you have sufficient freespace under /usr/sap/trans ---> i have increase /usr/sap/trans file system on both QA and PROD . if yes Client advise approximatly hopw much space i required to increase.

also make sure you have sufficient freespace on your QA system or extend you QA DB as same as prod ---> With your advise i wil increase QA file system as like prod .

Time is depend on your H/W CPU, memory, HDD speed. I think client export should finish in 4-5 hours and may vary on client profile.

Kindly provide some clearence about profile . bcoz my requirement i need a whole copy of Actual PROD client to QA .

Kindly advise the points so that i can smoothly complete my client copy process .

thanks and regards

[Former Member]

Use SAP_ALL profile if you want all the client specific data.

Do you also want the BI client in QA?

[Former Member]

Dear Sunil ,

Thanks for your mail .

I forgot to say one thing .

Preprod is a copy of actual prod client only ,so i dont required pre prod data to QA (bcoz any is a copy of Actual prod)

2 Client are in prod , pls check below details:

1,Actual PROD Client.

2,Preprod client (copy of Actual prod client)

Pls advise .

Edited by: satheesh0812 on Dec 22, 2010 1:19 PM

[Former Member]

Mean you have two client of same size in your production system. Mean your real client size may be around 200 GB?

If this is the case then you can use remote client copy (SCC9) which should be easy option for you.

Are you going to replace your existing development client or creating a new client.

[Former Member]

Dear Sunil ,

Yes QA Client will be overrite from PROD Client .

Still i have below query

I have to increase /usr/sap/trans file system on both QA and PROD servers? . if yes let me know approximate size i have to increase ?

Pls check our PROD file system.

/dev/prddata1lv 160.00 66.64 93.36 42% /oracle/IRP/sapdata1

/dev/prddata2lv 170.00 94.25 75.75 56% /oracle/IRP/sapdata2

/dev/prddata3lv 160.00 74.56 85.44 47% /oracle/IRP/sapdata3

/dev/prddata4lv 170.00 89.15 80.85 53% /oracle/IRP/sapdata4

PRDCIXI_svc:/sapmnt/IRPorg 12.00 5.64 6.36 47% /sapmnt/IRP

PRDCIXI_svc:/usr/sap/transorg 16.00 7.09 8.91 45% /usr/sap/trans

Pls check our QA file system.

/dev/qacdata1lv 89.00 50.05 38.95 57% /oracle/IRQ/sapdata1

/dev/qacdata2lv 85.00 46.71 38.29 55% /oracle/IRQ/sapdata2

/dev/qacdata3lv 98.00 55.76 42.24 57% /oracle/IRQ/sapdata3

/dev/qacdata4lv 88.00 50.29 37.71 58% /oracle/IRQ/sapdata4

/dev/saptranslv 24.00 9.70 14.30 41% /usr/sap/trans

Kindly advise

[Former Member]

If you use remote client copy then no need to extend /usr/sap/trans.

[Former Member]

Any recommendation is required to do remote client copy like both PROD and QA have same set of support patch level etc ?

[Former Member]

Hm! always you must have both systems on same patch level.

[Former Member]

Dear Sunil ,

I thing remote is not possible bcoz both the system patch levels are not same .so i will plan export / import method .

Pls suggets i have to upgrade usr/sap/trans on both the system . if yes let me how much space to increased on usr/sap/trans .

or only i have to increase the file system on QA ?

Kindly suggets

[Former Member]

I have never tried to export/import client in different SP levels. Hence I can't assure you.

About the /usr/sap/trans this filesystem is shared between your systems. Where is the physical filesystem, on that server only you need just expand at once.

[Former Member]

Mean for export / import also need both the system should also a same patch level ?

Kindly advise

[Former Member]

I think yes. if you want a successful client copy.

[Former Member]

Dear Sunil ,

I think final query ,patch level means all the Support packages , kernal packages , addon patches and including SPAM patch ..

is it correct ? ,pls correct me if i am wrong or any thing missing ?

Kindly suggest

[Former Member]

Some time SAP kernel is different then client copy should work. But SAP recommands always use latest TP, R3trans and R3load patches.

Only support pack and add-on should be on same level, SPAM patch should not be an issue.

[Former Member]

Dear Sunil ,

This is the time to close this thread ,

currently patch level process is going on QA system.

Still i have one query .

1, /usr/sap/trans file system should be increase on QA as well as PROD ?

2, U have mentioned extend QA DB as same as PROD that means QA file system should be increased as same as PROD ?

QA DB patch level is 10.2.0.2 but PROD patch level 10.2.0.4 , Need to be upgrade DB patch level on QA ?

Kindly suggest

[Former Member]

Dear Sunil/All

Any update for my reply .

Kindly suggest

[Former Member]

>>QA DB patch level is 10.2.0.2 but PROD patch level 10.2.0.4 , Need to be upgrade DB patch level on QA ?

Can I ask why your landscape is not on one level? (DB, kernel, support pack etc)

There should not be an issue if you have oracle on different patch levels.

>>/usr/sap/trans file system should be increase on QA as well as PROD ?

The /usr/sap/trans file system should be shared (SAP standard) across the landscape. (DEV, QA, PRD). If you are not sharing the filesystem then you have to extend the filesystem on QA and PRD. Please paste the df -k output from QA and PRD.

As you are doing the client copy no need to have same filesystem size on QA as PRD, but you need to extend you database as same production. Do you have sufficient freespace on existing filesystem on QA.

[Former Member]

Dear Sunil ,

df -k output of PROD DB

ROOT@PRODORADB:/#df -k

Filesystem 1024-blocks Free %Used Iused %Iused Mounted on

/dev/prddata1lv 167772160 97899508 42% 34 1% /oracle/IRP/sapdata1

/dev/prddata2lv 178257920 79433416 56% 28 1% /oracle/IRP/sapdata2

/dev/prddata3lv 167772160 89593096 47% 24 1% /oracle/IRP/sapdata3

/dev/prddata4lv 178257920 84778288 53% 29 1% /oracle/IRP/sapdata4

PRDCIXI_svc:/sapmnt/IRPorg 12582912 6640280 48% 49290 4% /sapmnt/IRP

PRDCIXI_svc:/usr/sap/transorg 16777216 9346524 45% 15564 1% /usr/sap/trans

df -k output of QA system

ROOT@SAPDEVQA:/#df -k

Filesystem 1024-blocks Free %Used Iused %Iused Mounted on

/dev/saptranslv 25165824 14995340 41% 24610 1% /usr/sap/trans

/dev/sapdevlv 16777216 13896040 18% 2489 1% /usr/sap/IRD

/dev/devexelv 10485760 7711168 27% 53910 4% /sapmnt/IRD

//dev/devdata1lv 74448896 37439296 50% 30 1% /oracle/IRD/sapdata1

/dev/devdata2lv 68157440 30305004 56% 24 1% /oracle/IRD/sapdata2

/dev/devdata3lv 83886080 37873916 55% 24 1% /oracle/IRD/sapdata3

/dev/devdata4lv 78643200 44981496 43% 22 1% /oracle/IRD/sapdata4

/dev/oraarchdevlv 41943040 38308236 9% 88 1% /oracle/IRD/oraarch

/dev/sapqaclv 18874368 16009424 16% 2234 1% /usr/sap/IRQ

/dev/qacexelv 10485760 7491928 29% 10859 1% /sapmnt/IRQ

/dev/oraqacsidlv 17825792 8526076 53% 2830 1% /oracle/IRQ

/dev/qacdata1lv 93323264 40838580 57% 32 1% /oracle/IRQ/sapdata1

/dev/qacdata2lv 89128960 40146312 55% 24 1% /oracle/IRQ/sapdata2

/dev/qacdata3lv 102760448 44293436 57% 24 1% /oracle/IRQ/sapdata3

/dev/qacdata4lv 92274688 39543704 58% 24 1% /oracle/IRQ/sapdata4

/dev/oraarchqaclv 31457280 27434048 13% 98 1% /oracle/IRQ/oraarch

/dev/sapbwdevlv 22020096 10415372 53% 103309 5% /usr/sap/IBD

/dev/bwdevdata1lv 41418752 20093324 52% 14 1% /oracle/IBD/sapdata1

/dev/bwdevdata2lv 58720256 14805060 75% 15 1% /oracle/IBD/sapdata2

/dev/bwdevdata3lv 39845888 25503156 36% 12 1% /oracle/IBD/sapdata3

/dev/bwdevdata4lv 39845888 29455816 27% 14 1% /oracle/IBD/sapdata4

ROOT@SAPDEVQA:/#

we have installed 3 instances on same server . (SAP DEV,QA,BI(dev))

Kindly suggest

[Former Member]

>>PRDCIXI_svc:/usr/sap/transorg 16777216 9346524 45% 15564 1% /usr/sap/trans

above filesystem mounted on production from your PRDCIXI_svc.

As per your df -k result doesn't looks like the /usr/sap/trans filesystem is shared between you QA and PRD.

>>we have installed 3 instances on same server . (SAP DEV,QA,BI(dev))

Are you using same /usr/sap/trans for all above instances? or different.

Simple test, logon to your prod server go to /usr/sap/trans and create a dummy file.

now logon to QA server goto /usr/sap/trans and check whether you can see above file created on prod.

[Former Member]

Dear Sunil ,

1,usr/sap/trans for PROD is not shared (its only applicable PROD) .

2,usr/sap/trans is shared for BIWdev, ECCDEV, and ECCQA .(its common for 3 instanaces) .

Note :

1,Now MY prod and QA have same Kernal patches and same support packages as well same addons patch .

2, our OS team added 20GB to usr/sap/trans on both the systems .

3, we have adjust below QA file system as same as prod.

for your reference :

File system for PROD:

Filesystem GB blocks Used Free %Used Mounted on

/dev/prddata1lv 160.00 66.64 93.36 42% /oracle/IRP/sapdata1

/dev/prddata2lv 170.00 103.97 66.03 62% /oracle/IRP/sapdata2

/dev/prddata3lv 160.00 74.56 85.44 47% /oracle/IRP/sapdata3

/dev/prddata4lv 170.00 89.15 80.85 53% /oracle/IRP/sapdata4

File system for QA:

dev/qacdata1lv 120.00 50.06 69.94 42% /oracle/IRQ/sapdata1

dev/qacdata2lv 150.00 46.72 103.28 32% /oracle/IRQ/sapdata2

dev/qacdata3lv 130.00 55.78 74.22 43% /oracle/IRQ/sapdata3

dev/qacdata4lv 140.00 50.41 89.59 37% /oracle/IRQ/sapdata4

=======

usr/sap/trans file system on PROD:

PRDCIXI_svc:/sapmnt/IRPorg 12.00 7.30 4.70 61% /sapmnt/IRP

PRDCIXI_svc:/usr/sap/transorg 36.00 7.16 28.84 20% /usr/sap/trans

usr/sap/trans file system on BIDEVQA:

/dev/saptranslv 44.00 10.18 33.82 24% /usr/sap/trans

Kindly suggest , any else i have missed ?

Kindly suggets

Edited by: satheesh0812 on Jan 7, 2011 8:34 AM

[former_member293883]

Everything seems to be fine.....you can proceed....

Nirmal.

[former_member227281]

Hello Satheesh,

For different SAP SP patch levels, remote client copy from Prod to QA will not work because of table structures are different.

However, you can perform export / import using sapinst. Another method is Database copy. It is the best method for refreshing from Prod to Qa having large database size.

Thanks and Regards

APR