Online Tutorials & Training Materials |
Register Login

Difference between System Copy and System Refresh

Shanker C || 16 Apr 2009 9:58 am || 6

What is the difference between system refresh and system copy?

Is system refresh and system copy same?

Please share the steps of system refresh.

Shanker Chamoli


  • 13 May 2016 12:59 pm Best Answer

    How to make a system copy:

    1. Take offline backup of both the server (source and target servers)

    2. Verify the backup is successfully done.

    3. Run the following command on source system. 
    a. Login as <sid>adm 
    b. svrmgrl 
    c. connect internal 
    d. alter database backup controlfile to trace; 
    e. exit; 
    f. Above command will generate a .trc file in /oracle/P01/saptrance/usertrace directory. 
    g. Copy the text from CREATE CONTROLFILE until the (;) and paste it in to any new .sql or controlfile.sql file. 
    h. Copy the controlfile.sql to target system. 
    i. Edit the file and replace the entire source SID to target SID. 
    j. Edit the reuse database command with the set database command

    4. Copy the aft generated during the backup file from the source system to target system. (/oracle/<SID>/sapbackup) 
    a. Change all the source <SID> to target <SID>. 
    b. Only don't change the backup volume name it must be target system <SID>. 
    c. Copy the above aft file name line from the source back<SID>.log to target<SID>.log file.

    5. Shutdown the target server instance.

    6. From this onwards all the command on the target system only.  
    a. Login as <SID>adm 
    b. run the SAPDBA  
    c. select J (Restore/Recovery) 
    d. select B (Full restore and recovery) 
    e. select A (Select backup of type) 
    f. Select the offline backup which you want to restore. 
    g. It will take some time to restore. 
    h. Once the database is restored login as <SID>adm and run the  
    i. svrmgrl 
    j. connect internal; 
    k. startup nomount (if the database is already mounted shutdown it using the shutdown command) 
    l. run the following command  
    m. @controlfile.sql (file name of the control file contains the CREATE CONTROLFILE statement) 
    n. After the run the above command it should give the "Statement Processed) 
    o. alter database open resetlogs p. shutdown 
    q. Start the database and SAP services using startup.

    7. After this you have to reconfigure the STMS.

    8. All the jobs also you have to reconfigure and reschedule.

    9. Reconfigure all the printers.

    10.  If you want to change the Client number then use the local copy tool and remove the original client after successfully import to new client.

  • 28 Jul 2017 7:24 pm Helpful Answer

    System copy is the offline backup of the source system which can be used to create duplicate copy of the source system

    Database refresh the term used when you take statistics of the database using analyze and compute statistics.

  • 23 Sep 2009 1:09 am
    A system Refresh is where you perform a Homogenous System copy. The Targes and source systems will be equal as far as Clients are concerned. This process is fully described in the System copy guide. copy

  • 22 Jan 2013 8:45 am
    Steps For SAP Client Copy / System Refresh
    Before doing a client copy, you need to prepare the following :-

    1. Find the source client space with the client size custom program which can be implemented using the rel. note:
    Find the space of the client - '0118823'. This will give you the size of the source client.

    2. If your are on Unix OS, adjust all the file systems according to PRD file system to fit the PRD client in DEV
    client based on space requirements also.

    3. You can do the client copy by remote or export/import client.
    Remote method is not preferred if you are doing a large client copy.
    Do a client export/import.

    4. To speed up the export/import, use R3trans export/import for the clustered tables.
    Please find the rel. notes related to performance improvements for cluster tables in OSS.

    5. Do import and post processing.
    Note: Export may take 10 to 20 hr. for 50gb of data
    import may take 4 days and post import will take 8 to 15 hr. for 50gb of data. And it all depends on
    your system performance.

    Please refer OSS rel. notes for the few RZ10 parameters which needs to be set for cluster tables to speed up the process.

    Note :-

    If it is a fresh installation, do this --

    1. SCC4 --> Create client no. and fill other details.
    2. Logon to the newly created client with SAP* and PASS as password.
    3. SCCL --> choose any profile (preferably SAP_ALL), source client 000 and target client .
    4. Preferably do a test run initially to check if it can go well.
    5. As a care check space in databases.

    What are step and procedure to create a client & to take a client copy from source to target.

    By: Kavitha.G

    If you are copying from same system then flow the below steps:

    1. Create the client in Tcode scc4.
    2. Before that create a logical System in BD54.
    3. Login in the newly created client with
    user Name : sap* and password : pass
    4. Use the Tcode sccl to copy the client.if you are not familiar with the client copy. Try a test run and then schedule it in background.
    5. You can select the needed profile.
    6. To view the log files use the tcode scc3.

    If you are using different system then create a rfc connection in sm59.test the connection and then continue from the 1st step
    You can also import and export a client. Use scc7 for importing from the client and scc8 fro exporting from the source client

    What is system refresh when and why it is done?

    System refresh and client copy can be the same thing. Normally when you want to refresh a system this normally means refreshing the clients using a client copy like SCCL or SCC8.

    A system "copy" is very different as this is far more involved than a simple "client refresh"

    Imagine you have a DEV and a PRD system and after 6 months the data in DEV is very old so you would perform a client copy SCC8 from PRD to DEV using a profile that copies the application data from PRD to DEV - it actually deletes the data and replaces it with data from PRD. If however your DEV system died and needed to be completely rebuilt, you would use "Homogeneous System Copy" - you install the OS, Database and SAP and then process the system copy - which makes a complete copy of PRD (all clients)

    Client copy - a single client refresh from PRD to DEV - can be just application data, or user data, or configuration or any combination you choose system copy - all clients 100% copied PRD to DEV

    The system refersh is nothing but the deletion of the client and replacing the data from other client. For example : you have clients 100, 200 and 300. Suppose when you want to refresh the client 100 you remove the client 100 and replace it with 200 0r 300 as per your reqiurement. Mostly the refresh of clients will be happen at the time of development stage.

    System Refresh is a simplified term to Client Copy. Client Copy means copying the production client on to the quality to test the real data. As recommend by SAP this need to carried out every 3 months.

    The process to carry out the same is as follows:
    1. Create a client on quality system using txn scc4
    2. Create a RFC between Production system and Quality System (need to create on quality system)
    3. Login to the newly created client using sap* and pass as a password
    4. Txn sccl to start the client copy. You can test the client copy by selecting the test run option. (test run will estimate the time taken for the activity).
  • 20 Dec 2013 5:31 am

    System referesh means copying sap system to another.the system from where copy is being done called sourse system and the system onto datato be copied called target system.

    If target system is already exists then it is called system referesh.

    if target system is not present and u r building new one with same OS and same database then is called homogeneous system referseh. if both(sourse and target) different OS and DB THEN IT IS CALLED HETROGENEOUS SYSTEM REFERESH

  • 28 Jul 2017 7:41 pm

    Systm copy and system refresh are more or less the same however for convinience purposes system copy is generally defined as creating a new database as a copy of exisitng one while refresh means copying an exisitng database onto another exisitng database.

    However nothing wrong in calling the second thing also system copy. It is just your choice. The important thing is to know what you are doing.