For many complex database applications such as Oracle E-Business suite, it is a quite common that a production environment needs 10 or more copies of various development and test purposes.
This database clone process to create these many copies of production database can be very challenging and costly especially when the database gets larger than multiple even over 10 terabytes (TBs).
This session will discuss two snapshot based methods that can help IT simplify this database cloning process and reduce the time and resource cost: The method is called Oracle gDBClone which is based on Oracle ACFS snapshot.
The second method is based on database storage volume snapshot provided by the storage array.
With a real example in our IT department, we will discuss the implementation details of these two methods and discuss the pros and cons of these two methods.
Objectives:
- Examine the need and challenges to clone large over 10TB Oracle EBs database for DEV/Test
- Discuss two snapshot based methods: Oracle gDBClone which is based on Oracle ACFS snapshot and Database storage volume snapshot method
- Discuss the implementations of these two methods and their pros and cons comparison through a real example.