Often times development and testing teams need a copy of a production database in order to develop or test using a representative dataset. Up until now, creating these cloned environments has been a challenging and time consuming process for DBAs.
Oracle Autonomous Database makes it extremely easy for a DBA to clone a database in just a few mouse clicks, as I demonstrate in the video below.
When it comes to cloning an Autonomous Database you have two options:
You can create a new database that is a complete copy of the original database, which includes all metadata (table and view definitions etc.) and all of the actual data. This is referred to as a FULL CLONE.
Or you can create a new database that only contains the metadata from the original database. This is referred to as METADATA CLONE.
Either way the “cloned” database will have a completely new database name, admin password. It can also have different infrastructure criteria (CPU count and storage) from the original database.
The clone will also not have any of the AWR data or any of the ML Worksheets from original database.