Backup and Recover PDB /CDB

Backup CDB :

rman target=/
backup database plus archivelog;       -- backup root container(cdbb01) , PDBSeed and all pdbs

% rman target sys/<pw>@cdb1
RMAN> BACKUP DATAFILE 3,20; --datafile 3 from root and 20 from pdb


backup database root; -- backup system,sysaux and undo datafiles of root container(cdbb01)


% rman target sys/<pw>@cdb1
RMAN>BACKUP TABLESPACE CDB1:SYSTEM, CDB1:SYSAUX;


Backup PDB :


% rman target sys/<pw>@cdb1
backup pluggable database pdb01;       -- backup only datafiles of pdb01 after connecting to CDB

rman target= sys@pdb1
backup database;                       -- backup pdb after connecting to pDB


% rman target sys/<pw>@pdb1
RMAN>BACKUP TABLESPACE PDB1:SYSTEM, PDB1:SYSAUX;




Recovery PDBS :


% rman target sys/<pw>@pdb1
Run
{
Alter pluggable database pdb1 close;                      -- recover pluggable database
restore pluggable database pdb1
recover pluggable database pdb1
Alter pluggable database pdb1 open;
}


% rman target sys/<pw>@pdb1
Run
{
Alter pluggable database pdb1 close;
SET until time "SYSDATE - 10/24/60";
restore pluggable database pdb1
recover pluggable database pdb1
Alter pluggable database pdb1 open resetlogs;
}


% rman target sys/<pw>@pdb1
Run
{
ALTER TABLESPACE USERS OFFLINE -- Tablespace lost
RESTORE TABLESPACE USERS;
RECOVER TABLESPACE USERS;
ALTER TABLESPACE USERS ONLINE;
}


% rman target sys/<pw>@pdb1
Run
{
ALTER DATABASE DATAFILE 10 OFFLINE; -- datafile lost
RESTORE DATAFILE 10;
RECOVER DATAFILE 10;
ALTER DATABASE DATAFILE 10 ONLINE;
}



% rman target /
Run
{ -- system datafile lost. Restore must be done from ROOT.
RESTORE DATAFILE 10;
RECOVER DATAFILE 10;
ALTER DATABASE DATAFILE 10 ONLINE;
}



Recovery Root database :

% rman target sys/<pw>@cdb1
Run
{
RESTORE DATABASE ROOT;
RECOVER DATABASE ROOT;
}


Recovery Whole CDB

% rman target sys/<pw>@cdb1
Run
{
RESTORE DATABASE ;
RECOVER DATABASE;
}