Skip to Content
author's profile photo Former Member
Former Member

Refresh QAS Environment with Production Data

Hi,

We need to refresh QAS environment with Production data.

Can we export schema SAPPR3 (Production) and import these object in schema SAPQR3 (Quality) through Oracle tool (exp/imp)?

Our idea is:

In Production Server:

1-) Stopsap;

2-) startdb;

3-) exp file=sappr3.dmp log=sappr3.log owner=sappr3 compress=y;

4-) after finish exp, startr3;

5-) sftp sappr3.dmp from Production server to Quality server;

Quality Server:

6-) stopsap;

7-) startdb;

8-) drop user sapqr3 cascade;

9-) create user sapqr3;

10-) imp file=sappr3.dmp fromuser=sappr3 touser=sapqr3;

11-) adjust hostname and/or instace name;

12-) other adjustments.

13-) startr3;

Questions:

Are these procedures correct ?

Does we need to adjust hostname and/or instance name into the database? How ?

Are there others adjustments for to do in this case ? How ?

Are there another way for "refresh" QAS (Quality) environment with Production data ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 11:39 AM

    Hi Dany,

    The procedure is explained in detail in the System Copy Guide for 6.40 which is available for download at the SAP Service Marketplace at http://service.sap.com/instguides. It contains procedures for all databases supported by SAP.

    Regards,

    Rajesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 11:46 AM

    Hi Dany

    I never did a system copy with exp/imp, maybe somebody else did with a SAP system. Obviously you have an oracle db, but you didn't mention platform, release and size of the db. Anyway the sapsr3 schema is huge, it certainly has 40000+ tables. I guess this procedure will take its time, which means downtime for your prod system (data consistency).

    There are two officially supported ways to refresh a QAS system, exp/imp is not among them:

    - copy with backup / restore, advantages: no downtime, fast and simple

    - copy with sapinst (R3load), advantages: full db reorg, SID/schema rename possible, even possible to a different platform or database

    More infos at http://service.sap.com/systemcopy

    Best regards, Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 01:43 PM

    Thanks for answers,

    Our principal problem is the time that PRD environment will be stopped.

    Yesterday I did the exp (but with the PRD environment in production, just to know how

    many time it will take) and this procedure took 4 hours because it exports just data.

    If I do the System Copy with sapinst, this procedure will take its time around 20 hours.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.