DB Pre-Refresh Activities Checklist

A sample checklist if you are conducting QAS refresh from PRD.   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.