Sandbox Refresh
Sandbox Refresh
Sandbox Refresh
1) Export of user master and authorizations from all SAP clients on the target
system (SCC8)
1. "SNBKO00045" for transporting cross-client data, if you have
selected this
Processing groups
AL11, SE03 and SM61
DIR_ATRA E:\usr\sap\SNB\DVEBMGS00\data
DIR_BINARY E:\usr\sap\SNB\DVEBMGS00\exe
DIR_CCMS E:\usr\sap\CCMS
DIR_CT_LOGGING E:\usr\sap\SNB\SYS\global
DIR_CT_RUN E:\usr\sap\SNB\SYS\exe\uc\NTAMD64
DIR_DATA E:\usr\sap\SNB\DVEBMGS00\data
DIR_EXECUTABLE E:\usr\sap\SNB\DVEBMGS00\exe
DIR_EXE_ROOT E:\usr\sap\SNB\SYS\exe
DIR_GEN E:\usr\sap\SNB\SYS\gen\dbg
DIR_GEN_ROOT E:\usr\sap\SNB\SYS\gen
DIR_GLOBAL E:\usr\sap\SNB\SYS\global
DIR_GRAPH_EXE E:\usr\sap\SNB\DVEBMGS00\exe
DIR_GRAPH_LIB E:\usr\sap\SNB\DVEBMGS00\exe
DIR_HOME E:\usr\sap\SNB\DVEBMGS00\work
DIR_INSTALL E:\usr\sap\SNB\SYS
DIR_INSTANCE E:\usr\sap\SNB\DVEBMGS00
DIR_LIBRARY E:\usr\sap\SNB\DVEBMGS00\exe
DIR_LOGGING E:\usr\sap\SNB\DVEBMGS00\log
DIR_MEMORY_INSPECTO
R E:\usr\sap\SNB\DVEBMGS00\data
DIR_PAGING E:\usr\sap\SNB\DVEBMGS00\data
DIR_PERF E:\usr\sap\PRFCLOG
DIR_PROFILE \\DC-VM-SNB\sapmnt\SNB\SYS\profile
DIR_PUT E:\usr\sap\put
DIR_RSYN E:\usr\sap\SNB\DVEBMGS00\exe
DIR_SAPHOSTAGENT C:\Program
DIR_SAPUSERS .
DIR_SORTTMP E:\usr\sap\SNB\DVEBMGS00\data
DIR_SOURCE E:\usr\sap\SNB\SYS\src
DIR_TEMP .
DIR_TRANS \\DC-VM-SNB\sapmnt\trans
EINVOICE_PR I:\usr\einv_res_pr
EINVOICE_UP I:\usr\einv_res_up
EINVOICE_UP D:\usr\einv_res_up
SBI_PR I:\usr\bnk_pr
SBI_UP I:\usr\bnk_up
SM61
SPAD
Operation modes (RZ03, RZ04 and SM63)
3. Refresh Activity
Make sure source and target have same database version with patchset.
Copy Backup, controlfiles and oraarch upto 5-10 min after control file creation to target system.
To create control file:
Initiate the restore with normal command brrestore –b (.fnd file name) –m all
Meanwhile let’s edit the control file and make it for our target system , and we will use this to create
a control file in our target system.
Delete all before “startup mount” & after “CHARACTER SET UTF8;” in control file. Please note that
there will be a command to create temporary tablespace and those command need to cut from control
file and paste in other notepad and we will use those commands to create temporary tablespace after
database becomes in read write mode.
Change
<source SID> to <target SID>
REUSE –> SET
NORESETLOGS –> RESETLOGS
Please also look into the directories of sap data files and logfiles and change if require like if
the target system has different directory.
Now save the Control File and we will use it after restoration.
Restoration has been completed.
Now we will restore the controlfile that we have edited and make for target.
The error was occurred because we forgot to delete the already existing controlfile.
So we delete the already existing control file and re-execute the control file creation command
Now the database is opened and ready for use but still we will check few parameters.
Now we will try to start the sap application and proceed for post activities.
Let’s login with sap and proceed with post tasks
We are able to login with production credentials means source data was completely there.
Execute SGEN
10) Remove entries from few listed tables using SE14 transaction
Table List
ALCONSEG
ALSYSTEMS
DBSNP
MONI
OSMON
PAHI
SDBAD
SDBAH
SDBAP
SDBAR
TPFET
TPFHT
TLOCK
SWNCMONI
SAPWLSERV
SWNCMONIINDEX
Execute SE14 and select tables and put the name in field and click on edit
Delete old SAP profiles and import new profiles using RZ10 transaction
Delete batch job logs by executing RSBTCDEL report using SE38 transaction
Delete Old spool requests by executing RSPO0041 report using SE38 transaction