Restore a Pluggable Database
In-Place Restore
- Open the navigation menu. Select Oracle Database, then select Oracle Base Database Service.
- Select your Compartment. A list of DB systems is displayed.
- 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.
- In the list of databases, find the database containing the PDB you want to restore. Click the database name to display details about it.
- In the Resources section of the page, click Pluggable Databases.
- In the list of PDBs, find the PDB you want to restore. Click the PDB name to display details about it.
- From the PDB details page, click More actions, and then click Restore.
- 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. - Click Restore and confirm when prompted.
Out-of-Place Restore
- Open the navigation menu. Select Oracle Database, then select Oracle Base Database Service.
- Select your Compartment. A list of DB systems is displayed.
- 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.
- In the list of databases, find the database containing the PDBs you want to restore. Click the database name to display details about it.
- In the Resources section of the page, click Backups.
- In the list of backups, find the backup containing the PDBs you want to restore.
- Click the Actions menu (three vertical dots) for the backup, and then click Create database.
- 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.
- Click Next.
- 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.