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