Backup and Restore Autonomous Databases
About Backup and Recovery on Autonomous Database
Autonomous Database automatically backs up your database for you. The retention period for backups is up to 60 days depending on the Backup Retention Policy chosen for the Autonomous Container Database. You can restore and recover your database to any point-in-time in this retention period.
Manual Backups
You do not have to do any manual backups for your database as Autonomous Database backs up your database automatically. You can do manual backups using the cloud console; for example if you want to take a backup before a major change to make restore and recovery faster. When you initiate a point-in-time recovery Autonomous Database decides which backup to use for faster recovery.
Recovery
You can initiate recovery for your Autonomous Database using the cloud console. Autonomous Database automatically restores and recovers your database to the point-in-time you specify.
Listing Backups
The list of backups available for recovery is shown on the Autonomous Database Details page under Backups.
Restore and Recover Your Autonomous Database
To restore and recover your database to a point in time, do the following:
Note:
- 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.
Backup Your Autonomous Database Manually
In addition to automatic backups, Autonomous Database also allows you take manual backups.
Note:
While backing up a database, the database is fully functional; however during the backup lifecycle management operations are not allowed. For example, stopping the database is not allowed during the backup.
Backup and Restore Autonomous Databases
Copyright © 2021, Oracle and/or its affiliates.