Flashback Database in CDB

Flash back database in CDB.

a) Flashback database can only be done for the whole CBD. Flashback database cannot be done on the pdb level.

RMAN> flashback pluggable database pdb_purchase to scn 68452044;

Starting flashback at 14-OCT-15

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=21 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=25 device type=DISK

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of flashback command at 10/14/2015 10:03:54

RMAN-05108: Command is not supported for pluggable database

b) If any Point in time recovery is performed on PDB, then CDB cannot be flashed back to the earlier point

   than the PITR perfomed on PDB.

Eg.

Point in time recovery is performed on 10th Oct 7.am. for PDB db pdb_purchase.

Now you can perform flashack database to a particular time after 10th oct 7.am. you cannot flashback below that.