Skip to Content
0
Former Member
Jul 16, 2008 at 12:13 PM

System copy issue

23 Views

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