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

How to system copy?

Hi gurus,

pls send me brief explenetion about system copy.and also what is home and heterogenious copies.plz send me with good explenetion.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 24, 2007 at 04:32 PM

    Hi guru,


    Homogeneous Copy of Objects from One R/3 System to Another


    By ITtoolbox Popular Q&A Team for ITtoolbox as adapted from SAP-R3-BASIS discussion group


    Can someone shed some light on how to transfer Objects between one R/3 System and another using Homogeneous copy? Both Source and Destination are NT / Oracle.

    Full Article:

    Disclaimer: Contents are not reviewed for correctness and are not endorsed or recommended by ITtoolbox or any vendor. Popular Q&A contents include summarized information from SAP-R3-BASIS discussion unless otherwise noted.

    1. Adapted from response by Satya Kadali on Friday, May 09, 2003

    The following steps are for Unix environment, but it should be the same for NT too.

    Source SID: SSD

    Target SID: TSD

    On target system, you only need the following 3 CDs:

    - Kernel

    - Rdbms1

    - Rdbms2


    A. Take an offline Backup of the Source SAP Database

    B. Run the r3copy (from the kernel CD in /UNIX/COMMON) on the source system as ORASID to create CONTROL.SQL and INIT.ORA in /oracle/SSD/sapreorg/

    C. Copy /oracle/SSD/sapreorg/CONTROL.SQL to /oracle/TSD/sapreorg/

    D. Copy /oracle/SSD/sapreorg/initTSD.ora to /oracle/TSD/sapreorg/

    E. On Target Create the file systems and copy the data files from source system

    F. Execute the unix/INSTTOOL.SH , INSTGUI and R3SETUP on target system (these are on the kernel cd)

    G. Run RUNINSTALLER on Target system (from /oracle/stage/817_64/Disk1/SAP)

    H. Run r3copy on the target system (From /oracle/SID/sapreorg)

    I. Continue / restart R3SETUP to finish R/3 installation.

    J. Post installation process - install license, import profiles using RZ10, configure STMS

    2. Adapted from response by Sunil Vishnu Bujade on Saturday, May 10, 2003

    The following is for Oracle Database only.

    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




    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2008 at 05:42 AM


    Please refer the link below



    P.S. Reward points for useful answer.

    Edited by: Tushar Vhora on Jan 10, 2008 6:42 AM

    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.