PDB database recovery in oracle 12c

container database (CDB) recovery is same as normal database recovery .

Pluggable Database (PDB) Complete Recovery

There are two ways to restore and recover PDBs. From to root containers, you can restore and recover one or more PDBs using the following script.

$ rman target=/

RUN {
  ALTER PLUGGABLE DATABASE pdb1 CLOSE;
  RESTORE PLUGGABLE DATABASE pdb1 ;
  RECOVER PLUGGABLE DATABASE pdb1 ;
  ALTER PLUGGABLE DATABASE pdb1 OPEN;
}

SQL> alter session set container=pdb1;

Session altered.

SQL> create table test_dba_objec as select * from dba_objects;

Table created.

SQL> select count(*) from test_dba_objec;

  COUNT(*)

----------

     90780

RMAN> BACKUP PLUGGABLE DATABASE pdb1;

Starting backup at 11-DEC-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=275 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00008 name=/u01/app/oracle/oradata/cdb1/pdb1/sysaux01.dbf

RMAN> ALTER PLUGGABLE DATABASE pdb1 CLOSE;

Statement processed

RMAN> RESTORE PLUGGABLE DATABASE pdb1 ;

Starting restore at 11-DEC-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=270 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/cdb1/pdb1/system01.dbf

channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/cdb1/pdb1/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/cdb1/pdb1/pdb1_users01.dbf

channel ORA_DISK_1: reading from backup piece /media/sf_12cR1/backup/0drn72lv_1_1

channel ORA_DISK_1: piece handle=/media/sf_12cR1/backup/0drn72lv_1_1 tag=TAG20161211T135718

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:26

Finished restore at 11-DEC-16

RMAN> RECOVER PLUGGABLE DATABASE pdb1 ;

Starting recover at 11-DEC-16

using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time: 00:00:00

Finished recover at 11-DEC-16

RMAN> ALTER PLUGGABLE DATABASE pdb1 OPEN;

Statement processed

SQL> alter session set container=pdb1;

Session altered.

SQL> select count(*) from test_dba_objec;

  COUNT(*)

----------

     90780