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.

Prerequisites

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.

Note:

  • 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.

Related Topics

Available Restore Options

The following restore options are available for the database.

  • Restore to the latest: Restores the database to the last known good state with the least possible data loss.
  • Restore to a timestamp: Restores the database to the timestamp specified.

  • Restore to SCN: Restores the database using the System Change Number (SCN) specified. This SCN must be valid.

    Note:

    You can determine the SCN number to use either by accessing and querying your database host or by accessing any online or archived logs.

Restoring a Database

Perform the following steps to restore a database.

  1. Open the navigation menu. Select Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the name of the DB system that contains the database you want to restore.
  4. The details of the DB system followed by a list of databases are displayed.
  5. In the list of databases, click the name of the database you want to restore.
  6. The details of the database are displayed.
  7. On the Database Details page, click Restore.

    Note:

    You can also access the list of backups by clicking on Backups under Resources.
  8. Select one of the following restore options:
    • Restore to the latest: Restores the database to the last known good state with the least possible data loss.
    • Restore to a timestamp: Restores the database to the timestamp specified.

    • Restore to SCN: Restores the database using the System Change Number (SCN) specified. This SCN must be valid.

      Note:

      You can determine the SCN number to use either by accessing and querying your database host or by accessing any online or archived logs.
  9. Click Restore database and confirm when prompted.

    If the restore operation fails, the database will be in a "Restore failed" state. You can try restoring again using a different restore option. However, Oracle recommends that you review the RMAN logs on the host and fix any issues before reattempting to restore the database.

Note:

If the database you are restoring was configured to use customer-managed encryption keys after the specified timestamp or SCN, the database will be restored without customer-managed keys enabled. You can change the encryption settings after restoring to use customer-managed keys. For more information, see Database Encryption Keys.