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.
See Also:
The following sections in the Oracle Database Backup and Recovery User's Guide provide detailed information about backing up and recovering PDBs: