SAP ECC System copy

[Former Member]

Dear Friends,

I have to refresh my ECC qulaity server with my ECC production server using Databse restore method.

I have ECC 6.0 on HP-UX 11iv2 and Oracle 10g.

I have taken screenshot of all RFC connections, screenshot of STMS settings in our quality server and all the transport request have been transported in ECC prodcution from quality server.

What other things which needs to be taken care ?

If any one has does this activity, please share the steps ?

Regards

Ganesh Datt Tiwari

[Former Member]

Dear Friends,

I am realy thankfull to all of you for valuable support.

[Former Member]

Hi,

When you performing the SYSTEM COPY using backup restore method we need to consider the below steps.

1) Source system activities.

Stop productive operation in source systems.

a) Suspend the batch jobs using BTCTRNS1 report.

b) Disable the communication in source system ( SM59 )

c) Make sure redo log groups are archived.

d) Generate the control file structure for the target database.Using below command.

ora_br_copy.bat -generateFiles -forceLogSwitches -targetSid <Target_SID> -password <system_user_password> -listenerPort 1527.

e) Create an offline backup of the source database.

Re-enable all items that were deactivated prior to backing up <Target_SID>

2) Target system activities.

If the target system is being refreshed then first secure any information that you may require again once the restore is complete.

a) Backup user master and authorization data from each client where this data needs to be used.

b) Backup RFC tables to restore destinations afterwards.

c) Printers devices backup.

d) Release all open target system requests.

e) Export ALE partner profiles.

f) Document the registered developer's and objects if any.

g) Document logon groups,STMS settings and client settings.

h) Backup OS Level Files ( Profiles, exe and database)

I hope above points will help you.

And also recommend to go through the SAP guide before going to perform this activity.

It will help you.

Regards,

Kiran .V

[Former Member]

Hi Kiran,

Thanks for your valuable information step by step.

I have read in system copy guide also. But i have a query as point no. d given by you and guide also

Make sure redo log groups are archived.

d) Generate the control file structure for the target database.Using below command.

ora_br_copy.bat -generateFiles -forceLogSwitches -targetSid <Target_SID> -password <system_user_password> -listenerPort 1527.

1. How can i sure about redo log groups are archived ?

2. What does the option -forceLogSwitches ?

3. What will be the impact of the above command on source system ?

I am searching the same but not success.

Please help me ?

Regards

Ganesh Datt Tiwari

[Former Member]

Hi,

1. How can i sure about redo log groups are archived ?

It means that all the transactions have been completed and written to the offline redolog files. So, when the database shutdown normally, you have a consistent state with the required offline redolog files.

2. What does the option -forceLogSwitches ?

Check OraBRCopy.pdf: If this option is specified then Oracle database will be stopped during the tool execution.

3. What will be the impact of the above command on source system ?

It will stop the database (because of forceLogSwitches) and generate the control.sql

Best regards,

Orkun Gedik

[Former Member]

Hi,

1. How can i sure about redo log groups are archived ?

From a command prompt, do the following:

sqlplus /nolog

connect / as sysdba

alter system switch logfile - Run this 4 times (It generate the offline redo log files in oraarch directory and it also updates the lo sequence numbers in control file.).

2. What does the option -forceLogSwitches ?

The above manual step is only necessary if you choose NOT to

use the -forceLogSwitches option while generating the control file.

3. What will be the impact of the above command on source system ?

It won't impact anything in your source system.Its generating the control file.

I hope it will help you.

Regards,

Kiran .V

[Former Member]

Thanks Kiran,

These steps are realy helpfull for me.

After completing teh restore activity then.

1. I have to restore all RFC connections.

2. Restore STMS settings.

3. Background jobs.

4. Printers

What other activity which needs to be done ?

Regrads

Ganesh Datt Tiwari

[Former Member]

Dear Friends,

I have restore all the tha data and created control file and database is up and running.

But when i am trying to start SAP then it is giving the error message as below.

Used parameter files:

/usr/sap/QAR/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = jkeccdq

) (PORT = 1527))) (CONNECT_DATA = (SID = QAR) (GLOBAL_NAME = QAR.WORLD)))

OK (0 msec)

tnsping: V2 connect to QAR

-

---

Thu Nov 17 10:16:51 IST 2011

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Thu Nov 17 10:16:52 IST 2011

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Thu Nov 17 10:17:15 IST 2011

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 17 10:17:15 2011

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1.0469E+10 bytes

Fixed Size 2067520 bytes

Variable Size 1862271936 bytes

Database Buffers 8589934592 bytes

Redo Buffers 14708736 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

-

---

Thu Nov 17 10:17:29 IST 2011

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/QAR/SYS/exe/run/startdb: Terminating with error code 12

jkeccdq:qaradm 29>

[Former Member]

Hi,

Addition to your steps, please find my first suggestion, below;

1) Disabling scheduled jobs that does not need to be run on the QA system

2) Changing logical client name by BDLS

3) Disabling printers in order to avoid wrong outputs

4) Scheduling DBA jobs on DBA calendar

There tasks are additional tasks and can be applicable in your environment. You can find rest of it in the System copy guide

Best regards,

Orkun Gedik

[Former Member]

Hi Gedik,

Thanks for your valuable reply.

I have noted steps given by you. Thanks.

Now I have taken the offline backup of my Production Oracle database.

I will restore the offline backup on my quality server as it is. Before doing this I have to creat control file for target system from my Source system.

Can I creat it from Oracle command ?

Please tell me the command

Regards

Ganesh Datt Tiwari

[Former Member]

Hi,

You can use the command, below in order to create a control file;

alter database backup controlfile to trace resetlogs;

But, you need to go to "/usertrace" folder and find the trace file, created by sql statement. And perform some string operations in it. Instead, I recommend you to use system copy tools. You can find how to guide in the system copy guide

Best regards,

Orkun Gedik

[Former Member]

Hello Tiwari,

look at sap note 784118 and download the orabrcopy tool, there is a pdf file included with the commands you are looking for.

Kind regards,

Gerd

[Former Member]

Thanks Gedik,

The given command will be executed on source system ?

what will be the next step ?

Please help me

Regards

Ganesh Datt Tiwari

[former_member188883]

Hi,

Next steps would be

1) Copy the trace file generated on the source system to target system.

2) After the restore is done, you will need to re-create the new control file on target system.

Regards,

Deepak Kori

[Former Member]

> The given command will be executed on source system ?
> 
> what will be the next step ?

Yes, on source, but it seems you never reads the documentation. Could you google/search on SDN once or twice, I am sure the steps are already there.

Ask if you still don't get the documentation.

Thanks

[Former Member]

>> The given command will be executed on source system ?

Yes, it is correct.

You can find detailed further information in the system copy guide, below, under the title "5.1.1 Generating the Control File Structure"

https://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000670917&;

Best regards,

Orkun Gedik