Backup and Restore Autonomous Database on Dedicated Exadata Infrastructure
To support high availability, Autonomous Database on Dedicated Exadata Infrastructure automatically backs up your database for you. The retention period for backups is up to 95 days based on the Backup Retention Policy chosen for the Autonomous Container Database (ACD). You can restore and recover your database to any point-in-time in this retention period.
While backing up a database, the database is fully functional; however, during the backup, life cycle management operations are not allowed. For example, stopping the database is not allowed during the backup. Terminating an Autonomous Database deletes all of its automatic and manual backups, including long-term backups.
About Backup and Recovery
By default, Autonomous Database is configured to back up your database periodically. You can disable automatic backups while provisioning an ACD and enable them from the Oracle Cloud Infrastructure (OCI) console anytime later. Once the automatic backups are enabled you can not disable them for an ACD.
Autonomous Databases on Oracle Public Cloud are backed up to Object Storage with daily incremental backups and weekly full backups or Autonomous Recovery Service with daily virtual full backups, depending on their backup destination.
Note:
You can not disable automatic backups while provisioning an ACD with Autonomous Data Guard.With automatic backups enabled, you have an option to take any of the following additional backups:
-
Cross region backups, also known as remote backups, are backups stored in a different region than the source database. This backup option is only available for ACDs deployed on Oracle Public Cloud. In case of a region failure, you can use this backup to recover your database.
Cross region backups:
- Are additional backups on top of the default automatic backups. They are like a second backup taken in a region that you've selected.
- Are supported only at the ACD level and include all Autonomous Databases within the ACD, as well as all archive logs.
- Are exclusively intended for cloning into a new ACD and cannot be used for in-place restore operations.
- Can be cloned into a different Autonomous Exadata VM Cluster (AVMC). See Clone an Autonomous Container Database from Backup for instructions.
Note:
Cross-region backups can only be enabled on ACDs configured without Autonomous Data Guard. - Long-term backups are the backups that are retained beyond the backup
retention policy (period) defined at the ACD level. When creating a long-term
backup, you can specify its retention period, ranging from 90 days to 10 years.
Long-term backups:
- Are exclusively intended for cloning into new Autonomous Databases and cannot be used for Autonomous Database in-place restore operations.
- Are supported only at the Autonomous Database level and are only available while the Autonomous Database exists.
- Cannot be taken on Autonomous Databases that reside in an ACD that has not enabled backups.
-
Manual Backups are on-demand backups taken manually from the OCI console. For example, before making a significant update to your application, you can take a manual backup as an option to restore and recover later.
Manual backups:- Are cumulative incremental backups containing all the incremental backups from the last full backup.
- Are retained for up to 95 days, depending on the backup retention policy (period) chosen for the ACD.
- Are supported only at the Autonomous Database level.
Backup Retention Policy (Period)
You can define the backup retention policy/period while provisioning an ACD or modify it later from its details page on the Oracle Cloud Infrastructure console.
On Oracle Public Cloud and Multicloud deployments, the backup retention policy value defaults to 15 days and can be changed to any value between 7 to 95 days.
- You can not modify the backup retention policy if you use Recovery Appliance or Local Storage as your ACD’s backup destination. In the case of Recovery Appliance, this value is controlled by the Recovery Appliance protection policy.
- For Object Storage and Network File System (NFS) backup destination types, the backup retention policy defaults to 30 days and can be changed to any value between 7 to 95 days.
Backup Destination
You can associate a backup destination for the backups of Autonomous Databases created in an ACD. On Exadata Cloud@Customer and Autonomous Database on Oracle Database@AWS deployments, you can choose a backup destination from the available options while provisioning the ACD.
By default, backup destination is set to Object Storage for Autonomous Databases deployed On Oracle Public Cloud. However, you can set Autonomous Recovery Service as the backup destination for all the ACDs provisioned in a specific compartment, by submitting a service request (SR). Upon the SR completion, any new ACDs provisioned in the specified compartment will default its backup destination to Autonomous Recovery Service.
On Oracle Public Cloud and Autonomous Database on Oracle Database@AWS deployments, backup destination cannot be changed after provisioning the ACD.
Table - Backup destination options
| Backup destination type | Supported Deployments | Notes |
|---|---|---|
| Object Storage |
Autonomous Database on Oracle Public Cloud Autonomous Database on Exadata Cloud@Customer Autonomous Database on Oracle Database@AWS |
Stores weekly full and daily incremental backups in an Oracle-managed object storage container on Oracle Cloud Infrastructure. For Exadata Cloud@Customer deployments, if you choose Object Storage as the type, you can optionally specify an internet HTTP proxy to use when connecting to the storage container. Oracle recommends using a proxy when possible for enhanced security. |
| Autonomous Recovery Service (ARS) |
Autonomous Database on Oracle Public Cloud |
Store daily virtual full backups. To create an ACD with Autonomous Recovery Service as its backup destination, you must have submitted a service request (SR) before provisioning the ACD. This SR will default Autonomous Recovery Service as the backup destination for any new ACDs provisioned in the specified compartment. See Create a Service Request in My Oracle Cloud Support for instructions. |
| Network File System (NFS) |
Autonomous Database on Exadata Cloud@Customer |
Stores backups in a Network File System (NFS) storage location. If you choose Network File System (NFS) as the type, select an already defined backup destination that uses Network File System (NFS) storage. See Prerequisites for Backup Destinations for Exadata Cloud@Customer before configuring backup destinations on an NFS storage for Exadata Cloud@Customer |
| Recovery Appliance |
Autonomous Database on Exadata Cloud@Customer |
Stores backups in one of your previously defined backup destinations that uses Oracle Zero Data Loss Recovery Appliance. If you choose Recovery Appliance as the type, select a previously defined backup destination that uses Oracle Zero Data Loss Recovery Appliance, the Note: Make sure to provide the connection string that connects to the recovery appliance in an Oracle "easy connect" string format, that is,<host>:<port>/<service name>, where <host> is the SCAN hostname of the Zero Data Loss Recovery Appliance.
See Prerequisites for Backup Destinations for Exadata Cloud@Customer before configuring backup destinations on a Zero Data Loss Recovery Appliance location for Exadata Cloud@Customer |
| Local |
Autonomous Database on Exadata Cloud@Customer |
Stores backups on the local Exadata storage. This option is only available if you have configured Local storage while creating the Autonomous Exadata VM Cluster. Once an ACD is created with a backup destination type anything other than Local, it cannot be changed to Local backups later. |
| AWS S3 | Autonomous Database on Oracle Database@AWS | Stores backups on AWS Object Storage. |
Changing Backup Destinations
APPLIES TO: 
Exadata Cloud@Customer APPLIES TO: Multicloud
Table - Changing Backup Destinations
| Current backup destination type | New backup destination types that are supported | Notes |
|---|---|---|
| Local | - | You cannot change the backup destination type if the current type is local. |
| Network File System (NFS) |
NFS RA |
- |
| Object Storage |
RA |
- |
| Recovery Appliance (RA) |
RA NFS Object Storage |
Changing the backup destination type from RA to Object Storage is only supported if the ACD was originally configured with Object Storage backups first. |
Restore and Recover
- Use a specific backup for restoring the database
- Use a timestamp for point in time recovery from the OCI console
- Use a specific System Change Number (SCN) for restoring the database from the OCI console
The database goes into the unavailable state while restore is in progress. You cannot connect to the database in this state. The only life cycle management operation supported in unavailable state is terminate. When the restore operation finishes, your database is opened in the same state as before restoration. For all three types of restore (by SCN, by timestamp or by using specific backup) an SCN will be returned when the restore is completed.
When your database is restored, the value of the ADMIN user password is also restored. Therefore, it may have an old value that you no longer remember. You can set the password to a new value as described in Unlock or Change the ADMIN Database User Password.
After restoring your database, all backups between the date the restore completes and the date you specified for the restore operation - the restore time - are invalidated. You cannot initiate further restore operations to any point in time between the restore time and restore completion time. You can only initiate new restore operations to a point in time older than the restore time or more recent than the time when the actual restore succeeded.
In an Autonomous Data Guard setup:
- You can only restore a backup from the primary database.
- Database restore is not allowed if the standby database is in snapshot standby role. You must convert the standby Autonomous Container Database (ACD) to physical standby role to restore this database. See Convert Snapshot Standby to Physical Standby for instructions.
Backup and Restore Operations
| Operation | Details | Further Reference |
|---|---|---|
| Create a manual backup | You can create a manual (on-demand) backup from the Details page of an ACD on the OCI console. | Backup Your Autonomous Database Manually |
| Create a long-term backup | You can create a long-term backup from the Details page of an ACD on the OCI console. | Create a Long-Term Backup |
| Clone from a backup |
You can create a point-in-time copy of a backup set of your Autonomous Database. You can clone from an automatic backup, manual backup (chosen from the list of backups or based on a timestamp), or a long-term backup. |
For complete details about cloning from a backup, its requirements and limitations, refer to About Cloning Autonomous Database on Dedicated Exadata Infrastructure For instructions on cloning a manual or long-term backup from the OCI console, see Clone Autonomous Database from Backup. For instructions on cloning from an ACD backup, see Clone Autonomous Container Database from Backup. |
| Edit backup settings | You can enable automatic backups (if disabled while provisioning the ACD) and modify the following backup settings from the Details page of an ACD from the OCI console:
|
For complete details about editing the backup settings, see Edit Autonomous Container Database Backup Settings. |
| Update a long-term backup | You can edit the retention period of a long-term backup or even delete a long-term backup from the Details page of an ACD on the OCI console. | Manage Long-Term Backups |
| Restore and recover your Autonomous Database | You can either restore the database from a specific backup or use a timestamp for point-in-time recovery from the Details page of the ACD on the OCI console. | Restore and Recover Your Autonomous Database |
| View Remote Backups | You can view a list of remote backups in a region from the OCI console. | View a List of Remote Backups |
| Clone an ACD from Backup | You can recover your database by cloning an ACD from a remote backup into an AVMC in a different region than the clone source. | Clone an Autonomous Container Database from Backup |
You can also use API to perform backup and restore operations. For more details, see API Reference for Autonomous Database on Dedicated Exadata Infrastructure.
Backup and Restore Events
Oracle Database resources emit events, which are structured messages that indicate changes in resources. There are multiple events associated with database backup operations. You can find them in Events for Autonomous Database on Dedicated Exadata Infrastructure