on 10-07-2008 6:13 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.