RMAN New Features Oracle 12c

Nowadays keeping up with time is the core of our job so every now and again it's necessary to go over the new Oracle database release even if there isn't an immediate necessity.

In this post I would like to talk about the RMAN new features in a multitenant environment.

Let's get down this post, shall we ?

According to the Oracle 12c reference manual it is now possible to back up and recover an entire CDB and all PDBs or only the CDB root container and what's more only one or more PDBs within the CDB.

Let's start from the beginning !

1) Backup an entire CDB container and all the PDB included :

RMAN> connect target /
RMAN> backup database;

In case you need it's also possible to do a backup of all archive logs rewriting the previous command :

RMAN> connect target /
RMAN> backup database plus archivelog;

As you can see this command isn't so different from previous backup command release.

NB: Since we are connected to CDB level and what's more the redo plus archived log files are only created at this level, we have been able to backup the archive log. Otherwise it isn't possible when we are connected to PDB level.


2) Backup only PDB :

RMAN> connect target /
RMAN> backup pluggable database pdb11;

It's also possible to backup multiple PDBs within the same command:

RMAN> backup pluggable database pdb10,pdb11;

3) Backup only the root container:

RMAN> backup pluggable database 'CDB$root';

4) Partial backup of a PDB:

RMAN> connect target /
RMAN> backup tablespace users;pdb10;


More or less that's all about the new backup command in Oracle 12c.

Please remember that it's always necessary to go over these commands and what's more verify these in a Test environment.

See you in my next blog !

Byeee !!!