System copy issue

[Former Member]

Hello,

My current system configuration is - dev, qa, prod systems - all running AIX & oracle 10.2 with netweaver 2004s.

each oracle DB has a default instance.

I need to make a system copy on a regular basis once a week from the production to the qa system without erasing the current qa client - a copy client is not acceptable because it takes a long time to do it - 15 hours - i need to do it in 3-4 hours.

the solution i'm checking is to create another sap instance on the qa system (2 instances - one oracle DB),

and each week i will clone from the storage the production data files and connect them to the new qa instance.

is this solution possibe?

is this a regular system copy?

where can i find a guide for oracle system copy?

do i need to run a script to change the SID like i do in sql server,

Regards,

Moshe

[Former Member]

Hello,

Your query is not clear. You have mentioned as 2 instances and one oracle DB

You want to create seperate instance with seperate DB on the same Hardware or You want to create separate instance with same DB.

If you wants to create seperate instance with another Oracle DB then you can go for system copy without touching the existng QA instace. In this case, you can go for standard system copy procedure of Oracle and followed by post system refresh activities like change SID, configure the transport domain,and other activities as per your requirement.

Thanks

Upender Reddy

[Former Member]

Hello,

I want to create separate instance with same DB,(for example exisiting instance - xyz,adding new instance - abc)The separate instance will be a system copy of the production system - i will have to do all the regular activities - change sid,create a new domain etc - i would like to if this is possible, and if someone has a guide for it

regards,

Moshe

[Former Member]

Hai,

There are couple of doing the system copy procedures -

one way -

1. Generate a script in the source system which will help you to create CONTROL FILE on target

machine via SQLPLUS.

u2022 Logon as user ora.

u2022 Call SQLPLUS and login as SYSDBA

1. sqlplus /nolog

SQLPLUS> connect /as sysdba

u2022 Execute the following commands:

SQLPLUS> alter database backup controlfile to trace;

This will generate a trace file ( *.trc ) under /oracle//saptrace/usertrace .

2. Shutdown the database with SHUTDOWN IMMEDIATE in the target system

3. Copy Source Datafiles into relative file systems at Target System.

/oracle/SRC/sapdata1/* > /oracle/TGT/sapdata1/*

/oracle/SRC/sapdata2/* > /oracle/TGT/sapdata2/*

/oracle/SRC/sapdata3/* > /oracle/TGT/sapdata3/*

/oracle/SRC/sapdata4/* > /oracle/TGT/sapdata4/*

/oracle/SRC/sapdata5/* > /oracle/TGT/sapdata5/*

/oracle/SRC/sapdata6/* > /oracle/TGT/sapdata6/*

4. Edit Trace file generated in step 1 so that you can create CONTROL FILE's for

Target Database ID TGT.

u2022 Delete all commented lines ( lines starting with '#' character ).

u2022 Delete other repeated lines so that only lines between

STARTUP MOUNT.... and WE8DEC; remains.

u2022 Change all 'SRC' texts with 'TGT'. If you are using VI use the command

below:

:%s/SRC/TGT/g

u2022 Change the CREATE CONTROLFILE... line so that it looks like

CREATE CONTROLFILE REUSE SET DATABASE "TGT" RESETLOGS

ARCHIVELOG...

5. Execute the script in the target system via SQLPLUS.

SQLPLUS> @/path_to_file/control.sql

6. Open the database via

SQLPLUS> alter database open resetlogs;

7. Get a license for your R/3 System and login to client 000.

8. Run SE06 to setup CTS and configure TMS via STMS Tcode

second way -

Use the same way as mentioned above,but instead of copying the datafiles,you need to take either online or offline backup of the source system and do the restore in the target system using brrestore(BRTOOLS) and

recover by using the brrecover(BRTOOLS) if uses the online backup.

Rest of the procedure is same.

is this solution possibe?-----> Instead of creating the second instance,you can also try by exporting the QAS client.

Once the system copy is completed,import the QAS client.

is this a regular system copy?------> yes,different people follow different types,to suits the business requirements

where can i find a guide for oracle system copy?----> follow the above mentioned procedure or else search in the SDN and Service Marketplace.

Thanks and Regards,

[Former Member]

Hi Moshe,

did you check Oracle's transportable tablespace feature?

The Transportable Tablespaces feature is supported by BR*Tools 7.0.

For more information see SAP note 1003028.

bye

yk

[Former Member]

If you are new to system copy, this might help :

Regards,

Vineeth

[Former Member]

hello Vineeth,

I know the system copy in sql server , less in oracle,

BTW - the link you gave is wrong - it leads to kernel upgrade thread

Regards,

Moshe