Backup and Restore Notes

Provides notes for automatic backups, long-term backups, and restoring your database.

• Files on Object Store: For external tables, partitioned external tables, and the external partitions of hybrid partitioned tables, backups do not include the external files that reside on Object Store. Thus, for operations where you use a backup to restore your database, such as Restore or Clone from a backup, 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.

• After you provision or clone an Autonomous AI Database instance, it may take up to 4 hours before an automatic backup is available. See View Backup Information and Backups on Autonomous AI Database to find out if a backup exists.

• See Restore and Recover your Autonomous AI Database for information on Restore.

  See Clone an Autonomous AI Database from a Backup for information on Clone from a backup.

• Stopped Database: If the database is stopped one final push, of the remaining data changes before the stop, is sent to Automatic Backup storage until the database is started again. No additional backups are displayed in the backup list until the database is started again.

• Manual Backups: The Oracle Cloud Infrastructure Console does not provide the option to create a manual backup. If required, manual backups can be performed using the API. See CreateAutonomousDatabaseBackup for more information.

• Sample Data Sets SH and SSB: The sample data sets are not included in backups and do not impact the size or speed of either backup or restore operations.

Long-Term Backup Notes

• Long-term backups are retained and managed by Oracle for the specified retention period you select when you create or schedule long-term backups.

• Each long-term backup creates a full backup and the backup can only be used from the Autonomous AI Database instance to clone a new database.

• After the long-term retention period is over a backup will be deleted and is no longer retained.

• The encryption key option that is selected when a long-term backup is created applies when you create a clone from the long-term backup. If a customer-managed master encryption key is in use at the time a long-term backup is created, then the same customer-managed master encryption key must be available to access a database that you clone from the long-term backup.

  See Manage Encryption Keys on Autonomous AI Database for more information.

• While backing up a database, the database is fully functional. However, during a long-term backup certain lifecycle management operations, such as stopping the database may affect the backup. See Long-Term Backup with Concurrent Operations for more information.

• Cloning from a long-term backup creates a new database with the most current available database version, which is possibly not the original database version in use at the time when the long-term backup was created. A database cloned from a long-term backup uses latest available database version.

  For example, if a long-term backup is taken on a database with version 19c, and then 4 years later the long-term backup is used to clone a new database, the new database may only offer the latest database version (for example Oracle AI Database 26ai, if version 19c is not available).

• Long-term backups are only accessible while a database exists. If you terminate an Autonomous AI Database instance, you no longer have access to long-term backups. If you want to retain long-term backups and minimize costs:

  1. Drop all tables and scale down the database to the minimum storage.

  2. Stop the database.

  This preserves the long-term backups that were created for the Autonomous AI Database instance.