December 5, 2020

How to take RMAN Backup in 12CR1(CDB/PDB) database

Posted by Shaik Ahmed Ali on December 05, 2020 in , | No comments

 Hello Everyone,

Today I am going to share with you how to take backup in Multitenant Architecture which came from the 12c Version of the Oracle database.

Let's get start:

Backup of the Whole database :


from the above screenshot, we can see that if we use a normal command which is "backup database" it's taking all container (Root, PDBseed, PDBS)

Now we will see if we want to take the  only CDB backup or only PDB backup:

Taking Backup of CDB(Root) :

Connect to RMAN using the below Command:

rman target /


Taking Backup of Single PDB :

connect to rman using the command "rman target /" and run the below command to take a single PDB backup as shown in the SS

Taking Backup of Multiple PDBS:

Command to take a backup of Multiple PDBS in a database is shown in the below SS.



Backup of single Tablespace in PDB:

The command to take a backup of the single tablespace is 

backup tablespace PDBNAME: TABLESPACENAME;


Backup of Multiple tablespaces in PDB:

the command for taking a backup of multiple TS in a PDB

backup tablespace PDBNAME: TABLESPACENAME1,TABLESPACENAME2;


Backup of Multiple data files:


Alternatively, we also have another way of taking backup by directly connecting to a specific PDB and taking backup as below 


If you are connecting to a specific PDB the files or tablespace which belongs to the PDB can only be backed up, so if you try to take a backup of other PDB or Datafiles you will receive an error as below 


Now I am trying to take a backup of other PDB while connected to different PDB 


So I receive an error while trying to take a backup of other PDB while connected to a different PDB. 

Hope my article help you understand taking the backup in Multitenant Architecture 

thanks for reading and feedback is appreciated 










0 comments:

Post a Comment