Databases Reference
In-Depth Information
Backing Up Tablespaces and Data Files in a PDB
Problem
You want to back up specific tablespaces or data files in a PDB.
Solution
Follow these steps to back up a tablespace in a pluggable database.
1.
Start RMAN and connect to the pluggable database as a local user.
2.
Issue the following command to back up tablespaces. In our example, we want to back up
the tablespaces
users
and
example
.
RMAN> backup tablespace users, example;
To back up data files belonging to a pluggable database, follow these steps.
1.
Start RMAN and connect to the pluggable database as a local user.
2.
Isssue the following command to back up tablespaces. In our example, we want to back up
the data files 9 and 10.
RMAN> backup datafile 9, 10;
How It Works
If you have multiple pluggable databases, it's possible that you may have tablespaces with identical names in different
PDBs. This is why you must first connect to a specific PDB before backing up its tablespaces. Doing this ensures you
are backing up the correct tablespace.
Data files, however, are different in this regard—each data file is uniquely identified by the data file number as
well as the file's path. Therefore, it's safe to back up data files of a specific PDB after connecting to either the root or a
PDB. By connecting to a specific PDB, you can back up up data files belonging only to that PDB. You can back up data
files belonging to multiple PDBs by connecting to the root.
