Recovering an Exadata Database from Object Storage

This topic explains how to recover an Exadata database from a backup stored in Object Storage by using the Console or the API. The Object Storage service is a secure, scalable, on-demand storage solution in Oracle Cloud Infrastructure. For information on backing up your Exadata DB system to Object Storage, see Managing Exadata Database Backups.

Required IAM Policy

To use Oracle Cloud Infrastructure, 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.

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

Using the Console

You can use the Console to restore the database from a backup in the Object Storage 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).

Note

The list of backups you see in the Console does not include any unmanaged backups (backups created directly by using bkup_api ).

Restoring an Existing Database

To restore a database
  1. Open the navigation menu. Under Oracle Database, click Bare Metal, VM, and Exadata.
  2. Choose your Compartment.

    A list of DB systems is displayed.

  3. Find the DB system where the database is located, and click the system name to display details about it.

    A list of databases is displayed.

  4. Find the database you want to restore, and click its name to display details about it.
  5. Click Restore.
  6. Select one of the following options, and click Restore Database:

    • Restore to the latest: Restores the database to the last known good state with the least possible data loss.
    • Restore to the timestamp: Restores the database to the timestamp specified.
    • Restore to System Change Number (SCN): Restores the database using the SCN specified. This SCN must be valid.

      Tip

      You can determine the SCN number to use either by accessing and querying your database host, or by accessing any online or archived logs.
  7. 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. These log files can be found in subdirectories of the /var/opt/oracle/log directory.

To restore a database using a specific backup from Object Storage
  1. Open the navigation menu. Under Oracle Database, click Bare Metal, VM, and Exadata.
  2. Choose your Compartment.

    A list of DB systems is displayed.

  3. Find the DB system where the database is located, and click the system name to display details about it.

    A list of databases is displayed.

  4. Find the database you want to restore, and click its name to display details about it.
  5. Under Resources, click Backups.

    A list of backups is displayed.

  6. Click the Actions icon (three dots) for the backup you are interested in, and then click Restore.
  7. Confirm when prompted.