Backup of CDB & PDB

Backup & Recovery in CDB

------------------------

Full Database Backup

a       Backup whole Database including CDB and PDB, Connect to the CDB root and execute Backup Database.

RMAN> run

 {

 allocate channel a1 device type disk format '/oracle/bkp_seccdb/bkp_inc_1_%U_%T';

 allocate channel a2 device type disk format '/oracle/bkp_seccdb/bkp_inc_1_%U_%T';

 backup incremental level 0 database;

 sql 'alter system switch logfile';

 backup archivelog all delete input;

 release channel a1;

 release channel a2;

 }

Container Backup / Pluggable Database Backup

a   Partital Backup, to backup a particular Container. Either the CDB of the PDB.

RUN

{

 allocate channel a1 device type disk format '/oracle/bkp_seccdb/bkp_inc_0_%U_%T';

 backup pluggable database cdb$root;

 release channel a1;

}

RMAN> run

{

 allocate channel a1 device type disk format '/oracle/bkp_seccdb/hr_depts_pdb_backup_%U_%T';

 backup pluggable database hrdepts;

}

     

RMAN> run

{

 allocate channel a1 device type disk format '/oracle/bkp_seccdb/hr_depts_pdb_backup_%U_%T';

 backup pluggable database ‘CDB$ROOT’, pdb_purchase;

}

(OR) Connect directly to the PDB and execute Backup database.

rman target  sys@hr_seccdb

RMAN> run

 {

 allocate channel a1 device type disk format '/oracle/bkp_seccdb/hr_depts_pdb_backup_%U_%T';

 backup  database ;

 }

Tablespace Backup

Backup cdb users tablespace.

RMAN> run

{

allocate channel a1 device type disk format '/oracle/bkp_seccdb/cdb_user_tbl_%U.bkp';

backup tablespace users;

}

Backup hrdepts pdb users tablespace.

RMAN> run

{

allocate channel a1 device type disk format '/oracle/bkp_seccdb/pdb_users_tbl_%U.bkp';

backup tablespace hrdepts:users;

}

Data file backup.

RMAN> report schema;

using target database control file instead of recovery catalog

Report of database schema for database with db_unique_name SEC_CDB

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    800      SYSTEM               YES     /oracle/product/oradata/sec_cdb/system01.dbf

3    750      SYSAUX               NO      /oracle/product/oradata/sec_cdb/sysaux01.dbf

4    870      UNDOTBS1             YES     /oracle/product/oradata/sec_cdb/undotbs01.dbf

5    260      PDB$SEED:SYSTEM      NO      /oracle/product/oradata/sec_cdb/pdbseed/system01.dbf

6    5        USERS                NO      /oracle/product/oradata/sec_cdb/users01.dbf

7    570      PDB$SEED:SYSAUX      NO      /oracle/product/oradata/sec_cdb/pdbseed/sysaux01.dbf

11   50       MANZOOR              NO      /oracle/product/oradata/sec_cdb/manzoor01.dbf

26   850      PDB_PURCHASE:SYSTEM  NO      /opt/oracle/oradata/pdb_purchase/system01.dbf

27   900      PDB_PURCHASE:SYSAUX  NO      /opt/oracle/oradata/pdb_purchase/sysaux01.dbf

28   5        PDB_PURCHASE:USERS   NO      /opt/oracle/oradata/pdb_purchase/users01.dbf

29   850      PDB_HR:SYSTEM        NO      /opt/oracle/oradata/pdb_hr/system01.dbf

30   900      PDB_HR:SYSAUX        NO      /opt/oracle/oradata/pdb_hr/sysaux01.dbf

31   5        PDB_HR:USERS         NO      /opt/oracle/oradata/pdb_hr/users01.dbf

32   60       PDB_HR:HR_TBLSPC     NO      /opt/oracle/oradata/pdb_hr/hr_tblspc01.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    60       TEMP                 32767       /oracle/product/oradata/sec_cdb/temp01.dbf

2    20       PDB$SEED:TEMP        32767       /oracle/product/oradata/sec_cdb/pdbseed/pdbseed_temp012015-08-23_10-05-57-AM.dbf

3    60       PDB_PURCHASE:TEMP    32767       /opt/oracle/oradata/pdb_purchase/temp01.dbf

5    50       PDB_HR:TEMP2         50          /opt/oracle/oradata/pdb_hr/temp201.dbf

RMAN> backup datafile 1,26,29 format '/backup/datafile_bkp_%U.bkp';

Cold backup of CDB

Starup the cdb in mount state.

run

 {

 allocate channel a1 device type disk format '/oracle/bkp_seccdb/bkp_cold_%U_%T';

 allocate channel a2 device type disk format '/oracle/bkp_seccdb/bkp_cold_%U_%T';

 backup incremental level 0 database;

 backup archivelog all delete input;

 release channel a1;

 release channel a2;

 }