Restoring an Autonomous Database

This topic describes how to restore an Autonomous Database from a backup. You can use the Oracle Cloud Infrastructure Console or the API to perform this task.

You can use any existing manual or automatic backup to restore your database, or you can restore and recover your database to any point in time in the 60-day retention period of your automatic backups. For point-in-time restores, you specify a timestamp, and your Autonomous Database decides which backup to use for the fastest restore.


Restoring Autonomous Database puts the database in the unavailable state during the restore operation. You cannot connect to a database in that state. The only lifecycle management operation supported in the unavailable state is terminate.


To restore Autonomous Databases, you must be given the required type of access in a policy  written by an administrator, whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you try to perform an action and get a message that you don’t have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which compartment  you should work in. See Authentication and Authorization for more information on user authorizations for the Oracle Cloud Infrastructure Database service. See Let database and fleet administrators manage Autonomous Databases for sample Autonomous Database policies. See Details for the Database Service for detailed information on policy syntax.

Using the Oracle Cloud Infrastructure Console

To restore an Autonomous Database from a backup
To restore an Autonomous Database using point-in-time restore

Using the API

Use the RestoreAutonomousDatabase API operation to restore your Autonomous Database from a backup.

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.