Restore Exadata Database

This topic explains how to restore an Exadata Database.

Container Database (CDB) Point-in-Time Restore

These are the steps to perform a point-in-time restore on the Container Database in the OCI console.

  1. From the OCI console, select the Oracle Exadata Database on Dedicated Infrastrucutre.
  2. Select Exadata VM Clusters that you are using.
  3. Select Exadata Database (CDB), and select the database that you are using.
  4. Select the More actions button, and then select the Restore. This screenshot shows how to restore Container Database (CDB) Point-in-Time.
  5. From the Restore Database page, select the restore type Restore to latest, Restore to a timestamp, Restore to SCN depending upon your requirement.This screenshot shows how to restore a database.
  6. Specify your Restore date and Restore timestamp.
  7. Select the Restore button.
  8. Return to the Exadata Database (CDB) to view the State of your restore process.This screenshot shows how to view the State of your restore process of Exadata Database (PDB).

Pluggable Database (PDB) Point-in-Time Restore

These are the steps to perform a point-in-time restore on the Pluggable Database in the OCI.

  1. From the OCI console, select the Oracle Exadata Database on Dedicated Infrastrucutre.
  2. From the Exadata VM Clusters page, select Exadata VM Cluster that you are using.
  3. From the Databases tab, select the container database that you are using.
  4. From the Pluggable Databases tab, select the pluggable database that you want to restore.
  5. From the More actions dropdown, select Restore.
  6. From the Restore PDB page, select Restore to a timestamp as your Restore type.
  7. Specify your date and time.
  8. Select the Restore button.
  9. Return to the Database information page to view the State of your restore process.This screenshot shows how to perform a point-in-time restore.

Restore from Automatic or Standalone Backup

These are the steps to restore an Exadata Database from Automatic or Standalone Backp.

  1. From the OCI console, select the Oracle Exadata Database on Dedicated Infrastrucutre.
  2. From the Exadata VM Clusters page, select Exadata VM Cluster that you want to restore
  3. Select the Databases tab, and select Container Database (CDB) that you are using.
  4. Select the Backups tab.
  5. From the backup list, select your backup, and then click the three-dot navigation menu.
  6. Select the Create database.
  7. From the Create Database from Backup page, complete the following substeps:
    1. Choose the All PDBs option from PDB section.
    2. Select your preferred Region from the list. Select the region where you want to create the backup.
    3. The Availability domain is selected as default.
    4. Select your Compartment and VM Cluster from the dropdown lists.
    5. Navigate to Database Home section, and then choose the Select an existing Database Home option. From the Create Database Home dropdown list, select your Database Home.
    6. Specify a Database name that helps you easily identify the resource.
    7. Specify a Database unique name that helps you easily identify the resource.
    8. Enter your Password, Confirm password and TDE's wallet or RMAN password.
    9. Select the Create button.
  8. Return to the Exadata VM Clusters to view the State of your restore process.This screenshot shows how to restore a database from automatic or standalone backup.