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;
}