Creating an Architecture for Cloning Oracle Databases on Demand
The traditional approach to copying a production database is a heavyweight activity. Since every copy requires 100% of the storage capacity of the original database, keeping many copies places a major burden on storage resources. Getting necessary approvals, locating storage capacity, and copying the data also typically take a long time to accomplish. Performance of the production database can also be impaired while the copy is taking place. While it may be possible to perform testing or QA with only a subset of the production data, this can lead to inconsistent results, and other activities will require the complete data set.