REFRESH FROM BWP TO BWQ

[Former Member]

HI Experts.

We are in plan to do system refresh from BWP to BWQ soon.

Please helpme to complete this task sucessfully.

I need to know what are the steps to be taken care before and after system refresh from both SAP source and target side and also from Database (ORACLE) side.

Regards

Janakiram

[Former Member · Accepted solution]

System Copy using BACKUP of PRD server on Quality

Source u2013 BWP (Production)

Target - BWQ (Sandbox)

DB size of BWP -

DB Size of BWQ -

Take Full backups of both Servers (BWP & BWQ)

For safe side take Filesystem Backup & also Ignite Backup

Take backup of control file.

SQL> alter database backup controlfile to trace;

This created a .trc file in /oracle/BWP/saptrace/usertrace as BWP_ora_1234.trc

Copy this controlfile to BWQ

Edit it through vi editor, replace the name of BWP to BWQ through %s/BWP/BWQ/g ( this changes the sid of BWP to BWQ wherever presents)

Down the SAP & DB of target system (BWQ)

Delete whole datafiles in BWQ to free the space

Ie in /oracle/BWQ/sapdata1 u2026 N

/oracle/BWQ/oraarch

/oracle/BWQ/origlog & mirrlog

Now restore the backup through brtools,

Check the option in initBWQ.sap parameter for backup type, drive

Ie. /oracle/BWQ/102_64/dbs/initBWQ.sap

Login through orasid  brtools  5 Restore and recovery  5 - Restore of individual backup files  and following : http://help.sap.com/saphelp_nw70/helpdata/en/93/4ffb72309fb04e80ebfefae1b7a96f/content.htm

To create control file:

Goto SQL> @control.sql

This generates the control file

After generating control file we have to recover the database

SQL>Recover database using backup controlfile until cancel;

Alter TEMP tablespace

SQL> alter tablespace psaptemp add tempfile u2018/oracle/BWQ/sapdata1/temp_1/temp.data1u2019;

And also we need to create OPS$ user(as there is ops$BWPuser in backyup)

SQL> create user ops$BWQadm identifies externally default tablespace system temporary tablespace PSAPTEMP.

Also we have to rename SQL> alter database rename to global BWQ.GLOBAL

Also Follow:

http://www.scribd.com/doc/17398351/SAP-System-Copy-Homcopyv1

http://www.sap-basis-abap.com/bc/client-copy-from-production-to-quality-server-to.htm (in this link note of every steps are there)

[former_member287027]

I'm guessing from your SIDs that this might be a BI system.

In which case take a look at this guide for pre and post processing tasks

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/bff13df2-0c01-0010-6ba7-bc50346a6...

Regards

Garry

[Former Member]

Hi Janakiram,

Download the system copy guide you will find the steps.

Regards

Ashok Dalai

[Former Member]

Hi Ashok ,

Thanks for sharing this documents.

Janakiram

[Former Member]

Hi

We are in plan to do system refresh from BWP to BWQ soon

This doesn't help us to give you valuable suggestion need some more information about your

OS/Database/SAP version installed/is it Dual stack

Regards

Uday

[Former Member]

Hi ,

My OS:sun 5.0

DB:oracle 10 patch level 4

sap version:NW2004 only ABAP stack.

i think it will helpyou to guide me.

Regards

Janakiram

[sunny_pahuja2]

Hi,

Check SAP Note 970518 - Hom[1]. Het.System Copy SAP NetWeaver 7.0 2004s SR2.pdf

Thanks

Sunny