17 Cloning, Moving, or Upgrading an Autonomous Data Warehouse Database

Autonomous Data Warehouse provides cloning where you can choose to clone either the full database or only the database metadata. You can also use cloning to upgrade your database to a newer Oracle Database version if your region has multiple Oracle Database versions available (some regions only have one Oracle Database version). You can move an Autonomous Data Warehouse database to a different Oracle Cloud Infrastructure compartment.

When you clone an Autonomous Data Warehouse instance, you have the option to select the clone source:

  • Clone from a database instance. This creates a clone of a running database.

  • Clone from a backup. This creates a clone when you select a backup from a list of backups, or when you enter a backup point-in-time to clone.

When you perform the clone operation you can select a newer Oracle Database version for the target database. This allows you to use cloning to upgrade your Autonomous Data Warehouse database.

If your Autonomous Database instance is using Oracle Database 18c you can manually upgrade to Oracle Database 19c.

When an upcoming release is available for preview with Autonomous Database, you can clone your existing database or clone a backup, to use the preview version. A preview version is only available when there is an upcoming major version to release. At times no preview version will be available.