Restore a Pluggable Database

Perform the following steps to restore a Pluggable Database (PDB) using the Console.

Related Topics

In-Place Restore

  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, find the DB system containing the PDB you want to restore. Click the DB system name to display details about it.
  4. In the list of databases, find the database containing the PDB you want to restore. Click the database name to display details about it.
  5. In the Resources section of the page, click Pluggable Databases.
  6. In the list of PDBs, find the PDB you want to restore. Click the PDB name to display details about it.
  7. From the PDB details page, click More actions, and then click Restore.
  8. In the Restore PDB dialog, select one of the following restore options:
    • Restore to the latest: Restores the database to its last known good state with the least possible data loss.
    • Restore to a timestamp: Restores the database to the time stamp specified.

    Note:

    SCN-based restore is not supported by the Console but is available through the API and OCI CLI.
  9. Click Restore and confirm when prompted.

Out-of-Place Restore

  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, find the DB system containing the PDBs you want to restore. Click the DB system name to display details about it.
  4. In the list of databases, find the database containing the PDBs you want to restore. Click the database name to display details about it.
  5. In the Resources section of the page, click Backups.
  6. In the list of backups, find the backup containing the PDBs you want to restore.
  7. Click the Actions menu (three vertical dots) for the backup, and then click Create database.
  8. In the Create database from backup dialog, in the Configure PDB section, select one of the following restore options:
    • All PDBs: This includes all the PDBs from the backup.
    • Choose the PDBs to restore: You can specify one or more PDBs to be restored from the backup.
      • PDB name: A comma-separated list of PDB names to be restored.
  9. Click Next.
  10. Provide details in the DB system information and Database information sections by following the instructions provided in Create a DB System From a Backup Using the Console.