cancel
Showing results for 
Search instead for 
Did you mean: 

System Refresh

Former Member
0 Kudos

Hi Gurus,

We have in place here a Q system and a P system. To each of these machines, a Communication station and an MAR are connected. Now, we are required to refresh the Q system with P system. Should the Comm Station and MAR of Q also be refreshed with their counterparts of P system?

Could anyone help me in this regard?

Thanks & Regards,

Savan D.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi savan,

see this also..........

What is the best way to refresh QA from PRD?

How to make a system copy:

1. Take offline backup of both the server (source and target servers)

2. Verify the backup is successfully done.

3. Run the following command on source system.

a. Login as <sid>adm

b. svrmgrl

c. connect internal

d. alter database backup controlfile to trace;

e. exit;

f. Above command will generate a .trc file in /oracle/P01/saptrance/usertrace directory.

g. Copy the text from CREATE CONTROLFILE until the ( and paste it in to any new .sql or controlfile.sql file.

h. Copy the controlfile.sql to target system.

i. Edit the file and replace the entire source SID to target SID.

j. Edit the reuse database command with the set database command

4. Copy the aft generated during the backup file from the source system to target system. (/oracle/<SID>/sapbackup)

a. Change all the source <SID> to target <SID>.

b. Only don't change the backup volume name it must be target system <SID>.

c. Copy the above aft file name line from the source back<SID>.log to target<SID>.log file.

5. Shutdown the target server instance.

6. From this onwards all the command on the target system only.

a. Login as <SID>adm

b. run the SAPDBA

c. select J (Restore/Recovery)

d. select B (Full restore and recovery)

e. select A (Select backup of type)

f. Select the offline backup which you want to restore.

g. It will take some time to restore.

h. Once the database is restored login as <SID>adm and run the

i. svrmgrl

j. connect internal;

k. startup nomount (if the database is already mounted shutdown it using the shutdown command)

l. run the following command

m. @controlfile.sql (file name of the control file contains the CREATE CONTROLFILE statement)

n. After the run the above command it should give the "Statement Processed)

o. alter database open resetlogs p. shutdown

q. Start the database and SAP services using startup.

7. After this you have to reconfigure the STMS.

8. All the jobs also you have to reconfigure and reschedule.

9. Reconfigure all the printers.

10. If you want to change the Client number then use the local copy tool and remove the original client after successfully import to new client.

thanks

karthik.

reward me if it is useful to you

Former Member
0 Kudos

WOW!! That was an exhaustive reply!!!

Thank you Karthik, for your SUPERB reply. I think this will definitely help us. Thanks a lot.

Edited by: Savan Kumar Dundoo on Apr 1, 2008 11:19 AM

Answers (2)

Answers (2)

Former Member
0 Kudos

hi savan kumar,

Before doing a client copy, you need to prepare the following :-

1. Find the source client space with the client size custom program which can be implemented using the rel. note:

V;A0W z Y%L[&R;T Z0 Find the space of the client - '0118823'. This will give you the size of the source client.

2. If your are on Unix OS, adjust all the file systems according to PRD file system to fit the PRD client in DEV ITPUB&#20010;&#20154;&#31354;&#38388;3G1?9G n O5\

client based on space requirements also.

3. You can do the client copy by remote or export/import client.

9\ V c l)W m D0 Remote method is not preferred if you are doing a large client copy.

!c N(Y l | I c C w0 Do a client export/import.

4. To speed up the export/import, use R3trans export/import for the clustered tables.

-N H8u-h F6}:W o0 Please find the rel. notes related to performance improvements for cluster tables in OSS.

5. Do import and post processing. ITPUB&#20010;&#20154;&#31354;&#38388; v5J q2FU

Note: Export may take 10 to 20 hr. for 50gb of data

y-y*l#R D H7^)C.b0 import may take 4 days and post import will take 8 to 15 hr. for 50gb of data. And it all depends on

,l9|:H V q!x#e&x0 your system performance.

Please refer OSS rel. notes for the fewRZ10parameters which needs to be set for cluster tables to speed up the process.

Note :-

If it is a fresh installation, do this --

1. SCC4--> Create client no. and fill other details.

X s2P+k l,P h02. Logon to the newly created client with SAP* and PASS as password.

%t { T1X s5[ AB@ b p03. SCCL--> choose any profile (preferably SAP_ALL), source client 000 and target client <as created just now>.

m }0t&r w X9~ J Q04. Preferably do a test run initially to check if it can go well.

1t,p A&J y3Q k ~05. As a care check space in databases.

What are step and procedure to create a client & to take a client copy from source to target.

By: Kavitha.G

If you are copying from same system then flow the below steps:

{ M I y%{ b4c0 ITPUB&#20010;&#20154;&#31354;&#38388; U*~ ~ \&i ^ Y l4I \

1. Create the client in Tcode scc4.ITPUB&#20010;&#20154;&#31354;&#38388; a u U t O

2. Before that create a logical System in BD54.

X*o0g i4d03. Login in the newly created client with

F ^ {3x3V h9? e(e0 user Name : sap* and password : pass

_ w&I#^ U _ B w Q04. Use the Tcode sccl to copy the client.if you are not familiar with the client copy. Try a test run and then schedule it in background.

D m-m U F P T05. You can select the needed profile.ITPUB&#20010;&#20154;&#31354;&#38388;%u({-W D Y'Y*] ]

6. To view the log files use the tcode scc3.

W o+F"u r0l B0 ITPUB&#20010;&#20154;&#31354;&#38388;'Q%e x d6E M

If you are using different system then create a rfc connection in sm59.test the connection and then continue from the 1st step

6e7s8L A l i)Y ~0You can also import and export a client. Use scc7 for importing from the client and scc8 fro exporting from the source client

What is system refresh when and why it is done?

The system refersh is nothing but the deletion of the client and replacing the data from other client. For example : you have clients 100, 200 and 300. Suppose when you want to refresh the client 100 you remove the client 100 and replace it with 200 0r 300 as per your reqiurement. Mostly the refresh of clients will be happen at the time of development stage.

System Refresh is a simplified term to Client Copy. Client Copy means copying the production client on to the quality to test the real data. As recommend by SAP this need to carried out every 3 months.

The process to carry out the same is as follows:

(_6H E D H N c:_6K0 1. Create a client on quality system using txn scc4ITPUB&#20010;&#20154;&#31354;&#38388; H(B G N3n8F y

2. Create a RFC between Production system and Quality System (need to create on quality system)ITPUB&#20010;&#20154;&#31354;&#38388;8z#M P L o;}9W V O Fj

3. Login to the newly created client using sap* and pass as a passwordITPUB&#20010;&#20154;&#31354;&#38388;7u S6h*N q6d L _&p$g

4. Txn sccl to start the client copy. You can test the client copy by selecting the test run option. (test run will estimate the time taken for the activity).

reward me points

if it helps you..............

thanks

karthik

Former Member
0 Kudos

Hi,

a refresh of the comm stations makes no sense at all because there is no CRM data (customizing, master & transactional data) stored.

Since after the copy of PROD CRM to QA the system name of QA CRM will be the same you not even need to adjust the RFC/XML destination on the QA comm station.

Regarding the MAR you need to check before the CRM system copy whether all Mobile changelists are released resp. imported in all systems e.g. that the ARS baseline is the same allover your landscape. Otherwise it might happen that the CLs in the ARS repository doesn't fit anymore to the CLs in the related CRM (table WBTRCL).

Also for the MAR there is no need to make a copy because of the same reason mentioned for the comm stations above.

But what you definitely need to check/correct afterwards is the registration of the ARS repository in the CRM system. Same is valid for the ARS transport service.

Regards,

Wolfhard