cancel
Showing results for 
Search instead for 
Did you mean: 

dbrefresh procedure

Former Member
0 Kudos

hi experts,

i have to perform DB REFRESH in my project.i will b gr8ful if any one can tell me the procedure any issues during db refresh.

database is oracle.in which cases we have to perform db refresh.

suitable answers will be rewarded.

thanks n regards,

shekar

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

you need to follow the homogenenous system copy guide from http://service.sap.com/systemcopy

This will explain every step you must go through for a successful refresh.

good luck.

Former Member
0 Kudos

Hi,

System refresh means only the database is loaded/copied with the content of a database of a different system. Normally all do a system refresh ( Copy prod to QA) to ensure that user/developers have up to date/recent data for testing. In normal practice most of people do refresh of QA with prod monthly once (varies from Business to Business).

Before you do a system refresh dont forget to take the screenshot/backup of important files, tables of QA system.(here assuming you are refreshing QA with prod)

Can you tell the SAP version for which you will be doing system refresh. if you are doing system refresh of SAPNW2004s the SAP recommends to do with sapinst

Please goto link

http://help.sap.com/erp2005_ehp_03/helpdata/EN/a2/2f0c173a5e43d19585724239ff4de7/frameset.htm

also refer Homogeneous system guide from link http://service.sap.com/systemcopy & follow the document.

Also Please note that if you are doing refresh of Dev from prod system then you need see SAP note before you start the refresh SAP Note 130906 - How can versions be transported?

Hope this help.

Thanks,

Sushil

Answers (1)

Answers (1)

debasissahoo
Active Contributor
0 Kudos

Hi Chandra,

I hope you've only ABAP system. If you're JAVA then its recommended to use sapinst i.e r3load method.

XXX - source system

YYY - target system.

Execute a user master export of YYY productive client. <nnn>

all the remaining steps will be on the target system.

Copy initXXX.sap, initXXX.ora, initXXX.dba, initXXX.utl(if tsm is used) files from XXX

Copy backup and archive logs files from XXX

Stop SAP (CI & APP)

Stop Oracle Services.

Stop SAP Services

Remove files, Rename directories

Restore the database

Restore the archive logs

Start Oracle Service for XXX

Execute u2018Point in Time recovery

Create trace file

Adjust the initYYY.ora file (if required)

Edit the trace file to create control.sql

Stop Oracle Service for XXX

Rename Directories

Start Oracle Service for YYY

Rename and start DB with new name of yyy sytem

Add tempfiles to PSAPTEMP

Depending on the system type you use, you've to follow the post refresh activity.

for oracle database guide, follow this,

http://help.sap.com/saphelp_nwpi71/helpdata/en/0b/5daf09b03344ad97338f838e09b9ee/frameset.htm

Thanks,

Debasis.