client export and import

[Former Member]

Hi,

We need to do a client :300 export from PRD system and import it to Quality: 206 client.

The size of the database in PRD system is around 90 GB and database is Oracle 10.2.0; windows 2003 OS.

Hence please advise on the following.

1. How much free space we require in PRD system for client export, if the whole database size is

90 GB?

2. Can u plz. list the steps for client import and post import activities.

Thanks & Regards

DVRK

[ashish_mishra2 · Accepted solution]

best way to check import log is from os level

go to /usr/sap/trans/tmp directory

during the import the logfile generates in temp directory and continuously updates too.

once the import gets over .. same file will move to your log directory.

Currently if import is running, you can check import log from tmp directory.

[Former Member · Accepted solution]

Hi,

Thanks a lot for the inputs.

But the log at the tmp directory showing that the main import is running. There are no updates on the lof file also.

" START MAIN IMPORT CQS I 20090520121702 cqsadm MYSAPQAS 20090520121656000b10 "

Even the tp log also showing that the main import is running.

How long this will run for 3 GB of data file size ?

Please advise,

Thanks

DVRK

[Former Member · Accepted solution]

That is pretty much difficult to say how much time it will take because it depends on hardware and system. You can check the table space also. and keep watching the log file.

Regards,

Subhash

[ashish_mishra2 · Accepted solution]

Hi,

3GB of RT file takes generally 6-8 hrs. But if really no updates are happening at OS level logfile inside temp directory, check whether the transport is running or not.

If the file is still present inside /trans/tmp dir., it means the import is running and u cn see the updates using tail -f <file name> or the time stamp of that file.

else the file will move to log dir incase the transport completes successfully or failed doesn't matter.

One reason of getting hung the transport during clent export/import is the PSAPTEMP teblespace. Keep an eye continuously on temp tablespace and add datafile if needed. in this case you will see the log dictating that "unable to extend next segment" kind of words.

Check the logfile, I am sure you will get an idea about the status of transport.

Regards,

Ashish

[Former Member · Accepted solution]

Hi All,

Thanks a lot for the suggestions.

The import is successful after running the update statistics.

Regards,

DVRK