cancel
Showing results for 
Search instead for 
Did you mean: 

restore oracle DB from different SAP server

Former Member
0 Kudos

Hi Experts,

Our SAP PROD Server is down at the moment, we would like to restore the backup DB from QA server. Its a temporary solution for the users to transact. My issues are:

1. How to restore a DB from a cluster prod server to a central instance server (different in directory structure)?

2. Is it also possible that when we need the new DB from QAS it can be restored again to PROD cluster server (different in directory structure)?

Server Specs

1. windows 2003

2. oracle 10.2G

3. SAP ECC6.

Thank you in advance.

Joel

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Couple of things, 1st certainly its not advisable to restore the QA system content into PROD environment. because...PROD contains the latest transactional data rather QA box.

2ndly...YES it's possible in general case to restore from non-cluster system data into cluster system. but procedure is very long and require complete database knowledge. I can hellp you but it will be beyond the scope of this forum post (content wise)

3rdly, If you have DR (disaster recory) system try to active the DR or

The best alternative menthod...that i would prefer is ...recover your PROD system at the earliest and I hope you have all that backups of datafiles, archivelogs ready for to recover the system.

I hope this suggestions will help you.

Regards

Sekhar

Former Member
0 Kudos
Our SAP PROD Server is down at the moment, we would like to restore the backup DB from QA server. Its a temporary solution for the users to transact.

I would not restore anything from QAS or any other system to SAP PROD system. You will loose data from PROD if you restore QA if they are not in the sync (usually the case). Isn't it? Rather I would figure out the problem on PROD and fix it.