System Copy in AIX

[Former Member]

Hi experts,

o m new to basis. can anybody answer to following questions?

1)complete system copy procedure(pre-requisites and post).

2)what are all the file systems i shud take back up for system copy.

3)Pls tell me be how to check the file systems(sapdata1,2,3 etc).

can u give the commands in steps wise.

Regards,

Abdul Majid

[Former Member · Accepted solution]

Hello Abdul

This is very generic type of question and you have asked so many questions which are very generic and there have been many posts and discussions for this issue recently on SDN and lot of info is already available ... you should research a bit

thanks

Bhudev

[Former Member · Accepted solution]

Hello Abdul

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/<sourceSID>/sapbackup/back<sourceSID>.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 <sid>adm and ora<sid>

7. Server : <source server name>

User : ora<sid>

> 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<TARGET_SID>.sql and send the file to the

target system /oracle/SID

Edit the Script:

vi ld<SAPsid>.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 <SAPsid> NOresetlogs archivelog;

change to

New line: create controlfile set database <SAPsid> resetlogs archivelog;

replace all occurences of string <source_SAPsid> by <SAPsid> in each line where <source_SAPsid>

appears

:g / <source_SAPsid> / s / <source_SAPsid> / <SAPsid> /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/<SID>/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 <sid>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 <SID>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<sid>

> cd

> sqlplus u201C/ as sysdbau201D

> @ld<target_sid>.sql

> alter database open resetlogs;

3. Change the sapr3 password

Server : <target server name>

User : ora<sid>

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 : <target server name>

User : <sid>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

[former_member105207]

hi Sameer,

Refer the following link

The Guide will be vailable under the installation folder of the required version from the following link

http://service.sap.com/instguidesnw

This note might help you

784118 - System Copy Java Tools

regards,

chandru.