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

System Copy Solution Manger

hi everybody,

I want to change the location of the solution manager to another server. Could a system copy be the best way?

how can I do it?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 26, 2006 at 05:57 AM


    System copy would be the right call. Here's how you do it.

    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 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//sapbackup)

    a. Change all the source to target .

    b. Only don't change the backup volume name it must be target system .

    c. Copy the above aft file name line from the source back.log to target.log file.

    5. Shutdown the target server instance.

    6. From this onwards all the command on the target system only.

    a. Login as 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 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.

    Feel free to revert back.


    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.