Example: Restoring and Recovering PDBs
The multitenant architecture, introduced in Oracle Database 12c Release 1, enables an Oracle Database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). All Oracle databases before Oracle Database 12c are non-CDBs.
A CDB includes the following components: root, seed, and user-created PDBs. The root stores the common users and Oracle-supplied metadata such as the source code for Oracle-supplied packages. The seed is a template that can be used to create new PDBs. A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB.
This section demonstrates various restore and recovery scenarios for PDBs. The steps to restore and recover a PDB are similar to those used for restore and recover operations on non-CDBs. This section contains the following examples:
Performing Complete Recovery of the Whole PDB
This example demonstrates how to perform complete recovery for a PDB in the protected database.
To restore and recover a whole PDB:
Performing Point-in-Time Recovery for the Whole PDB
This example demonstrates how to perform point-in-time recovery for one or more PDBs in your protected database. Specify the SET UNTIL
clause to indicate the point to which the PDB must be recovered.
To restore and recover a PDB to a specific point-in-time:
Recovering Specific Data Files in a PDB
Restoring and recovering data files in a PDB is similar to restoring and recovering any data file using RMAN. This example demonstrates how to restore and recover a data file in a PDB.
To restore and recover a specific data file in a PDB:
Recovering Specific Tablespaces in a PDB
This example demonstrates how to restore and recover the tablespace USR_TBS
contained in the PDB SH_PDB
in your protected database.
Restoring and recovering a tablespace in a PDB is similar to a normal tablespace restore and recovery. The difference is that you need to map the tablespace to the pluggable database (pdb_name:tablespace_name
).
To restore and recover specific tablespaces in a PDB: