Backup and Recovery of PDBs

You can perform backup and recovery operations on a single pluggable database (PDB) or on multiple PDBs. Although the Oracle Recovery Manager (RMAN) commands are the same, the syntax used to perform operations on multiple PDBs contains some modifications.

To perform backup and recovery operations on a single PDB, you can connect as TARGET to the PDB or to the root.

  • If you connect to the PDB, use the same commands that you would use to backup or recover non-CDBs. For example, to back up a PDB, use the BACKUP DATABASE command.

  • If you connect to the root, use the PLUGGABLE DATABASE clause in your RMAN commands.

    The following command backs up the PDB hrpdb when connected to the root:

    BACKUP PLUGGABLE DATABASE hrpdb;
    

To perform backup and recovery operations on multiple PDBs using a single command, you must connect to the root. Use the PLUGGABLE DATABASE clause followed by the list of PDBs on which you want to perform the operation. The following example backs up the PDBs hrpdb, salespdb, and invpdb when connected to the root:

BACKUP PLUGGABLE DATABASE hrpdb, salespdb, invpdb;

Note:

Certain operations are not available when you connect directly to a PDB. See Oracle Database Backup and Recovery User's Guide for a list of these operations.