cancel
Showing results for 
Search instead for 
Did you mean: 

Restoring SAP Portal database on test server with different SID and hostname

Former Member
0 Kudos

Hi

We want to restore SAP NetWeaver portal production database on the test server with different SID and hostname on same network. For example in production we have sid as PEP. DB SID is also PEP. We have got a test Portal server (SID = TEP)  in which SAP NW As Java (usage types EP, EP Core, BI Java and AS Java ) is installed. Now we want to restore SAP NW Portal prodcution database on Test server with test server SID which is TEP. We have already created offline backup for production portal database. I know it is possible with same SID but can we restore production portal database on test server with different SID and hostname?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Take a DB Backup and a J2EE export from source using sapinst. in the target system restore the database and run sapinst with options Lifecycle Options--> System copy--Java system installation, provide path to the Java export when the installation asks. IT should be pretty smooth. What is your OS/DB?

Yogesh

Former Member
0 Kudos

Thanks Reagan Benjamin and

Former Member
0 Kudos

That wont work.How SAP Java works is that it has Java content files at the OS level which are synced up with contents. Whenever you reinstall the system, this link is cleaned up and re-established. Your existing Java system in the test box has that sync with the existing database, if you overwrite that DB from production, that link will be broken and Java most likely wont start.

so in case of Java, you would need to take a backup and export. That is the reason a Java export should be taken everytime you take a backup for system copy. Also Java export should be part of your backup strategy in production to be able to recover from disasters.

Former Member
0 Kudos

Hi

Former Member
0 Kudos

Here are the steps one by one.

Assumption is that your test system is a central System and Production is HA

- Take DB Backup from Prod. Take Java export from prod using Sapinst-->Software LifeCycle Options->System Copy->Oracle-->Source System Export-->HA System->Based on AS Java-->Central Instance Export.

- Copy Backup and Export onto the Test system

- Uninstall Java instance on Dev Instance, Delete Database(if you want to use the old SID)

- Restore Database Backup

- Perform System copy step using

Sapinst-->Software LifeCycle Options->System Copy->Oracle-->Target System Installation-->Central System->Based on AS Java-->Central System

Make sure to use relevant Netweaver DVD of your release and DB system.

Make  sure your DB/OS version on production .and test system is same.

the steps are clearly provided in the System copy guide for netweaver in marketplace.

let me know if you hit any snags.

Answers (2)

Answers (2)

Reagan
Advisor
Advisor
0 Kudos

Hello

Unfortunately the restore wont help in your case as it is a Java stack and the SID is changing.

You need to do an export and import of the Java schema.

Cheers

RB