Clone Autonomous Database

This article describes how to clone an existing Autonomous Database using the Oracle Cloud Infrastructure Console.  You may wish to use the cloning feature to create a point-in-time copy of your Autonomous Database for purposes such as testing, development or analytics. If you need to clone only the database schema of your source database, the “metadata clone” option is a quick and easy way to accomplish this task.
 
 Log into Oracle Cloud and click the “Create an ATP database” link.
Fill in the information and select the options to create the ATP instance.
 
Choose a compartment: dbadutra(root)
Display name: DBCLONE
Database name: DBCLONE
Choose a workload type: Transaction Processing
Choose a deployment type: Shared Infrastructure
Configure the database:  In this case, as we use Always Free we can’t change the CPU and Storage size.
Create administrator credentials: OracleATP2020        
Choose a license type: In this case select License Included
 
After you have filled everything in, click  “Create Autonomous Database”
Wait a few minutes for ATP creation

 

 

Now select in menu “Autonomous Transaction Processing”

 

Click in “DBCLONE”
In the “Actions” menu click on “Create Clone”
Now let’s create a clone of our ATP, filling in the information below.
 
Clone Type:  In this option, we can choose a complete clone or just the structure without data. In this case we will select Full Clone.
Configure clone source: In this option we can choose a clone from the Database Instance or using a Backup to perform this clone and can perform a point in time recovery.
In this case, we will use the clone from the Database Instance.
Create In Compartment: dbadutra (root)
Display name: Clone of DBCLONE
Database name: DBCLONE2
Configure the database: In this case, as I use Always Free, we can’t change the CPU and Storage size.
Create administrator credentials: OracleATP2020        
Choose a license type: In this case select License Included
Now click on “Create Autonomous Database Clone”
 
 
Wait a few minutes for Clone ATP creation
Ready your clone is created and available for use.
To learn more on the Autonomous Database Clone Check here:

 

https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm
 
We hope we helped you with this great new feature.

 

André Ontalba / Rodrigo Mufalani

 

Disclaimer: “The postings on this site are my own and don’t necessarily represent my actual employer positions, strategies or opinions. The information here was edited to be useful for general purpose, specific data and identifications were removed to allow reach the generic audience and to be useful for the community.”