Hello All,
I need to get a process in place for refreshing our DEV & TEST environments with PROD data. I was just looking for ideas on how other users do it. My first thought was to simply export the OTM users/objects(glogowner, archive, glogdba...etc) from PROD and overlay the same objects in DEV or TEST using data pump. I've also started looking at wiping the destination database and using RMAN to duplicate PROD for restore into the target environment. I would appreciate any suggestions on the simplest/cleanest/safest method for getting this done.
Thanks,
Joe Patton
----------------------------------
Hardware/Software Environment:
OTM 5.5 CU4
Server OS: Redhat Enterprise Linux 4
Database: Oracle RDBMS 10.2.0.3
Application: Oracle Application server 10.1.3.3
Web: Apache/Tomcat
I need to get a process in place for refreshing our DEV & TEST environments with PROD data. I was just looking for ideas on how other users do it. My first thought was to simply export the OTM users/objects(glogowner, archive, glogdba...etc) from PROD and overlay the same objects in DEV or TEST using data pump. I've also started looking at wiping the destination database and using RMAN to duplicate PROD for restore into the target environment. I would appreciate any suggestions on the simplest/cleanest/safest method for getting this done.
Thanks,
Joe Patton
----------------------------------
Hardware/Software Environment:
OTM 5.5 CU4
Server OS: Redhat Enterprise Linux 4
Database: Oracle RDBMS 10.2.0.3
Application: Oracle Application server 10.1.3.3
Web: Apache/Tomcat
Comment