Shows the
options to select a backup as the clone source for cloning Autonomous Database.
Perform the following prerequisite steps as necessary:
Open the Oracle Cloud
Infrastructure Console by clicking the 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.
On the Details page, from the More actions drop-down list, select
Create clone.
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.
Metadata clone: creates a new database with the source database’s metadata without the data.
In the Configure clone source area, select the
Clone source option:
Clone from database instance: This
creates a clone from a running database. See Clone an Autonomous Database Instance for details and steps with this selection.
Clone from a backup: This selection
creates a database clone using a backup. Select this option.
In the Configure clone source area, select the
Backup clone type:
Point in time clone: Enter a timestamp
to clone in the Enter Timestamp field.
Select the backup from a list: Enter
From and To dates to
narrow the list of backups then select a backup to use for the clone
source.
Provide basic information for the Autonomous Database.
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.
For the clone type Clone from a
backup as the clone source, when you choose another
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.
Create in Compartment: See Compartments for
information on using and managing compartments.
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.
Select a value for Choose a workload type from the following options.
Data Warehouse: This creates an Autonomous Data Warehouse type clone.
Transaction Processing: This creates an Autonomous Transaction Processing type clone.
JSON: This creates an Autonomous JSON Database type clone.
You can only create a free instance in the tenancy's Home
region.
Choose database
version: Select the database version. The
available database versions are Oracle Database
23ai and Oracle Database
19c.
Notes for selecting a database version:
In regions where Oracle Database 23ai is not available, Oracle Database 19c is the only
choice.
Autonomous Database
with Oracle Database 23ai in the Paid tier
is available in all commercial public cloud regions.
Always Free Autonomous Database
with Oracle Database 23ai is available in
all commercial public cloud regions except the following
regions: Colombia Central: Bogota (BOG), Saudi Arabia Central (RUH),
Singapore West: Singapore (XSP), Spain Central: Madrid
(MAD)
If the source database version is Oracle Database 19c, in regions where
Oracle Database 23ai is available,
you can choose either Oracle Database 19c or
Oracle Database 23ai for the
clone.
If the source database version is Oracle Database 23ai, you can select Oracle Database 23ai for the
clone.
ECPU count: Specify the number of
CPUs for your database. The minimum value for the number of ECPUs is
2.
Compute 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.
Storage: Specify the storage you wish
to make available to your database. Depending on your workload type you
have these options:
Data Warehouse: Specify your
storage in Terabytes (TB).
For a Full Clone, the minimum storage that you can
specify is the source database's actual used space rounded to
the next TB.
Transaction Processing or
JSON: Specify your storage in
Gigabytes (GB) or Terabytes (TB). Enter the size in the
Storage field. Select GB or
TB for the Storage unit
size.
For a Full Clone, the minimum storage that you can
specify is the source database's actual used space rounded to
the next GB.
By default, the IO capacity
of your database depends on the number of ECPUs you provision. When
you provision 384 TB of storage, your database is entitled to the
full IO capacity of the Exadata infrastructure, independent of the
number of ECPUs you provision.
Autonomous Database
uses Exadata Smart Flash Cache to automatically cache frequently
accessed data, delivering the high I/O rates and fast response times
of flash. The amount of flash cache for your database depends on the
amount of storage you provision, or the amount of allocated storage
if you enable storage auto scaling.
If you want to provision more than 384 TB of storage, file a
Service Request at Oracle Cloud
Support.
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.
With storage auto scaling
disabled, the guaranteed minimum flash cache size is 10% of your
database's provisioned storage size.
With storage auto scaling
enabled, the guaranteed minimum flash cache size is 10% of your
database's provisioned base storage size or its allocated storage
size, whichever is higher.
Bring your own license: If you want to Bring Your Own License to the
database, click Enable to show the
Update license and Oracle Database
Edition page.
By default the automatic backup retention is 60 days.
Automatic backup retention period in days
You have the option to select the automatic backup retention period, in a
range from 1 to 60 days. You can restore and recover your database to any
point-in-time in this retention period.
Select Immutable backup retention to lock
the backup retention period.
After setting the immutable backup
retention option, you cannot disable this option or change the
retention period. To disable immutable backup retention or to change
the backup retention period, file a Service Request at Oracle Cloud
Support.
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.
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 rules (ACLs) you specify. To add multiple ACLs for
the Autonomous Database,
select this option and click Add access control
rule.
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.
(Optional) Provide contacts for operational notifications and
announcements
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.
(Optional) Click Show advanced options to select advanced options.
Encryption Key
Encrypt using an Oracle-managed key: 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.
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. Select
Regular to configure the instance with the
regular patch level.
Add a security attribute to control access for your resources using
Zero Trust Packet Routing (ZPR) policies. To enter security attributes
during provisioning you must already have set up security attributes
with Zero Trust Packet Routing. You also can add security attributes
after provisioning.
Note
You can apply Oracle Zero
Trust Packet Routing (ZPR) policies to a private endpoint.
Specify a Namespace,
Key, and Value
security attribute.
Click Add security
attribute to add additional security attributes.
If you want to
use Tags, enter the Tag key and Tag
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.
On the Oracle Cloud
Infrastructure console the State shows Provisioning... until the new database is available.
Note
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.
Clone an Autonomous Database from Latest Backup When you choose to clone from latest backup, this selects the latest backup as the clone source. You can choose this option if a database becomes unavailable or for any reason when you want to create a clone based on the most recent backup.
When you
choose to clone from latest backup, this selects the latest backup as the clone
source. You can choose this option if a database becomes unavailable or for any
reason when you want to create a clone based on the most recent backup.
Follow the steps in Clone an Autonomous Database from a Backup and in the Clone source area, select Clone
from a backup and Select the latest backup
timestamp to clone to create a clone that recovers the
most recent backup data that is available for the Autonomous Database instance
(the clone source) from the database backup and logs backup.
After Autonomous 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;