Enterprise Manager Database as a Service Snap Clone is a ‘self service’ solution for enabling rapid creation of space efficient clones for large, multi-terabyte databases including Oracle Multitenant databases. Snap Clone can improve the efficiency and agility of administrators and engineers while reducing storage-related CAPEX.
Enterprise Manager Database as a Service Snap Clone allows administrators to create fully functional copies of databases using the copy-on-write (CoW) capabilities of the underlying storage layer. Users can request databases from the self-service console and have them provisioned within minutes instead of hours while keeping storage needs to a minimum.
Since new storage blocks are allocated only when updates are made to the copy, users can realize storage savings of over 90% (typically a few hundred kilobytes for a 1 terabyte database). In addition, because you are not copying the original block out of the way, there is no significant performance impact. Since the snapshots are simply pointers, to restore data, the pointers to the original data are updated again. This is faster than copying all the data back from the snapshot area over the original data, as in copy-on-write snapshots. So taking a snapshot completes in seconds, even for very large volumes. A typical terabyte database takes just a few minutes to clone.
Snap Clone protects the storage investment by supporting multiple options for using and interacting with storage: Snap Clone functionality is built on top of the Enterprise Manager Storage Management Framework (SMF) plugin. The SMF plugin provides the required layer of abstraction to shield DBAs and users from the nuances of the different storage systems. At the storage level, Snap Clone accesses underlying storage technologies, such as copy-on-write or similar technologies, to perform the required tasks.
Snap Clone provides built-in administrative and manageability capabilities to simplify the management of storage and provide greater flexibility and control for DBAs Developers, and QA Engineers.