How to do a SAP System Copy
Step by step for SAP 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.
o
Login as adm
o
svrmgrl
o
connect internal
o
alter database backup control file to trace;
o
exit;
o
Above command will generate a .trc file in
/oracle/P01/saptrance/usertrace directory.
o
Copy the text from CREATE CONTROLFILE until the (;) and paste it
in to any new .sql or controlfile.sql file.
o
Copy the controlfile.sql to target system..
o
Edit the file and replace the entire source SID to target SID.
o
Edit the reuse database command with the set database command
4. Copy the generated during the backup file from the source
system to target system.
(/oracle//sapbackup)
o
Change all the source to target .
o
Only don’t change the backup volume name it must be target system.
o
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.
o
Login as Orasid
o
run the brtools
o
select Restore/Recovery
o
select Full restore and recovery
o
select backup type
o
Select the offline backup which you want to restore.
o
It will take some time to restore.
o
Once the database is restored login as Orasid and run the
o
svrmgrl
o
connect internal;
o
startup nomount (if the database is already mounted shutdown it
using the shutdown command)
o
run the following command
o
@controlfile.sql (file name of the control file contains the
CREATE CONTROLFILE statement)
o
After the run the above command it should give the “Statement
Processed)
o
alter database open resetlogs
o
shutdown
o
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 successful import to new client.
