Import without SAPinst

[Ganimede-Dignan]

Hi,

we would like to copy our BW (a NW 7.0 system on Oracle) from production to test as export/import method because we also need a db reorganization (in production we have delete several records). So in test system we would like only to delete database (so we leave sap bin file, rdbms bin file, ecc.). If we use SAPinst as system copy SAPinst woluld install the system from scratch... so is it possibile create database and load/import data? without a complete re-installation?

Regards.

[markus_doehr2 · Accepted solution]

> we would like to copy our BW (a NW 7.0 system on Oracle) from production to test as export/import method because we also need a db reorganization (in production we have delete several records). So in test system we would like only to delete database (so we leave sap bin file, rdbms bin file, ecc.). If we use SAPinst as system copy SAPinst woluld install the system from scratch... so is it possibile create database and load/import data? without a complete re-installation?

Not in an "easy" way.

To preserve all your settings try the following:

- rename /usr/sap/<SID> to something else

- delete the target database and copy the database configuration to a safe place ($ORACLE_HOME/dbs/*, listener.ora, sqlnet.ora etc.)

- start sapinst and select to "start migration monitor manually"

- go on with the copy until sapinst stops and requests you to set up the migration monitor

- now rename the "new" /usr/sap/<SID> to something else and rename back your old /usr/sap/<SID>

- put back the init<SID>.ora, listener.ora and sqlnet.ora

- restart the database

- now configure the migration monitor and start the import

Markus

[Former Member · Accepted solution]

Hi,

you can do in manual way using R3tools (R3load, R3ldctl, R3check...) instead of doing using sapint.

You can do both export and import of the database manually using r3tools. Fist timer need to do an iteration on a test system to get the comfort level. Help for executing every command is available with viz. R3load -h.

thanks