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 An IAM document that specifies who has what type of access to your resources. It is used in different ways: to mean an individual statement written in the policy language; to mean a collection of statements in a single, named "policy" document (which has an Oracle Cloud ID (OCID) assigned to it); and to mean the overall body of policies your organization uses to control access to resources. 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 A collection of related resources that can be accessed only by certain groups that have been given permission by an administrator in your organization. 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 Database with Dedicated Deployment

When cloning a database that uses dedicated deployment, 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 with serverless deployment
To clone an Autonomous Database with dedicated deployment

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.