cancel
Showing results for 
Search instead for 
Did you mean: 

Database Refresh Query

Former Member
0 Kudos

Hi,

A Very Happy New Year to all !!

We want to refresh our Test system database with Production data.

ECC 6.0 ABAP + JAVA system.

We will be using Backup-Restore method (BRTOOLS) for the same.

However, the problem is, our Production schema for ABAP and JAVA are SAPMI3 and SAPMI3DB resp. and that for Test are SAPMI2 and SAPMI2DB.

After the database refresh, the schema of Test server will be changed to that of Producion.

We can make the necessary changes for ABAP schema (ops$), however, would like to know, what changes (If any) are to be made for Java schema.

Request your suggetions.

Regards,

Kiran Pol

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kiran

The JAVA schema can be set in the configtool -> secure store -> jdbc/pool/<SID>/User

However i am not fully sure, if you have to change it, i think the information is stored in the database already, so it will be already fine when you do a backup/restore.

Do the test and prod system have the same instance numbers? Otherwise you will have the additional struggle with the ports. For example the dispatchers http/https ports.

Don't forget to change the sidadm env variable dbs_ora_schema as well.

Best regards, Michael

Answers (0)