Pre-Refresh Activities for our company.
Use it as you see fit as every company is unique.
1. The backup of PRD that will be used for STG refresh should be taken in barcode (in our case) tape.
Use the parameter file initPRD.sap_bartape ( in our case).
2. Take dump of following tables from SE16
AGR_DEFINE
AGR_USERS
DBCON
RFCDES
3. Mass Download of all Roles.
PFCG -> Mass Download
4. Take Dump of following oracle tables
DBA_USERS
DBA_DB_LINKS
5. Download all SAP user-ids with their status (LOCKED or UNLOCKED) via SU10 or SUIM
6. Find the extra oracle datafiles that has been added in PRD since last refresh.
7. Create the oracle datafile path in STG for those datafiles that were added in PRD since last refresh.
8. Fall-back of STG is last week’s online consistent backup + Archive logs.
9. Take Archive log backup of STG - Ensure all logs since last backup is available.
10. Keep Copy of STG Control & Online Redo-Log Files.
11. Stop R/3 and DB in STG. Stop Listener. Ensure no sap
and oracle processes are running.
- SAP Database Startup
and Shutdown
12. Restart DB in RESTRICT mode.
13. Execute DROP DATABASE.
14. Connect Barcode Tape Library (of PRD backup) to STG (in our case).
15. Restore PRD-Online Consistent backup from tape to STG.
16. After backup is successful, keep the required archives in STG under /oracle/PRD/saparch
Note :- The required archives can be found by referring to the online-consistent backup of PRD.
17. STARTUP MOUNT
18. Recover STG.
(RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE)
19. Apply archive logs individually. Press CANCEL after the last required archive has been applied.
20. Execute "ALTER DATABSE OPEN RESETLOGS"
21. Install SAP License.
22. "Assign Server" in SPAD
23. Break the RFC Connections by executing following script from SQL*Plus
update rfcdes set rfcoptions = REPLACE(RFCOPTIONS,'N=','N=#') where rfctype= 'T';
update rfcdes set rfcoptions = REPLACE(RFCOPTIONS,'H=','H=#') where rfctype= '3';
24. Restore the LOCK or UNLOCK status of SAP user-ids.
25. RZ10 -> Utilities -> Import Profiles -> of active servers
26. Assign the roles to user as per the dump taken in Step 3.
27. Verify the status of Oracle user-ids as per dump taken in Step 4.
28. Refer the DBCON entries taken in Step 2 and change them, if required.
