Clone an Autonomous Database Instance

Shows you the steps to clone a database from the Oracle Cloud Infrastructure Console.

Perform the following prerequisite steps as necessary:

  • Open the Oracle Cloud Infrastructure Console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then, depending on your workload click one of: Autonomous Data Warehouse, Autonomous JSON Database, or Autonomous Transaction Processing.
  • Choose your region. See Switching Regions for information on switching regions and working in multiple regions.

  • Choose your Compartment. See Compartments for information on using and managing compartments.

  • Select an Autonomous Database instance from the list in your compartment.

To clone the Autonomous Database instance:

  1. On the Autonomous Database Details page, from the More actions drop-down list, select Create clone.
  2. On the Create Autonomous Database clone page, choose the clone type from the choices:
    • Full Clone: creates a new database with the source database’s data and metadata.
    • Refreshable Clone: creates a read-only full clone that can be easily refreshed with the source database’s data.

      See Using Refreshable Clones with Autonomous Database for more information.

    • Metadata Clone: creates a new database with the source database’s metadata without the data.
  3. Choose a compute model

    The ECPU compute model is not enabled by default. If you want to create an Autonomous Database instance that uses ECPUs, please file a Service Request at Oracle Cloud Support.

    Note:

    If the source database uses the ECPU compute model, you cannot select OCPU.
    • ECPU

      Use the ECPU compute model for Autonomous Database.

      The ECPU compute model is not available with JSON or APEX workloads.

    Click Change Compute model to change the compute model. After you select a different compute model, click Save Changes.

    • OCPU

      Use the legacy OCPU compute model if your tenancy is using the OCPU model and you want to continue using OCPUs. The OCPU compute model is based on physical core of a processor with hyper threading enabled.

  4. In the Clone source area, select one of:
    • Clone from database instance: This creates a clone from a running database.

    • Clone from a backup: This creates a database clone from a selected backup, from a point-in-time timestamp, or from the latest backup data that is available. See Clone an Autonomous Database from a Backup for more information.

  5. Provide basic information for the Autonomous Database clone.
    • Choose your preferred region: from the list, select the region where you want to create the clone.

      Note: the list only shows the regions that you are subscribed to.

      When you select Clone from database instance as the clone source, and you choose another region, other than the current region for your clone target, you can only perform such a cross region clone using the Oracle Cloud Infrastructure Console. Using either the Oracle Cloud Infrastructure CLI or Terraform is not supported for creating a cross-region clone.

    • Create in Compartment. See Compartments for information on using and managing compartments.

      Note: the list only shows the compartments that you are subscribed to.

    • Display name Specify a user-friendly description or other information that helps you easily identify the resource.

      You can use the name provided, of the form: Clone-of-DBname or change this to the name you want to use to identify the database. The supplied DBname is the name of the source database that you are cloning.

    • Database name: Specify the database name; it must consist of letters and numbers only. The maximum length is 30 characters. The same database name cannot be used for multiple Autonomous Databases in the same tenancy in the same region.

      The default database name is a generated 16-character string.

  6. Configure the database (with ECPU compute model)

    Note:

    Go to the next step if you use the OCPU compute model.
    • Choose database version: Select the database version. The available database version is 19c.

    • ECPU count: Specify the number of CPUs for your database. The minimum value for the number of ECPUs is 2.

      Your license type determines the ECPU count maximum. For example, if your license type is Bring Your Own License (BYOL) with Oracle Database Standard Edition (SE), the ECPU count maximum is 16.

    • ECPU auto scaling: By default compute auto scaling is enabled to allow the system to automatically use up to three times more CPU and IO resources to meet workload demand. If you do not want to use compute auto scaling then deselect this option.

      See Use Auto Scaling for more information.

    • Storage (TB) Specify the storage you wish to make available to your database, in terabytes.

    • Storage auto scaling By default storage auto scaling is disabled. Select if you want to enable storage auto scaling to allow the system to automatically expand to use up to three times more storage.

      See Use Auto Scaling for more information.

  7. Configure the database (with OCPU compute model)

    Note:

    Skip this step if you use the ECPU compute model.
    • Choose database version Select a database version that is the same version or is a higher version than the source database.

    • OCPU count Specify the number of CPU cores for your database.

      Your license type determines the OCPU count maximum. For example, if your license type is Bring Your Own License (BYOL) with Oracle Database Standard Edition (SE), the OCPU count maximum is 8.

    • OCPU auto scaling By default compute auto scaling is enabled to allow the system to automatically use up to three times more CPU and IO resources to meet workload demand. If you do not want to use compute auto scaling then deselect this option.

      See Use Auto Scaling for more information.

    • Storage (TB) Specify the storage you wish to make available to your database, in terabytes.

      For a Full Clone, the minimum storage that you can specify is the source database's actual used space rounded to the next TB.

    • Storage auto scaling By default storage auto scaling is disabled. Select if you want to enable storage auto scaling to allow the system to automatically expand to use up to three times more storage.

      See Use Auto Scaling for more information.

  8. Create administrator credentials.
    • Username This is a read-only field.

    • Password Set the password for the Autonomous Database Admin user. The password must meet the strong password complexity criteria based on Oracle Cloud security standards. For more information on the password complexity rules see Create Users on Autonomous Database - Connecting with a Client Tool.
    • Confirm password Specify a value to confirm the password.
  9. Choose network access

    Note:

    After you clone your Autonomous Database you can change the network access option you select for the cloned instance.
    • Secure access from everywhere

      By default all secure connections are allowed from everywhere.

    • Secure access from allowed IPs and VCNs only

      This option restricts connections to the database according to the access control lists (ACLs) you specify. To add multiple ACLs for the Autonomous Database, click + Access Control Rule.

      See Configure Access Control Lists When You Provision or Clone an Instance for more information.

    • Private endpoint access only

      This option assigns a private endpoint, private IP, and hostname to your database. Specifying this option allows traffic only from the VCN you specify; access to the database from all public IPs or VCNs is blocked. This allows you to define security rules, ingress/egress, at the Network Security Group (NSG) level and to control traffic to your Autonomous Database.

      See Configure Private Endpoints When You Provision or Clone an Instance for more information.

  10. Choose license and Oracle Database Edition
    • Bring Your Own License (BYOL)

      Select if your organization already owns Oracle database software licenses. Bring your existing database software licenses to the database cloud service. See Cloud pricing for information on Bring Your Own License (BYOL) and other licensing options for Oracle Cloud Infrastructure cloud service pricing.

    • Choose Oracle Database Edition (for ECPU Compute Model)

      When you select Bring Your Own License (BYOL), you also choose an Oracle Database Edition. The Oracle Database Edition you select is based on the license you bring to Autonomous Database and changes the maximum value that you can select for the ECPU count. The choices are:

      Oracle Database Enterprise Edition (EE): For this license type the maximum allowed value for ECPU count depends on the workload type, 512 with Data Warehouse or 256 with Transaction Processing, however you may contact your Oracle account team to request more ECPUs for either workload type. With compute auto scaling enabled you can use up to ECPU count x 3 ECPUs. For example, if you set the ECPU count to 256, you can use up to 768 ECPUs.

      Oracle Database Standard Edition (SE): For this license type the maximum allowed value for ECPU count is 16. With compute auto scaling enabled you can use up to ECPU count x 3 ECPUs. This license restricts the number of ECPUs you can use to a maximum of 16 ECPUs, with or without compute auto scaling enabled.

      See Use Auto Scaling for more information.

    • Choose an Oracle Database Edition (for OCPU Compute Model)

      When you select Bring Your Own License (BYOL), you also choose an Oracle Database Edition. The Oracle Database Edition you select is based on the license you bring to Autonomous Database and changes the maximum value that you can select for the OCPU count. The choices are:

      Oracle Database Enterprise Edition (EE): For this license type the maximum allowed value for OCPU count is 128, however you may contact your Oracle account team to request more than 128 OCPUs. With auto scaling enabled you can use up to OCPU count x 3 OCPUs. For example, if you set the OCPU count to 128, you can use up to 384 OCPUs.

      Oracle Database Standard Edition (SE): For this license type the maximum allowed value for OCPU count is 8. With auto scaling enabled you can use up to OCPU count x 3 OCPUs. This license restricts the number of OCPUs you can use to a maximum of 8 OCPUs, with or without auto scaling enabled.

      See Use Auto Scaling for more information.

    • License Included

      Subscribe to new database software licenses and the database cloud service.

  11. (Optional) Provide up to 10 maintenance contacts.

    Click Add Contact and in the Contact Email field, enter a valid email address. If the database you are cloning has a customer contact list, the list is copied. To enter multiple Contact Email addresses, repeat the process to add up to 10 customer contact emails.

    See View and Manage Customer Contacts for Operational Issues and Announcements for more information.

  12. (Optional) Click Show advanced options to select advanced options.
    • Encryption Key

      Encrypt using Oracle-managed keys: By default Autonomous Database uses Oracle-managed encryption keys. Using Oracle-managed keys, Autonomous Database creates and manages the encryption keys that protect your data and Oracle handles rotation of the TDE master key.

      Encrypt using a customer-managed key in this tenancy: If you this option, a master encryption key from a Oracle Cloud Infrastructure Vault in the same tenancy is used to generate the TDE master key on Autonomous Database.

      Encrypt using a customer-managed key located in a remote tenancy: If you this option, a master encryption key in the Oracle Cloud Infrastructure Vault located in a remote tenancy is used to generate the TDE master key on Autonomous Database.

      See Use Customer-Managed Encryption Keys on Autonomous Database for more information.

    • Maintenance

      Patch level By default the patch level is the patch level of the source database. Select Early to configure the instance with the early patch level. When cloning a source database with Early patch level, you can only choose the Early patch level for your clone.

      See Set the Patch Level for more information.

    • Management

      Shows the character set and national character set for your database.

      See Choose a Character Set for Autonomous Database for more information.

    • Tools

      If you want to view or customize the tools configuration, select the tools tab.

      See Configure Autonomous Database Built-in Tools when you Provision or Clone an Instance for more information.

    • Tags

      If you want to use Tags, enter the TAG KEY and VALUE. Tagging is a metadata system that allows you to organize and track resources within your tenancy. Tags are composed of keys and values which can be attached to resources.

      See Tagging Overview for more information.

  13. Click Create Autonomous Database clone.

On the Oracle Cloud Infrastructure console the State shows Provisioning... until the new database is available.

If you created a cross-region clone, a new tab shows the newly provisioned clone's Oracle Cloud Infrastructure Console and the region shown is the region you selected when you created the clone.

See Notes for Cloning Autonomous Database for additional information on cloning.

See Cloning an Autonomous Database for information on using the API.