Oracle Cloud Infrastructure Documentation

Restore Base Database

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 Oracle Base Database Service and then select DB Systems.
  2. Select your Base Database that you are using.
  3. Select the More actions button, and then select the Restore.This screenshot shows how to perform point-in-time restore on Container Database.
  4. From the Restore page, select Restore to a timestamp as your Restore type.
  5. Specify your Restore date and Restore timestamp.
  6. Select the Restore button.perform point-in-time restore on Container Database in the OCI console
  7. Navigate back to Database information tab to view the State of the restore process.perform point-in-time restore on Container Database in the OCI console

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

  1. From the OCI console, select Oracle Database and Oracle Base Database Service.
  2. Select DB Systems and then select the database that you are using.
  3. Select the Pluggable Databases tab, and then select the PDB that you want to restore.
  4. Select the More actions button, and then select the Restore. This screenshot shows perform point-in-time restore on Pluggable Database.
  5. From the Restore page, select Restore to a timestamp as your Restore type.
  6. Specify your date and time.
  7. Select the Restore button.This screenshot shows perform point-in-time restore on Pluggable Database.
  8. Return to the Pluggable Database to view the State of the restore process.This screenshot shows perform point-in-time restore on Pluggable Database.

Restore from Automatic or Manual Backup

These are the steps to restore a database from Automatic or Manual Backup.

  1. From the OCI console, select Oracle Base Database Service and then select DB Systems.Optionally, you can select the compartment from the Applied filters.
  2. Select DB Systems, and then select the database that you are using.
  3. Select the Backups tab.
  4. From the backup list, select your backup, and then click the three-dot navigation menu.
  5. Select the Create database.This screenshot shows how to restore a database from automatic or manual backup.
  6. From the Create Database from Backup page, complete the following substeps:
    1. Choose the All PDBs option from PDB section.
    2. Select your preferred Subscription, Compartment, Region and Availability Domain from the dropdown list.
    3. The Shape and Storage fields are selected by default.This screenshot shows how to restore a database from automatic or manual backup.
    4. The Choose Software section allows you to provide SSH public key soure , Use existing key stored in Azure, and Use existing public key as Generate new key pair,
      1. The Generate new key pair option allows you to provide Key pair name, generated automatically and stored with the provided name.
      2. The Use existing key stored in Azure option allows you to select key from Azure Key Vault Stored keys.
      3. The Use existing public key option allows you to provide an RSA public key in either the single-line format starting with ssh-rsa or the multi-line PEM format. You can generate SSH keys using ssh-keygen on Linux and macOS, or PuTTYGen on Windows. For more information , see generate SSH Key.
      This screenshot shows how to restore a database from automatic or manual backup.
    5. The Choose Software section allows you to select either Select License Included or Bring Your Own License .
    6. From the Network Information section, select your Compartment, Virtual Cloud Network and Client Subnet from the dropdown lists. Enter a Hostname .
    7. From the Network Information section, you can select either the Automatically assign IPv4 addresses from subnet or Manually assign IPv4 addresses option.This screenshot shows how to restore a database from automatic or manual backup.
    8. Enter a descriptive database name in the Database name field that helps you easily identify the resource.
    9. Enter a descriptive database name in the Database unique name suffix field that helps you easily identify the resource.
    10. Enable the Unified Auditing option.
    11. If you want to change the database image, click on the Change database image button.
    12. Enter your Password, Confirm password and TDE's wallet or RMAN password. This screenshot shows how to restore a database from automatic or manual backup.
    13. Select the Create button.
  7. Return to the DB Systems to view the State of your restore process.