Restore a Pluggable Database

This article provides the details and procedure to restore a pluggable database.

A pluggable database can be restored from a backup. The following two types of restore are supported:

  • Out-of-place restore: You can restore a pluggable database by creating a container database from the backup, then selecting a pluggable database or a subset of them you want to restore on the new database.
  • In-place restore: You can restore a pluggable database within the same container database to its last known good state or to a specified timestamp.

You can perform an in-place restore when you want to move a pluggable database back to a specified state or time. Both the container database and pluggable database must be up and running, and only one pluggable database can be restored at a time.

  • If you have multiple pluggable databases in your container database and want to restore multiple of them to the same container database, then you could restore each individual pluggable database, one pluggable database at a time, from the container database backup.
  • When the container database is down, you can restore the complete container database, and all the pluggable databases in that container database will also be restored.
  • You could either restore the database to the specified time stamp or to its last known good state.

Related Topics

In-Place Restore

Perform the following steps to in-place restore a pluggable database using the OCI Console:

  1. On the DB Systems list page, select the DB system that contains the pluggable database that you want to work with. If you need help finding the list page or the DB system, see List the DB Systems.
  2. On the Databases tab, select the database that contains the pluggable database that you want to work with.
  3. On the Pluggable Databases tab, select the pluggable database that you want to work with.
  4. On the pluggable database details page, from the Actions menu, select Restore.
  5. In the Restore PDB panel, select one of the following restore options:
    • Restore to 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 timestamp specified.

    Note:

    SCN-based restore is not supported by the OCI Console but is available through the API and OCI CLI.
  6. Select Restore and confirm.

Out-of-Place Restore

Perform the following steps to out-of-place restore a pluggable database using the OCI Console:

  1. On the DB Systems list page, select the DB system that contains the pluggable database that you want to work with. If you need help finding the list page or the DB system, see List the DB Systems.
  2. On the Databases tab, select the database that contains the pluggable database that you want to work with.
  3. On the database details page, select Backups tab to view the list of database backups.
  4. From the Actions menu for the database backup that contains the pluggable databases you want to restore, select Create database.
  5. In the Create database from backup panel, provide details about the new DB system by following the instructions provided in Create a DB System from a Backup.