SAP Test system refresh activity

Wednesday, October 7, 200922comments

SAP Test system refresh activity.

Follow the below steps for SAP test system refresh activity from Production server backup.


1. Take the relevant screenshot of system
STMS,SCC4,SM59,SAP standard jobs,DB13,SLICENSE,CCMS settings,SPAD

2. Import the SPAD settings

3. Take the offline backup of production system

4. Take the backup of backSID.log,*.aft and initSID.ora of production and test server

5. Lock users in Test system

6. Take offline backup of test system

7. Open client in test server : SCC4

8. Export the client for profile SAP_USER in test server. Keep test system as target server
SCC8


9. Take the trace of control file on both the Test and production server

10. Stop the SAP instance and sap services

11. Note down the Schema users existing presently in the system.
SQL> select user name from dba_users;


12. Shutdown the database

13. Copy last offline backup log file(*.aft) from production system to test server

14. edit the *.aft log file as per test server
change SID from prdoduction to test server SID, check ORA-HOME directory

15. Now restore the backup
brrestore –c –m full –b XXX.aft

16. Connect to oracle as sqlplus /nolog, connect /as sysdba and type startup Nomount.

17. Edit the controlfile of Prod. Change all production SID to test SID and NORESETLOGS TO RESETLOGS.

17. Use the edited controlfile of Prod to recreate the control file of Test
SQL> @Cntrl.sql
SQL>shutdown immediate;

18. SQL> Alter database open RESETLOGS.

19. Create new OPS$ADM using the below command.
I:\scripts>sqlplus /nolog @ORADBUSER.sql SAPSID NT DOMAIN SID (IF SIDADM is local user then give the host name in the place of Domain Name)

20. After this run the script sapdba_role to set proper right for OPS$ user IDs.
>sqlplus /nolog @sapdba_role.sql

21. Check whether SAPSR3P (schema owner) account has been locked or not:
select username,account_status from dba_users where username=”SAPPCE”;

22. If it is locked use this command to unlock it:
alter user SAPPCE account unlock;

23. Start the SAP application.


POST Processing Steps:

24. Update the license
Logon to SAP with DDIC-client 000; update the license key through the transaction SLICENSE.

25. check the consistency
Go to transaction SICK for checking the consistency of the system.

26. check the local host entry
Go to transaction SE37 and execute BPT_LOCAL_HOSTNAME_CHECK to check for the hostname entry.

27. Change the STMS configuration and perform post installation activity
Now go to transaction SE06 to perform post installation activities

28. Reconfiguring STMS

29. Login into DCE client 000 with DDIC , goto transaction STMS.

30. Schedule the standard jobs

Go to transaction SM36 and click on the button “Standard jobs” to schedule the standard jobs defined for the system.

31. Import the user master of test server
Goto the STMS and import the user master request

32. Close the client

33. Changing the client description.

34. Import profiles of active Server using RZ10.

35. Delete incorrect instances defined in RZ04, create correct instances and assign Operation modes for the same

36. Change the logical system name

37. Take an OFFLINE backup of the Test system and release the system to the users.


Share this article :

+ comments + 22 comments

April 2, 2010 at 1:22 AM

thank you for you to make me learn more,thank you∩0∩ ........................................

November 18, 2013 at 4:52 AM

This is such a nice post I'am a new user in SAP industry and I'am looking for these types of tutorial for gain in my knowledge about SAP. Thank you so much for sharing such a nice post.

Arthur Lawrence provides SAP Services and SAP Consulting all around the Globe.

June 27, 2015 at 5:09 AM

Thanks for posting this..

Real time SAP ABAP training

May 4, 2016 at 11:32 PM

Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai

June 20, 2016 at 5:48 AM

Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP

June 21, 2016 at 5:56 AM

Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP

July 8, 2016 at 4:13 AM

Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP

December 5, 2016 at 3:28 AM

SAP MM,SD, real Time Training in Chennai
We provides Best SAP MM,SD Training in Chennai wih real time project assistance by our leading Materail Management Consultant.
For Free Live Demo @ Call to 8122241286.
www.thecreatingexperts.com
SAP MM
SAP SD

January 14, 2017 at 7:32 AM

Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about SAP BASIS.
Call us at 8122241286.
SAP basis

January 20, 2017 at 9:49 PM

Ad 7 SAP BASIS
It was very nice blog to learn about SAP BASIS. Thanks for sharing
We provides Best SAP BASIS. Training in Chennai with real time project assistance by our leading SAP BASIS. Consultant.
For Free Live Demo @ Call to 8122241286.
SAP MM, SAP SD, SAP HR,SAP FICO 
www.thecreatingexperts.com 
.SAP basis

June 29, 2017 at 6:34 AM

The Creating Experts is the leading trainer in SAP BASIS so, if you are looking for one here is the link

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact +91-08122241286

July 2, 2017 at 10:38 PM

SAP BASIS training is provided in CHENNAI.

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 11, 2017 at 11:56 PM

SAP BASIS Training in Chennai is provided by

THE CREATING EXPERTS they provide hands on training with real time scenarios

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info

July 14, 2017 at 5:50 AM

Nice blog....For a long time I was looking for SAP BASIS training in Chennai and got the link


THE CREATING EXPERTS is providing SAP BASIS training in real time

http://thecreatingexperts.com/sap-basis-training-in-chennai/

Contact 8122241286

July 15, 2017 at 4:02 AM

SAP BASIS training is provided in CHENNAI.I personally got trained with them one of the best trainers in CHENNAI

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 21, 2017 at 1:23 AM

Informative post...for a long time I was searching for a trainer in Chennai

And i landed with THE CREATING EXPERTS one of the leading trainer with real time training in Chennai

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

July 22, 2017 at 1:50 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 22, 2017 at 5:53 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 24, 2017 at 2:27 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 27, 2017 at 7:22 AM

SAP basis training by THE CREATING EXPERTS

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

If you are looking for SAP basis here is a real time trainer to get trained from.

July 30, 2017 at 2:00 AM

The Information you provided is very much useful for SAP Learners. This Information was very Interesting,

SAP training in Chennai by THE CREATING EXPERTS for SAP BASIS, take a look at the link below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

July 31, 2017 at 9:43 AM

NICE BLOG...SAP basis training in CHENNAI provided by THE CREATING EXPERTS

http://thecreatingexperts.com/sap-basis-training-in-chennai/

CONTACT 8122241286.

Post a Comment
 
Support : Basis SAP | Basis SAP | Basis SAP
Copyright © 2011. Basis SAP - All Rights Reserved
Template Created by Basis SAP Published by Basis SAP
Proudly powered by Blogger