QAS Refresh from PRD

[Former Member]

Dear Bhudev/Guest,

I am Planning to refresh my Quality system from Production's Offline Database Backup. I have seen you a lot posts.

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Refresh from Offline backup (AQC from APC)

Let's say AQC is quality and APC is production.

Pre-processing Activity:

Verifications:

1. Verify the last offline backup in the source system /oracle//sapbackup/back.log

2. Verify that both the source and target systems are at the same Oracle level (which is already the case between APC and AQC)

3. It is recommended that an off-line backup be taken of the target system before starting this process, in case of fall back.

4. Confirm there is enough space in the target (AQC) file systems to contain the data from the source system this is required as we may have to copy the files from Production to quality. /oracle/SID/sapdata* folders should be having little more space as compared to the source filesystem.

5. Check access to SAP* for APC (000 and 400) and also for AQC (000 and 400)

6. Check other passwords such as adm and ora

7. Server : User : ora > sqlplus u201C/ as sysdbau201D > alter database backup controlfile to trace > exit In /oracle/SID/saptrace/usertrace, the last trace (check the time) is the script for recreating the control file. You will need to edit it. Please rename the trace file to ld.sql and send the file to the target system /oracle/SID Edit the Script: vi ld.sql Delete or comment out all lines at the beginning of the file before STARTUP NOMOUNT which is kept. Change old controlfile creation statement at the beginnig of the controlfile: Old line: create controlfile reuse database NOresetlogs archivelog; change to New line: create controlfile set database resetlogs archivelog; replace all occurences of string by in each line where appears :g / / s / / /g example: :g/P10/s/P10/T21/g Delete the following lines a the end of the script: ; RECOVER DATABASE; ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN;

8. Get from the Prod system (APC) the .aff and backDPR.log and copy them on AQC. (/oracle//sapbackup) Copy the files to /instkits/SID/. And after we can go on target source server and copy them from /instkits/SID to the /oracle/SID/sapbackup/. With the good owner and permission

9. Lock all the users in client 400 except Basis and post system message. Target system data collection (On AQC -400):

1. SM59 Expand all the trees, print by choosing: ->System ->List ->Print i) Compare list to R/3 connections on source system. Record details for any that will need to be recreated on target system.

2. SCC4 Record all client settings. -> Tableview ->Print ->Standard List -> List -> Print Make sure you understand the columnsu2026

3. SE06 Record system change options

4. RZ10 Record the instance profile settings for: rdisp/wp-no-btc and rdisp/max_wprun_time

5. STMS Record current transport routes. ->Overview -> Transport Routes -> manually expand all trees -> system ->list ->print

6. Request customer to provide u201Ccatch-upu201D list of transports to be applied to system after refresh (QA and Sandbox systems).

7. RZ04 Record current work process set-up. Highlight each operation mode and click instances/op modes button. i) Print with ->System ->List ->Print

8. SAP License Ensure the SAP license information is available. If not on-hand, logon target system as adm and enter command: saplicense u2013show. This information is also available on OSS.

9. TSM Nodename View /usr/tivoli/tsm/client/api/bin64/dsm.sys on source and target system. Record the nodename entries. These will be SAP or server names.

11. Take printer Export through SPAD and save it locally to desktop->SPAD

12. Take Export of User Master from the client 400 through SCC8 target system is AQC , so that it may be re-imported through STMS. Note the Transport number here also verify the transport exist in the queue. DB Restore from offline backup from APC:

1. Stop SAP on AQC -> Login as aqcadm -> stopsap

2. Change the TSM node on AQC-> cd /usr/tivoli/tsm/client/api/bin64 ls -lrt vi /usr/tivoli/tsm/client/api/bin64/dsm.sys Change it to point to APC, comment the AQC Node. Post Restore Acitivity:

1. Stop Database Delete Old controlfile rm /oracle/AQC/sapdata1/system_1/cntrl/* rm /oracle/AQC/saparch/cntrl/* rm /oracle/AQC/origlogA/cntrl/*

2. Re-create the controlfile and then after that start the database User : ora > cd > sqlplus u201C/ as sysdbau201D > @ld.sql > alter database open resetlogs;

3. Change the sapr3 password Server : User : ora Temporarily, we have to change the sapr3 password to the default password. With SAPBA, change this user password to pass.

4. Test the connection: Server : User : adm > R3trans u2013d It should have a return code of 0000

5. Reasign tempfile alter tablespace psaptemp add tempfile '/oracle/AQC/sapdata1/temp_1/temp.data1' size 6020M reuse autoextend on next 20971520 maxsize 10000M; alter database rename global_name to AQC.WORLD; drop user OPS$APCADM cascade; drop user OPS$ORAAPC; create user OPS$ORAAQC identified externally default tablespace psapdnausr temporary tablespace psaptemp; grant connect, unlimited tablespace, SAPDBA to OPS$ORAAQC; grant connect, unlimited tablespace, SAPDBA to OPS$AQCADM;

7. Change the instance profile to stop all the background processing To be sure that no production batch are executing, set rdisp/wp_no_btc to 0 posprocessing:

8. Startsap

9. Run Transaction SICK (as sap*)

10. Installing license through the tcode: slicense While logged in as 000/sap/using password of APC system Get the License from service.sap.com and download it to local machine Log in 000 client using SAP and run the Tcode slicense import printers, run BDLS for logical system name conversions se06 posprocessing stms usermaster import import profiles for QAS

thanks

Bhudev

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Hi Pranav

why the SIDs of production and QAS are same, did you do refresh of QAS from PRD ?

If yes, then you should have done control file creation and change of SIDs, after the datbase restore...

however, if you want to create the new control file and change the SID then try to consider the following steps:

1. Login as orasid

2. connect to sqlplus

3. run query: alter database PRD backup controlfile to trace;

4. It will create a control file as a latest trace file (.trc) in the directory /oracle/PRD/saptrace/usertrace

note: logout of sqlplus

5. Rename that .trc file into ldQAS.sql

6. copy this file into /oracle/SID ie. /oracle/QAS directory

7. edit the .sql file as below

8. CREATE CONTROLFILE SET DATABASE u201CQASu201D RESETLOGS ARCHIVELOGS;

add above statement replacing the below:

CREATE CONTROLFILE REUSE DATABASE u201CQASu201D NORESETLOGS ARCHIVELOGS;

9. Replace all occurences of string <PRD_SAPsid> by <QAS_SAPsid> in each line where <source_SAPsid> appears

:g/PRD/s/PRD/QAS/g

10. login in sqlplus, stop database

11. as oraqas, delete old control files:

rm /oracle/SID/sapdata1/system_1/cntrl/*

rm /oracle/sid/saparch/cntrl/*

rm /oracle/SID/origlogA/cntrl/*

12. again login into sqlplus (as sysdba always)

13. run this .sql : @ldQAS.sql

note: it should give a message that control file creaated.

14. Open the database using: alter database open resetlogs;

15. alter database rename global_name to QAS.WORLD;

16. drop user OPS$PRDADM cascade;

17. drop user OPS$ORAPRD;

18. create user OPS$ORAQAS identified externally default tablespace <tablespacename>

temporary tablespace psaptemp;

19. grant connect, unlimited tablespace, SAPDBA to OPS$ORAQAS;

grant connect, unlimited tablespace, SAPDBA to OPS$QASADM;

*********

at SAP level:

1. you can run BDLS to convert logicalsystems from PRD to QAS SID

Bhudev

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

In both post, There is some difference specially like User droping.

Whether I have to run BDLS or Drop usr and create or both activity have to be done?????

Regards

Dharmendra

[former_member13072]

Hi,

We are taking online backup and our configuration is DB2 and AIX 6.1 . Can anyone help in refreshing the QAS from PRD though the backups which we are taking?

Regards

[markus_doehr2]

> We are taking online backup and our configuration is DB2 and AIX 6.1 . Can anyone help in refreshing the QAS from PRD though the backups which we are taking?

Read

Note 549828 - Databasecopy with Onlinebackup

Markus

[Former Member]

Hi,

Whether I have to run BDLS or Drop usr and create or both activity have to be done?????

1. If you are using IDOC and ALE then you must use BDLS to change / Convert Logical Systems.

2. When you change the SID of the Target System, your OPS$ machenism get changed. Your database will have OPS$ users according to OLD SID (Source Operating System Users). For new system, you must have OPS$ users in database according to your operating system users (<SID>ADM and ORA<SID>). Otherwise SAP will not able to connect to database instance and will not start correctly.

This is a part of post installation configuration after system copy.

I would recommend please go through the "System Copy" guide for more details information.

Regards.

Rajesh Narkhede

[Former Member]

Please explain step by step:-

7. Server : User : ora > sqlplus u201C/ as sysdbau201D > alter database backup controlfile to trace > exit

In /oracle/SID/saptrace/usertrace, the last trace (check the time) is the script for recreating the control file.

You will need to edit it. Please rename the trace file to ld.sql and send the file to the target system /oracle/SID

Edit the Script: vi ld.sql Delete or comment out all lines at the beginning of the file before STARTUP NOMOUNT which is kept.

Change old controlfile creation statement at the beginnig of the controlfile: Old line: create controlfile reuse database NOresetlogs archivelog; change to New line: create controlfile set database resetlogs archivelog; replace all occurences of string by in each line where appears :g / / s / / /g example: :g/P10/s/P10/T21/g Delete the following lines a the end of the script: ; RECOVER DATABASE; ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN;

8. Get from the Prod system (APC) the .aff and backDPR.log and copy them on AQC. (/oracle//sapbackup) Copy the files to /instkits/SID/. And after we can go on target source server and copy them from /instkits/SID to the /oracle/SID/sapbackup/. With the good owner and permission

Break into steps and explain. It looks confusing to me because I am new to ECC with Oracle.

Regards

Dharmendra

[Former Member]

Hi Dharmendra,

Refer the below threads,

[|]

and

[|]

You will get all the answers regarding System Copy...

Regards.

Rajesh Narkhede