Recover a Database Using the Console

This article explains how to recover a database from an automatic backup stored in the Recovery Service or Object Storage using the Console.

For more information on backups, see Back Up and Recovery in Base Database Service.

You can recover a database using the Console, API, or by using RMAN.

Required IAM Policy

To use Oracle Cloud Infrastructure, you must be granted security access in a policy by an administrator. This access is required whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you get a message that you don’t have permission or are unauthorized, verify with your administrator what type of access you have and which compartment to work in.

If you're new to policies, see Getting Started with Policies and Common Policies.


The DB system requires access to the Recovery Service or the Object Storage service, including connectivity to the applicable Swift endpoint for Object Storage. Oracle recommends using a service gateway with the VCN to enable this access. The Recovery Service requires a dedicated network path in each database VCN.

For more information, see these topics:

You can use the Console to restore the database from an automatic backup that was created by using the Console or the API. You can restore to the last known good state of the database, or you can specify a point in time or an existing System Change Number (SCN). You can also create a new database by using a standalone backup.


  • The list of backups you see in the Console does not include any unmanaged backups (backups created directly by using RMAN or dbcli).
  • Restoring a database with Data Guard enabled is not supported. You must first remove the Data Guard association by terminating the standby database before you can restore the database.

Available Restore Options

Restoring a Database