Migrate an Oracle Database off the Application server

[Former Member]

Hello all,

     Currently we have our Oracle database and the SAP Application installed on one server.

     However we would like to split this server in to 2 and have one for the application and one for just the oracle database.

     Is this just a matter of Picking up the Oracle datafiles and copying them to the new server ( same OS same Oracle version ) and changing the TNS of the Oracle client on the old server to point at the new one?

Cheers Mark :^)

[Former Member]

Hi MArk,

You can do the same as below.

1. Take full offline backup of existing system .

2. Create same file system of Database on new server like

    /oracle

   /oracle/<SID>/sapdata1......

   /oracle/<SID>/origlogA and B....

  all the oracle file system.

3. Now restore the backup taken from old server.

4. restore the /home directory of user ORA<SID>

5. Keep oracle client directory on your CI system which is existing server.

6. Share dir /usr/sap/trans and /sapmnt/<SID>

7. change db hostname in lisner and sap profiles.

this may help you.

Regards

Ganesh Datt Tiwari

[former_member188883]

Hi Mark,

You may need to follow the steps as mentioned below

1) Take a full offline backup of existing instance.

2) Shutdown the database on existing server. Install DB instance on new server using sapinst.

3) Re-install CI instance or app server on old server so that i had references to this new database server.

4) Delete the old instance of SAP.

Regards,

Deepak Kori

[Former Member]

Hi Mark,

     You can perform as per Deepak Kori's suggestion or as follows:

1.Take a complete backup of the system

2 Take an export of the existing system.

3.Use distributed option in the SAPINST and install CI in one server and Database Instance in the other server.

Since the DB is of same version and OS as well you can even use backup/restore method in the SAPINST. Please refer the system copy guide for more information.

This is one of the safe method .

Thanks and Regards,

Vimal