Oracle Cloud Infrastructure Documentation

Cloning an Autonomous Database

This topic describes how to clone an existing Autonomous Database using the Oracle Cloud Infrastructure Console or the API.  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 Console's cloning feature is a quick and easy way to accomplish this task.

Note

Any existing Autonomous Database (including those provisioned with preview version software) can be cloned using a preview version of Autonomous Database. However, preview version databases cannot be cloned using the regular (general-availability) Autonomous Database software.

Clone Types

The clone feature offers the following two types of Autonomous Database clones:

  • The full clone option creates a new database that includes all of the source database's metadata and data.
  • The metadata clone option creates a new database that includes the source database's metadata, but not the source database's data.

Prerequisites

  • To clone an Autonomous Database, you must be given the required type of access in a policy  written by an administrator, whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you try to perform an action and get a message that you don’t have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which compartment  you should work in. See Authentication and Authorization for more information on user authorizations for the Oracle Cloud Infrastructure Database service.

Password Requirement for New Databases on Dedicated Exadata Infrastructure

When cloning a database on dedicated Exadata infrastructure, the password you set for the target database cannot be one of the three most recently used passwords of the source database.

Using the Oracle Cloud Infrastructure Console

To clone an Autonomous Database on shared Exadata infrastructure
To clone an Autonomous Database on dedicated Exadata infrastructure

Using the API

Use the CreateAutonomousDatabase API operation to clone an Autonomous Database.

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

For More Information

For information about optimizer statistics, resource management rules and performance data for a cloned database, see the Using Oracle Autonomous Data Warehouse and Using Oracle Autonomous Transaction Processing user guides.