UNIX/Oracle System Copy: Reloading data service
SAP Note Number 155418

Symptom

New installation service on UNIX/Oracle for Homogeneous/Heterogeneous System Copy

ATTENTION:

This procedure is only valid with an oracle database version >= 8.1*! It will NOT work with oracle 7.* or 8.0.*!

Other terms

DBRELOAD.R3S, DBRELOAD.TPL, DBRELOAD, R3SETUP, Homogeneous System Copy, Heterogeneous System Copy

Reason and Prerequisites

You want to load data from a system (e.g. your productive system) into the existing Oracle database of another system (e.g. your test system).

The DBRELOAD service will reinstall the target database while keeping the SAP settings. Data stored in the target database will be deleted. Then, data from the source database will be reloaded. DBRELOAD is not intended to add additional data (that is, merge data from two databases by keeping old data and adding new data). After the DBRELOAD procedure, only data from the source database will be left.

Although the DBRELOAD service is available for 3.1I SR1, it is not valid for all 3.x SAP R/3 systems released before (for example, 3.1I).

Solution

There has to be an existing Oracle database on the target system before you can use this service.

Follow the instructions in

• note 575308 (for oracle 8.1*) or

• note 557255 (for oracle 9.2*)

to get the necessary archives and the required CDs. Use the service DBRELOAD.R3S to copy only the data from one Oracle database to another.

To use this service, execute the following steps:

1. Export your source system and transfer the exported files to the target host according to the description in the Homogeneous or Heterogeneous System Copy Guide, section 'R3load Procedure on <your_platform>'.

2. Make a backup of the file init<SID>.ora located in $ORACLE_HOME/dbs to save any changes made to this file.

3. Delete all entries of the directories saparch and oraarch on your target system.

4. Set up an installation directory with 100 MB of free space available. Set the permissions of the installation directory to 777.

5. From your old instance, delete all data files located in your sapdata directories and all control files.

6. Set the shared library search path according to the do***entation.

7. Start the installation program R3SETUP with ./R3SETUP -f DBRELOAD.R3S
R3SETUP will reinstall the target database (old data files will be deleted) and reload data from the source database.

8. To save your database configuration, make sure that changes in the old init<SID>.ora (that you backed up in step 2) are also contained in the new init<SID>.ora that was created by R3SETUP.