Notes for Cloning Autonomous AI Database

Provides information about the cloning operation and the resulting cloned database.

General Notes for Cloning on Autonomous AI Database

Provides general information about the cloning operation and the resulting cloned database.

• If the source database version is Oracle Database 19c, in regions where Oracle AI Database 26ai is available, you can choose either Oracle Database 19c or Oracle AI Database 26ai for the clone.

• If the source database version is Oracle AI Database 26ai, you can select Oracle AI Database 26ai for the clone.

• If there is an ongoing scaling operation on a source database, you cannot initiate a clone operation until the ongoing operation completes. If you attempt such an operation you will see message such as the following:

  The operation cannot be performed because the Autonomous AI Database with Id **** is in the SCALE_IN_PROGRESS state.

• If you define a network Access Control List (ACL) on the source database, the currently set network ACL is cloned to the new database. If a database is cloned from a backup, the current source database's ACL is applied (not the ACL that was valid at the time of the backup).

• If you create a clone and the source database has an access control list (ACL) and you specify the private endpoint network access option, Virtual cloud network for the target database, the ACL is not cloned to the new database. In this case, you must define security rules within your Network Security Group (or groups) to control traffic to and from your target database (instead of using the access control rules that were specified in the ACL on the clone source). See Configure Private Endpoints When You Provision or Clone an Instance for more information.

• Cloning an Autonomous AI Database instance copies your database files to a new instance. There is no downtime associated with cloning and the cloning operation has no impact on applications running on the source.

• For a Metadata Clone, the APEX Apps and the OML Projects and Notebooks are copied to the clone. For a Metadata Clone, the underlying database data of the APEX App or OML Notebook is not cloned.

• The Autonomous AI Database Details page for an Autonomous AI Database instance that was created by cloning includes the Cloned From field. This displays the name of the database where the clone was created.

• The value of the DBA_SERVICES.FAILOVER_TYPE column is not copied to a cloned Autonomous AI Database instance.

Notes for Cloning an Autonomous AI Database from a Backup

Provides Notes for cloning an Autonomous AI Database from a backup:

• If there is an ongoing clone from backup operation on a source database, you cannot initiate a new clone operation on the same backup being cloned until the ongoing operation completes. Thus, you cannot clone from backup twice concurrently from a specific backup (for example, a specific timestamp or a specific selected backup from the list of backups).

• For external tables, partitioned external tables, and the external partitions of hybrid partitioned tables a backup does not include the external files that reside on your Object Store. Thus, for the clone from backup operation, it is your responsibility to backup, and restore if necessary, the external files associated with external tables, external partitioned tables, or the external files for a hybrid partitioned table

• With clone from backup, the Oracle Machine Learning workspaces, projects, and notebooks of the source database are not cloned to the new database.

• After Autonomous AI Database has finished provisioning the clone, query the view dba_pdbs to see the last_recover_time and last_recover_scn columns. These columns provide the saved timestamp and the saved SCN of the data from which the cloned database was created.

  For example:

  SELECT last_recover_time, last_recover_scn FROM dba_pdbs;

  See System Change Numbers (SCNs) for more information on SCNs.

Notes for Cross Tenancy and Cross Region Cloning

Provides information about cross tenancy and cross region cloning.

• For cloning, when you choose a region other than the current region for your clone target, using either the Oracle Cloud Infrastructure CLI or Terraform you can only perform such a cross region clone from the remote region. That is, call the create clone API from the remote region to which you want to clone, with the source database OCID as that of the source that you want to clone from.

• The cross tenancy cloning option is only available using the CLI or the Autonomous AI Database REST APIs. Cross tenancy cloning is not available using the Oracle Cloud Infrastructure Console.

  See Cross Tenancy and Cross Region Cloning for more information.

• The cross tenancy cloning option does not support cloning with customer managed keys on the source. See Manage Encryption Keys on Autonomous AI Database for more information on customer managed keys.

Resource Management Rules and Performance Data for a Cloned Database

Provides notes for resource management rules and performance data for a cloned database.

The following applies for resource management rules and performance data in a cloned database:

• During the provisioning for either a Full Clone or a Metadata Clone, any resource management rule changed by the user in the source database is carried over to the cloned database.

• For a cloned database, performance data for the time prior to the clone operation is not visible in the Database Dashboard card (under Monitor in Database Actions).

For more information on setting resource management rules, see Manage Runaway SQL Statements on Autonomous AI Database.

Optimizer Statistics for a Cloned Database

During the provisioning for either a Full Clone or a Metadata Clone, the optimizer statistics are copied from the source database to the cloned database.

The following applies for optimizer statistics for tables in a cloned database:

• Full Clone: loads into tables act the same as loading into a table with statistics already in place.

• Metadata Clone: the first load into a table after the database is cloned clears the statistics for that table and updates the statistics with the new load.

For more information on Optimizer Statistics, see Optimizer Statistics Concepts.

Disable Oracle Scheduler Jobs for a Cloned Database

Oracle Scheduler jobs from a source database are copied to the clone when you perform a clone operation. You can assure that cloned Oracle Scheduler jobs are disabled on the clone.

To disable Oracle Scheduler jobs on Autonomous AI Database instances that are cloned, you can define a trigger using the AFTER CLONE clause. To use the AFTER CLONE clause, define the trigger on the source database before you perform the clone operation.

For example:

CREATE OR REPLACE TRIGGER after_clone_instance
     AFTER CLONE
     ON PLUGGABLE DATABASE
BEGIN
-- Disable specific jobs or use a cursor to grab all scheduled jobs and disable them
     DBMS_SCHEDULER.DISABLE(name=> job_name);
END;
/

See CREATE TRIGGER Statement for more information.

Note the following:

• The value for the DBA_SCHEDULER_WINDOWS.REPEAT_INTERVAL column is not copied to a cloned Autonomous AI Database instance.