System Copy with Oracle

[Former Member]

Hi!

We would like to copy a Oracle DB from one SAP system to another SAP system.

After this we would like to delete a client from SAP system with Oracle commando

Questions:

1) How to install a SAP system with Oracle Backup and Restore?

2) What is the way to delete a client from SAP system with Oracle commando?

As I know the commando "delete * from SAPR3.<sid> where mandt='200'" will be delete the first 100 entries.

Thank you very much!

[Former Member]

You may want to check homogeneous system copy guide for oracle database specific methods. Here you can use ORABRCOPY tool which is part of installation master to generate control.SQL, control.trc etc.

[Former Member]

Hi, are you changing the SID of the system?

Mark

[sunny_pahuja2]

Hi,

> 1) How to install a SAP system with Oracle Backup and Restore?

You can install it via homogeneous system copy. Check SAP Note 870863 - Hom./Het.System Copy SAP NetWeaver 2004s. Also check system copy guide.

> 2) What is the way to delete a client from SAP system with Oracle commando?

As stated earlier, it is easy to delete client from SCC5 then manually by sql statements. Check SAP Note 70643 - CC-TOPIC: Client Deletion (SCC5).

Thanks

Sunny

[former_member204746]

answers:

1) read the homogeneous system copy guide. Basically, you install SAP and Oracle and restore your DB.

2) you must delete contents from every table containing field MANDT when its value is 200. So, this means thousand of SQL commands. better use SCC5 from SAP level. After this, it is a good idea to reorg your database as per SAP note 646681.