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 about backups, see Back Up and Recovery in Base Database Service.

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 about setting up your VCN for the DB system, including the service gateway, see VCN and Subnets.

For more information about the Swift endpoints to use, see Can I use Oracle Cloud Infrastructure Object Storage as a destination for my on-premises backups?.

General Information

Before you begin, note the following:

  • The default password profile will be reset when you restore a DB system from a backup.
  • 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).
  • 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 Manage Encryption Keys.

Procedure

Perform the following steps to restore a database.

  1. Open the navigation menu. Select Oracle Database, then select Oracle Base Database Service.
  2. Select 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.
Note

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.