Production Data Restore in Quality Server

[former_member281396]

Hi all,

I want to restore our current production server data to our Quality Server.Our databse size of Production server is above 200GB so I am not able to go for Client Copy.Now I want to restore the production server back up data to quality server.Please write me the procedure how I proceed .Is there any other option to do the same thing?Please let me know.

Thanks & Regards

Nirmal

[former_member281396]

ok

[Former Member]

Hello,

They are two ways of system refresh

1) export/ Import method

2) backup/ restore method

As there is no space just forget export and import method.

so go for backup restore method.

1. just take offline backup of present production server.

2. restore the database files into your target system.

3. create a trace file of your control file in Production server with "Alter database backup controlfile to trace;"

4. after that change the SID in Trace file as Target system SID.

5. instead of REUSE "<SOURCE SYSTEM SID>" use SET "<TARGET SYSTEM SID>" with resetlogs in Trace file

6. delete the no resetlogs command in the trace file

7. rename trace file to target.sql

8. go to the target system go to command prompt and go to the path where you saved the target.sql file

sqlplus / as sysdba

@target.sql

this will create the control file of the target system

after that

alter database open resetlogs;

after this your database will be open with target system SID

Regards

Meharkiran

[Former Member]

Hi Nirmal,

Simple way export the client from Production and import to Quality.Your data 200GB then might be problem of space.

Solution - mount sapmnt to someother free directory and export.

SurendraJain

[former_member204746]

one more well-done doc is available at http://www.basisconsultant.com/component/remository/Sytem-Copy-Guides/Homogeneous-System-Copy-using-...andOffline-Backup/

you might need to register to be able to use the provided link.

[Former Member]

if u do not want to do client copy then copy the data restoring the backup. so first take the offline backup of ur production system and restore it . in both functionality u can use BRTOOLS .

or u can take backup only tablespace and restore it tablespacewise by brtools.

Thanks

Presu

[Former Member]

Hi Nirmal,

If you are not interested or if the hardware and the network will not allow you to do a remote client copy, you can go for the client export and import. this activity is much simpler than the system refresh or system copy.

The exported data will not occupy much space but it would require more downtime compared to the system refresh.

The prerequisite for doing the client export and import is that both the systems under question shpuld be at the same support pack level. The table structure of the target system must contain the structure of the source system. An RFC connectivity must be established for the remote comparision of the table structures.

Regards,

Varadhu

[Former Member]

Hi,

Check below links. It will help you

http://help.sap.com/erp2005_ehp_04/helpdata/DE/0d/d3076e4a0c11d182b80000e829fbfe/frameset.htm

Thanks,

Sushil

[anindya_bose]

Hi Nirmal

You just need to do system copy /.system refresh. Not very easy activity,so SAP provides some guides for that.

For different system you will find system copy guides. Search in SDN and www.service.sap.com/instguides

Check the below links

http://www.uphantis.com/16591/How-to-System-Copy-ABAP-and-JAVA.pdf

Edited by: Anindya Bose on Jul 28, 2009 4:41 PM