System data copy production server to Quality server

[#1]

Hi Expert,

i want to all production server data like all report , document ,end user entry and production data copy on quality server.

So how i can make it possible please help me step by step.

Thanks

Sjubh

[Former Member]

Hi,

You have to do a system copy of your production onto your quality box. There are two ways to do this. Either you can use the database specific tools for backup of prod and then restore on quality and change of SID for your specific database. The other method is to go throught he procedure of system copy using SAPINST. The guides for systemcopy are available on service marketplace and you can easily find them here.

Regards,

Shitij

[Former Member]

Hi Shitij,

As per your instruction ...........

can you also tell me thats which kind of backup (off line or online backup) i will be take from production system ?

and after that what types changes needs on own production database backup and how ?

Data base : DB2

O.S. : AIX

Regards,

Shubh

[Former Member]

Hi,

Any backup will do. Does not matter whether it was online or offline from prod. All depends on which of these is more suitable in terms of the data that you need. Ask your DBA to restore the DB from prod to Q and apply the logs if required.

I have done these restore of DB2/AIX systems in this manner, so I know that it definitely works. Here are the exact steps from my guide:

After the restore, you need to keep the system down and then you need to adjust the schema. Basically, lets say your Q system name is Q01 and prod system is P01. Then, the schema of your Q system db was SAPQ01 and that of prod was SAPP01. But now, after the restore, it would have become SAPP01 in Q also.

Login with db2<sid> user and execute the following command to see all the schemas in ur db:

db2 "SELECT SCHEMANAME FROM SYSCAT.SCHEMATA";

Here you will find a list that will contain the new schema name.

You don't have to change this schema (because dB2 does not allow this). Instead, there will be a user SAPQ01 (same as schemaname) on your OS. This is required to by DB2. Just copy the user and name it as SAPP01 (new schema name) and maintain same groups as SAPQ01.

Set the 'dbs_db6_schema' environment variable to the connect user for the <sid>adm and db2<sid> users. Change it to new schemaname in the following files in home directory of these users:

.dbenv_<hostname>.csh

.dbenv_<hostname>.sh

Next, run the command:

dscdb6up sapp01 <password for sapp01>

This will update the file '/usr/sap/Q01/SYS/global/dscdb6.conf' with details of new user.

The above steps are sufficient to startup your system. System copy is complete by following these steps. After this, you can do the other basic conversion steps like Logical Ssytem conversion using BDLS from prod to Q. You can also change logical ports, partner profiles in WE20, WE21, and also adjust new RFC connections from SM59 (or SECSTORE). Ets. Ets.

Regards,

Shitij

[Former Member]

hi shitji,

Thanks for guideline after the completion this activity i'll be inform you.

regards

Shubh

[Former Member]

Hi,

I would suggest you to restore the Productiion server database backup in Quality and change the SID accordingly and mount

Regards

D.Mukunthan

[Former Member]

There is no step to step document. Read system copy guide on SMP. You should do some search on SDN before posting here, there are so many threads for the same thing.

Thanks

Sunny