Oracle 23c New Features for DBA'sIn Oracle database 20c, flashback and PITR are supported when recovering PDBs to an ancestor or orphan PDB incarnations. That means you can do a recovery for specific PDB if the PDB is in the same CDB level incarnation. Just to mention in 12.1 also we can do flashback and PITR for container databases however that effects all PDB's in the container. While doing flashback or PITR the operation just changes the datafiles pertaining to that PDB and checks the CDB , PDB, ancestoral and current incarnation and performs that operation.
To create restore point for PDB
SQL> CREATE RESTORE POINT restore_point_pdb2 FOR PLUGGABLE DATABASE PDB2;
SQL> ALTER PLUGGABLE DATABASE PDB2 CLOSE;
Pluggable database altered.
SQL> FLASHBACK PLUGGABLE DATABASE PDB2 TO RESTORE POINT restore_point_pdb2;
Flashback complete.
SQL> ALTER PLUGGABLE DATABASE PDB2 OPEN RESETLOGS;
Pluggable database altered.
Follow Me!!!