Homogeneous System Copy on Windows Oracle10.2 with dual stack system

[Former Member]

Dear Friends,

I have solution Manager with EHP1 on Oracle 10.2 & windows Operating system. I have to move this solution manager instance to fresh server with same database & operating system.

To achieve this I think have to perform homogeneous system copy.Previosly I have performed system copy on different database but not sure about oracle procedure.

1. Build system on window 2003 server with SP2

2. Install Oracle 10.2 on target server

3. Run export on source system using Sapinst.

4. Copy exported file on target system.

5. Import exported file on target system using sapinst

I am new to oracle database. I need to know steps to perform system copy on Oracle windows environment with Backup u2013restore method.I am keen to know how to perform Oracle backup & then restore on windows environment.

Regards

Manoj

[carlos_zhang3]

Hi Manojkumar12 ,

If you are using Backup / Restore way , please follow below step :

1. Backup data to tape or disk from source system .

2. Install a new SAP system with same database layout ( it doesn't matter if you want to use different SID ) .

3. Restore the data to your target system ( overwrite the datafile ) .

(

Here you need to rebuild the control file

control file you can dump from your source system ....

)

4. Change the OPS$ user ( notes 400241 ) .

5. Test oracle connection by R3trans.exe -x command .

In addition you can use this way for different DB version between source and target system :

1. download the last sapinst program .

2. run sapinst program on your source system ( remember backup the system and also update the r3szchk files )

3. export abap contents by sapinst on your source system ( update oracle statictis will improve the performance ) .

4. copy abap contents files to target system .

5. execute sapinst on your target system and import the abap contents .

Hope it useful for you . Let me know if you need more information .

Best Regards,

Carlos

[former_member204746]

are you changing the SID?

if not, use this strategy:

1. Build system on window 2003 server with SP2

2. Install Oracle 10.2 on target server

3. install SAP but stop at the database load step

4. stop SAP and database on source

5. copy SAP kernel and your Oracle database to new machine

6. adapt SAP profiles to new server name

7. start Oracle

8. start SAP

9. from the homogeneous system copy guide, go through post-processing steps.

[Former Member]

Hello Manoj

What is your update? Have you tried?

Will you able to perform system copy?

Thanks&Regards

Uday

[Former Member]

Hi,

You can follow the installation guide available in http://service.sap.com/instguides

1. Build system on window 2003 server with SP2

2. Install Oracle 10.2 on target server

-> 2.1 Install oracle patch 10.2.0.4.0

3. Run export on source system using Sapinst.

4. Copy exported file on target system.

5. Import exported file on target system using sapinst

6. Carry out the post import/installation activities as per the the system copy guide.

Regards,

Varadharajan M

[Former Member]

Hi Manoj,

Procedure is as follows

1. Data and Log directories on target system must be cleaned before restoring source database.

Login as <targetsid>adm

Stop SAP system and all services related to SAP and Oracle.

2. You have to resize the oracle file systems before restore process.

3. After cleaning necessary file systems/directories, you have to restore most current database

backup to target system.

4. After restoring datafiles and redolog files, a scripts must be prepared on source system to create

CONTROLFILE of target system. For this you have 2 option.

1. svrmgrl

SVRMGR> connect internal

SVRMGR> alter database backup controlfile to trace;

SVRMGR> exit

As a result of this command, a trace file will be created under

/oracle/<SSID>/saptace/usertrace directory.

Rename <SSID> as <TSID> in .trc file

5. After CONTROL.SQL script preparation, following commands must be run to create

CONTROLFILE of target system:

1. svrmgrl

SVRMGR> connect internal

SVRMGR> @/<path_to_file>/control.sql

You have to guarantee the successful completion of this command as follow:

SVRMGR> @control.sql

Statement processed.

SVRMGR>

6. Database will be in inconsistent status after creation of CONTROLFILE. This can be viewed by

trying to open the database.

SVRMGR> alter database open;

alter database open

7.SVRMGR> recover database using backup controlfile until cancel;

SVRMGR> recover database using backup controlfile;

8.Start the oracle listener and SAP system

I hope it helps

Thanks&Regards

Uday

[Former Member]

Hi Manoj,

You no need to worry, i will give you step-by-step procedure.

I. Prerequisites

Following conditions must be provided to copy a system:

- Both Source and Target Systems must have Same Operating System and Database System. Also

- Patch levels must be same.

- You have sufficient free space for sapdata directories on target system.

- For Windows systems, you have to create all drives where datafiles resides on source system.

- Use most current database backup in order to shorten database creation time.

II. Preparations on Target System:-

Restore Online/Offline Backup of Source System onto Target System.

Create CONTROLFILE creation script on Source System.

Modification of CONTROLFILE script and creation of CONTROLFILEs of Target System.

Recovery of Oracle Database on Target System.

Completion of System Copy