Monday, August 5, 2013

Oracle 12c New Feature: How to backup pluggable databases

Oracle 12c introduced the new multi-tenant feature called Pluggable Databases (PDB). We will show how to take a backup of the pluggable database components in this post.

Setup for RMAN with Oracle 12c

In order to use the Oracle 12c Recovery Manager (RMAN) utility for pluggable database backups, you need to first enable archivelog mode.

Once archivelog mode is enabled, we can take a backup of the pluggable database

Now we can verify that the backup image is available from RMAN for our pluggable database

Backup for root component of Oracle 12c Pluggable Databases

In a nutshell, an Oracle 12c PDB consists of two parts: a root component and a seed component that includes the data. Earlier we performed a full database backup of the entire pluggable database but let us say that we just want to backup the root itself. We can do so with the RMAN command BACKUP DATABASE ROOT as shown in the following example:

Now let us verify the root backup for our PDB with Oracle 12c:

Stay tuned when we visit how to restore pluggable databases with RMAN and Oracle 12c!

No comments: