on 02-14-2008 6:58 PM
Hi experts,
we have a SystemCopy of a SAP Netweaver System and want to create a new system (with new SID). Do you know any corresponding SAP notes?
My opinion is, we need to install an Oracle instance without datafiles first and then import the SystemCopy - do you know if there is the possibility of using an response file?
Kind regards,
Dirk
Download the homogeneous or heterogeneous copy document from
http://service.sap.com/instguides --> SAP NetWeaver --> SAP NetWeaver 7.0 (2004s) --> Installation
Also read note 970518 .
Basically create the filesystems like your source system , and Install a new system using NW installation master DVD. In between it ask you to install the database . If you have a backup of sourse system , you can restore that to target ( if u r using DB specific system copy procedure ) .
SAP document pretty good .
Thanks
Prince Jose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dirk,
if u are going to change the SID of SAP system u surely must install the new oracle instance of the same version as the source system.
We usually have the following scenario of making a copy of SAP system (with the SID change). This scenarios also refer to the oracle's recommended warm db copy.
prerequisite: your source system should be in the archived mode.
1. install oracle instance, making all file system for sapdata like on a source system, making ora<sid> users, <sid>adm as well as its profiles.
2. install the oracle instance without data.
3. executing "alter tablespace <tablespace_name> begin backup" for all tablespaces excluding temp.. on a source SAP system
4. copy of all datafiles from source host to the destination folders... via os utils like cp...
5. after copy successfully completed. execute "alter tablespace <tablespace_name> end backup" for all tablespaces excluding temp.. on a source SAP system.
6 executing "alter system switch logfile" to write into logs the remains of cache, and write down the name of the archived log being generated after this statement . . on a source SAP system
7. copy of logs: begins with the log generated just before "begin backup" to the log u have write down on the step 6.
8. on a source system: "alter database backup controlfile to trace". After that the script was generated in the default usertrace directory. You should copy this file to the destination host, and edit It according to your new sap system. Change sid, maybe folders. In this script the header line should like this: “CREATE CONTROLFILE REUSE SET DATABASE "<NEW SID>" RESETLOGS ARCHIVELOG” after this there is description of log files, data files until “;” sign.
After this all strings should be removed, as well as temp file generating (u’ll make them later).
9. on the destination host: startup nomount;
10. on the destination host: executing script, prepared on the step 8, smth like this: @sciptname.sql. Database in mount status.
11. on the destination host: recover database until cancel using backup controlfile
12. on the destination host: apply all logs until one, you have got on the step 6. Apply this file, and write “CANCEL”
13. on the destination host: alter database open resetlogs.
U have the clone of oracle part of sap source system.
As for the sap part: we usually recreates all folders, with corresponding permissions, copy binaries and others necessary file to the destination hosts.
Regards,
Vladimir
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.