cancel
Showing results for 
Search instead for 
Did you mean: 

Installing an "empty" instance

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Prince Jose,

thanks for your answer.

Do you know if it is essential to install an empty instance if I want to change the system-ID?

Regards,

Dirk

Former Member
0 Kudos

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: &#8220;CREATE CONTROLFILE REUSE SET DATABASE "<NEW SID>" RESETLOGS ARCHIVELOG&#8221; after this there is description of log files, data files until &#8220;;&#8221; sign.

After this all strings should be removed, as well as temp file generating (u&#8217;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 &#8220;CANCEL&#8221;

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

andreas_herzog
Active Contributor
0 Kudos

do not use the oracle installation tools to install a database instance...sapinst will do this for you!

GreetZ, AH

Answers (0)