on 07-16-2008 1:13 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.