Backup a CDB/PDB

• To make a database backup you need the SYSBACKUP or SYSDBA privilege.
• You can backup the CDB and all the PDBs independantly, all together, or by specifying a list.
• You can backup a PDB by connecting directly to it and use:
  • RMAN> BACKUP DATABASE:
• You can backup a PDB by connecting to the CDB and use:
  • RMAN> BACKUP PLUGGABLE DATABASE MY_PDB;
• To backup only the root (CDB$ROOT) connect to the CDB and use:
  • RMAN> BACKUP DATABASE ROOT;
• You can backup everything by connecting to the CDB and use:
  • RMAN> BACKUP DATABASE;
• You can backup only some PDBs by using:
  • RMAN > BACKUP PLUGGABLE DATABASE PDB1, PDB2, PDB3;

Backup tablespaces and datafiles in CDBs/PDBs

• You can backup tablespaces from several PDBs at the same time when connected to the root using:
  • RMAN> BACKUP TABLESPACE PDB1:USERS, PDB2:TOOLS, PDB3:SYSTEM;
• You can also backup tablespaces using the standard command when you connect directly to the PDB:
  • RMAN> BACKUP TABLESPACE SYSTEM;
• To backup datafiles for a PDB you can :
  • Connect to the root and use : BACKUP DATAFILE 12,13,14;
  • Connect to the PDB and use : BACKUP DATAFILE 12,13,14;

Restore and recover a CDB/PDB

• To perform a recover of the whole CDB use:
  • RMAN> RESTORE DATABASE;
  • RMAN> RECOVER DATABASE;
• To recover only the root, place the CDB in mount state and use:
  • RMAN> RESTORE DATABASE ROOT;
  • RMAN> RECOVER DATABASE ROOT;
• To prevent metadata inconsistenties ,Oracle recommends to restore the PDBs with the root, to restore the PDBs use the following command:
  • RMAN> RESTORE PLUGGABLE DATABASE PDB1, PDB2, PDB3;
  • RMAN> RECOVER PLUGGABLE DATABASE PDB1, PDB2, PDB3;
• To restore a specific PDB follow these steps:
  • RMAN> ALTER PLUGGABLE DATABASE PDB1 CLOSE;
  • RMAN> RESTORE PLUGGABLE DATABASE PDB1;
  • RMAN> RECOVER PLUGGABLE DATABASE PDB1;
  • RMAN> ALTER PLUGGABLE DATABASE PDB1 OPEN;

Restore and recover a CDB/PDB tablespace or datafile

• To restore a tablespace of a PDB database, connect to the root and use:
  • RMAN> RESTORE TABLESPACE PDB1:USERS;
  • RMAN> RECOVER TABLESPACE PDB1:USERS;
• To restore a PDB datafile, connect to the root and use:
  • RMAN> RESTORE DATAFILE 12;
  • RMAN> RECOVER DATAFILE 12;
• The previous operations can also be done by connecting directly to the PDB.
• The procedure to make a PITR of a PDB is :

RUN 
{
SET UNTIL TIME 'time';
RESTORE PLUGGABLE DATABASE PDB1;
RECOVER PLUGGABLE DATABASE PDB1;
AUXILIARY DESTINATION='/u01/app/oracle/oradata_aux';
}
ALTER PLUGGABLE DATABASE PDB1 OPEN RESETLOGS;

• The procedure to make a PITR of a PDB tablespace is:

RUN 
{
RECOVER TABLESPACE PDB1:USERS UNTIL TIME 'time'
AUXILIARY DESTINATION='/u01/app/oracle/oradata_aux';
}

Performing flashback for a CDB

• The flashback operation for a CDB is the same as for a standard database
• YOU CAN’T flashback a CDB to a point in time earlier than the time when you made a PDB PITR.
• YOU CAN’T flashback a PDB.